In this example, we are using the quotation spreadsheet proposed in Appizy samples. This workbook has two tabs: one called Interface with the actual form and another one named Data for calculations. The second tab is hidden. Download the file and display the tab content for a better understanding of the file construction.
The top part of the file is a classic contact form with Name and Company. Then comes the quotation inputs (for an imaginary T-Shirt reseller): size, color, and quantity. Based on the quantity selected, the spreadsheet calculates a discount and the total estimated price of the order.
To receive data in SmartForms you need to add a named reference to the cell you want to collect. In our example, the cell B10 is named "total".