I have 2 custom checkbox fields I created on the quotes module which are saved to the database. Once the quote is turned into an invoice I want to be able to access the saved data for those 2 fields while I’m entering line items (using the line_items.js file). I am not even sure how I could get data from the SQL Server database from within a javascript file. The invoice and quote would be related but the custom fields I’m not using are not relate fields.
I even thought of possibly creating the same custom fields on the invoice edit layout but don’t want to use a workflow to populate as I need this data immediately (hence the reason I need to do it in the javascript file). I do not want to access from a php file.
I hope someone can provide some insight on how I can accomplish.
Thanks!
Versions:
SuiteCRM 7.10.7
PHP 7.2
SQL Server 2014
Windows Server 2012 R2