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.

[Steve]

What are you looking for from us? If you have a specific problem you need help with, please describe it.

[Nin_o]

Hi,

How do I show the last saved form data (in detail view) after I hit the save button?
I have already created the “Order Detail View”. I’ve set the slideshow mode off because I want to show only the last saved row data and not have the user browse through previous records (I have set the browsing of row records in another view). However, what happens is that after I hit save, the Order Detail view loads the very 1st row, not the row record that I just saved.

[Steve]

Please post a screenshot of the Order Detail View configuration.

[Steve]

Nin_o:

However, what happens is that after I hit save, …

Where are you hitting save? A detail view has no save button.

[Nin_o]

Hi Steve,

I’m sorry if my description is unclear. Here’s what I am trying to achieve:

1. User fills up the Order Form.
2. User hits the Save button.
3. Order Detail view loads up showing the values that was filled up and saved above.

Steps 1 and 2 is working. Step 3, however, loads up the 1st record/row on the table instead of the recently filled up/saved form data/row.

Thanks,

Ninia

[Steve]

You’ll need to create an action (in Behavior >> Actions) of type App: go to another view in this app with a Target expression that targets the newly-added row, the attach that action as the Form Saved event action of the form view.

[Nin_o]

Steve:

a Target expression that targets the newly-added row

Can you give me an example of this? How do you target the newly-added row?

Thanks

[Steve]

LINKTOROW([_THISROW], "detail-view-name")

help.appsheet.com

LINKTOROW()

Constructed deep link to row

[Nin_o]

Hi Steve, here are the screenshots for the Order Detail view configuration.

[Nin_o]

Thanks a lot. You’ve been a big help