Hello, I am making an app that is a simple calculator. It is intended to be used by around 30 people at the same time. For each user, I would like them to have their own row in the spreadsheet. Ideally, when a new person downloads the app, a new row is created in the spreadsheet. I am trying to utilize the sign-up email feature to create a row for every user that signs up for the app. So far, I have made the app public with email. I made a column for Signed-Up Email. I made a form button that says “Get Started” when they first sign in. In this form, I included a “Special Value” that adds the user’s email to the spreadsheet. Then, the form button disappears and they can do their calculation. For some reason, this is not working, and the spreadsheet is not updating properly, so no new rows are being created for every email that is signed up. How do I go about doing this?

CALCULUS RESET BUTTON INTRODUCED Okay you can download and copy. I’ve set template to anyone can copy. Gave it a funky name too. Do what you want with it. Tx.

Thank you for sharing your app! When I press 0%, is it able to clear the entry fields too, or is does it just clear the calculation at the botttom?

@Wiz.Wazeer I can’t clear your fields when I press 0%… Am I doing anything wrong? [image] I can see that you have a similar Calc like mine so, can you replicate our case trying to clear your 2 fields using your trick? [image] Thanks in advance Saludos Gavp

@emvu826 According to what I have read and studied so far, there is no way to create a direct button (from Glide) able to fire a script into Google Sheet. The workaround is to use a timed trigger but you’d wait up to 3 min to see the event you are wishing… I don’t like that idea! Maybe @George_B or @Jeff_Hager have seem this problem earlier and have other solutions but to me, this kind of problem can be solved easy if the If-Then-Else tool will be able to write to another column (cell) directly. A medium modification in its capability will be a amazing!! [image] In my pic, the action could be read as: If My Reset Button (ResetButton) is ON (set to TRUE) Then Cell D (MyField) will set to 0 With this, the problems associated to triggers in Google Sheets will decrease and we’ll save a lot of time. Any other suggestion is welcome! Saludos Gavp

Refresh the screen. Mine clears the percentage fields not the other entry fields. If you want to clear all entry fields you have to set the 0 to clear all entry fields. I’ll send you an example.

We’re releasing this next week!

David, so do I not get a treat for launching the RESET button before you guys!!!

Oh no, I was commenting on the title of this topic—new rows for new users.

HI Wiz, May I see the behind the scenes of your reset calculator app? Or allow people to copy the template?

Wow, I am blown away…So I am looking at your data trying to understand the “Home” sheet and the “Options” sheet. I see that in your Home sheet, you have two columns both called Reset. Then in your options sheet, you have two columns called “Calculator” that both have the word reset in it. How exactly does this reset the entry fields? I’m not sure how this works; seems like magic to me.

New Row in Spreadsheet for Every User

Ask for Help

emvu826 April 8, 2020, 9:05am 20

That’s awesome! Good luck with the script writing - hope you can figure it out!

Topic		Replies	Views
Google Sheets built-in "On form submit" trigger Ask for Help	61	7178	January 26, 2021
🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES! Project Showcase	88	7369	September 10, 2021
Foglio con calcolo Ask for Help	54	2931	October 7, 2020
OnChange trigger Ask for Help	29	7538	January 3, 2022
Button in Google Sheet to 'Clear/reset' Ask for Help	14	9711	March 2, 2022

New Row in Spreadsheet for Every User

Related topics