I have input fields with costs and prices. I want to be able to use them in a calculation, then show the result, And generate a historical list of all results for the user to track their history. I have added number input fields. What is the recommended way to use the data in formulas, show the results, then save the results in a list for them?

you can add a button, with acton to add row, and set values with results to a data sheet… to do this automatically… you need a help of scripts

Read through this thread. I have a sample app in there as well. You shouldn’t need any scripting. All you need is some user specific columns and some math columns to perform your calculations. [image] Time delay clearing fields Ask for Help I’m looking for a way to delay the clear fields action. The app shows the user the results of the ratio calculation from the top row of the GSheet. I have an onchange trigger which clears those results when a new row containing user email, timestamp, amount of “A” and amount of “B” is added. This also clears the results from the UI. I need those results to “stick” in the UI for some amount of time as the operation the user is performing will take, lets say, 5 minutes and the user may need to re…

@Jeff_Hager I can get everything to work BUt I am stymied by how to show the result of the calculation on the screen so it updates in real time before saving. I can´t find the template column choice for the screen. they have to be able to play with a few scenarios until the find the one they like, and then hit the button to save to a log sheet, with a user specific column of the result to track history in a table. Not sure why it is so hard for me to figure out considering you did the app and I can look at the darn thing, but I find no choice to show what I think is the template field on the screen

Can you share your app or some screenshots showing how you have everything set up? Are you trying to do this on a form or on a detail screen?

detail screen… [2021-08-23_13-08-07 app] they fill in the info and the app shows how much they need to sell to keep at least the same profit as when not promoting. I want to show the results in real time until the click the button and the row is created, and the log table updated just below the button.

It looks like you don’t have any text components to display a template or math value. Are you trying to show the result in one of your entry components? That would explain why you can’t select a template column.

the fields: [2021-08-23_13-13-55 app fields]

no, I want them in a seperate component to show while they play around with the data to find the right price volume they want. then after using the button, to show up in a historical list tied to their unique email.

Right, but have you tried to add a text component to display the result? I don’t see any components to display the result on your screen. [image]

Advice on best approach

Ask for Help

Jeff_Hager August 21, 2021, 1:32am 3

Read through this thread. I have a sample app in there as well. You shouldn’t need any scripting. All you need is some user specific columns and some math columns to perform your calculations.

Topic		Replies	Views
Time delay clearing fields Ask for Help	23	1064	August 11, 2021
🤔 How to: Efficiently get real time calculation sum while from text entry components (w/ pic) Ask for Help	10	1046	July 10, 2023
Display Totals Ask for Help	8	1564	April 29, 2020
Show only if updated? Ask for Help	3	569	February 11, 2020
Newbie Q: Computed column not seen on my screen. Suggstions? (w/Vid link) Ask for Help	9	694	May 13, 2023

Advice on best approach

Related topics