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 res…

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

@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…

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 b…

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	24	924	January 17, 2024
🤔 How to: Efficiently get real time calculation sum while from text entry components (w/ pic) Ask for Help	10	986	July 10, 2023
Display Totals Ask for Help	8	1516	April 29, 2020
Show only if updated? Ask for Help	3	549	February 11, 2020
Newbie Q: Computed column not seen on my screen. Suggstions? (w/Vid link) Ask for Help	9	631	May 13, 2023

Advice on best approach

Related topics