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

I don’t accept 1oz deviations so I made some changes. :wink: OK, I reworked the formulas and I think I have it matching the dosing table exactly. Liters is a little weird because according to the chart, everything less than 1 liter is calculated to 2 decimal places, but anything larger than 1 lit…

I’m having trouble visualizing how your app is set up, but I was picturing a single row with user specific columns that take the user input and calculate the results. Then they can click a button with an add row action to save it permanently if they want. The next time they go to that screen, you …

Quick background on this project: This task is something that’s going to be dumped on someone who probably doesn’t want to do it and probably doesn’t give a sh*t. I’m trying to make it as simple and easy as possible so our product is utilized properly. OK, so this is the opening page. [image] Us…

A. Do calculations in user sheet, so nobody can see it and others can do their own in the same time… this way it dont need to be usc B. Add row with record to a data sheet C. Users can edit or delete that record

As @Uzo said, you could use the user profile sheet, and filter by signed in user, so you wouldn’t need USC columns, but that’s only if you require users to sign in. But if you are trying to keep it simple, I’m guessing you don’t want to have users sign in. I would still use a user specific column …

And if you have a problem calculating using math column… use YC column with Excel formulas… as @Jeff_Hager says… you will have a delay if calculations are made in gs… I think he is using some query or import range to do calculations… that’s why he insists to use gs… he might be scrapping current ga…

No fuel prices involved. I’m using GS because the glide sheet won’t do formulas like =(MRound(((I2*128)/2500),0.5)) or =IF(J2>128,(ROUNDdown((J2/128),0)),0) What is a YC column?

You can do that calculation in math column. YC … yes code (experimental column), it runs custom code

Do you have some real examples of inputed data and the expected result so I can work out how to structure a math column?

Can I message you the link to the GS?

Time delay clearing fields

Ask for Help

Darren_Murphy August 11, 2021, 3:08pm 20

We wouldn’t expect anything less from Chuck

Topic		Replies	Views
Multi User Calculator Ask for Help	11	1116	September 1, 2020
Was this ever solved? Submitting forms without showing a form Ask for Help	13	586	August 20, 2021
Data from a user-specific column into my google sheet? Ask for Help	26	2668	July 2, 2021
New Row in Spreadsheet for Every User Ask for Help	52	3589	September 26, 2020
Advice on best approach Ask for Help	16	520	August 23, 2021

Time delay clearing fields

Related topics