In the ‘add row’ function, if you add one, the row is added by two. How do I add one?https://drive.google.com/file/d/11mQl1_GO91iftrLZ0jTuIrkVIxkVrbYC/view?usp=sharing

Sorry, ignore the part about China. What I was trying to draw your attention to is the fact that if you are using an Add Form, then it is not necessary to create an On Submit Add Row action. This is the most common cause of duplicate rows being created.

[image] Upon Submit the form, it adds duplicated rows (twice the same new row ID) to the data sheets Report a Bug Are you using an Add Row action on form submit? If yes, then that will be the cause. It is not necessary, as a new row is already created when the form is submitted. PS. You are using this app in China?

no. I am Korean and I use the app in Korea. If so, should I use a function other than File Picker?

[image] Darren_Murphy: What I was trying to draw your attention to is the fact that if you are using an Add Form, then it is not necessary to create an On Submit Add Row action. This is the most common cause of duplicate rows being created. I solved it. Thank you.

Add row function

Ask for Help

Darren_Murphy July 2, 2021, 3:16am 2

Topic		Replies	Views
Double Rows generated by Add form Ask for Help	4	1005	March 2, 2021
Form submission duplicate row Ask for Help	1	250	June 10, 2021
Custom Add Row action enters data twice Ask for Help	4	379	May 10, 2022
Problem with clipping data row in sheet. Duplicating data Ask for Help	4	582	June 24, 2022
Adding 2 rows into my sheet? Ask for Help	2	261	March 18, 2021

Add row function

Related topics