HELP: How to get User Input, use input value in a calculation and display the result

[Nin_o]

Hi,

I am total newbie and just exploring. My use-case scenario is as follows:

1. I’ve created a Google Form that captures data from users (some fields are drop-down)
2. Form response is saved in a Google Sheet
3. Calculations are done on the responses sheet on the Googlesheet response table once a Form submission is received (gets Distance between two addresses using GoogleMaps formula and Calculate cost of delivery Fee). This is working fine in Google Sheets.

What I want to happen when I do Create Appsheet, is as follows:

1. Primary View will be the User Input Forms:
   • Starting Address, a drop-down field
   • Destination Address (option to use GPS Current Location or Input Address)
   • A Text Field showing the Delivery Fee (using a formula defined on Google Sheet) . Read-Only field
   • Customer Name Input Field
   • Telephone Number Input Field
   • E-mail Address Input Field
   • Button (Ex: Book Order). Once clicked, the data on all fields is saved to a Google Sheet table (Example: Orders)
2. Secondary View: My Orders (displays the data from the Orders table in Google Sheet.