Advice on best approach

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.



@Jeff_Hager I can get everything to work BUt

  1. I am stymied by how to show the result of the calculation on the screen so it updates in real time before saving.
  2. 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…

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:

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.

not yet but I will

for some reason the app will not let me input text to test the input fields,
and the action text field needs to be tied to the temporary input, before I press the button and save to a line, so I am pretty sure the math column is not goint to work without the data already being saved. Obviously I am missing something obvious

the problem lies in knowing how to link the template column to a calculation using the temporary numbers to define the quantity to sell, like a copy of the math column but to use with the numbers not yet saved and show the result in real time so they can decide if they need to adjust before saving.

how to use the numbers in the number input field before saving them to perform the calculation of quantity to display, If there is a document on how to do this you can direct me there, I hate bothering you. But I cannot find help on the site using search.

The Action Text column won’t show if there is no value.

Also, if you can’t edit anything, that means that your screen isn’t attached to a row…meaning that you either don’t have any rows in the table, or you have a filter on the screen that filtered out any valid rows. In my example, I have a single row, so the screen can attach to that row and my entry components will update those columns in real time. That’s why I have the one row with an ‘x’ in my example. That was just to generate a row so that I can edit it with the entry components.

The rest should just work since you aren’t using a form. The math and template column will dynamically update as you enter values. Once you have everything entered as you like, then the button will perform an Add Row action which will take all of those entered values and the calculated result and you can write them to a log sheet.

I’d also like to mention that the columns that you fill with the entry components should ideally be User Specific columns. That way multiple people can use the app and update the values without interfering with any other user that may be using the app at the same time.


Great, thanks!

1 Like