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.
Thanks
@Jeff_Hager I can get everything to work BUt
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.
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!
