I want to create a email body template for offers when added and updated
there are 5 table referenced to each other through their ID’s whereby each ID column in any of the forms needs to be filled when filling the form and also the 4 table’s form are connected to each other thus all the 5 ID columns are in all the 5 forms
The 5 forms are; Offer form, Invoice form, Company form and contact form, Products
In the offer table there are columns such as Row Id, Company ID, contact ID, Invoice ID, Products, Quantity Date e.t.c
In the Invoice table there are columns such as Invoice id, offer ID, quantity, date, Price, Status e.t.c
In the Products table there are columns such as Product ID, Product name, Sales price, purchase cost, Quantity e.t.c and also ref rows columns which are system generated columns such as related invoices, related offers e.t.c
In the contact table there are columns such as Name. email, address, phone number and also ref rows columns which are system generated columns such as related follow ups and related offers
The last which is the company table, there are columns such as as company Name, company id email, address, Discount, activeness and also ref rows columns which are system generated columns such as related activities and related offers
For each columns, what are the expressions to be used without any mistake or error and ensured smooth running and process of the task
LinkedIn
Twitter
