F
F
firemark_s2016-12-11 21:35:34
Google
firemark_s, 2016-12-11 21:35:34

How to transfer data from 2 forms on the site to one Google Spreadsheet?

Site of 3 pages
1 page - form 1, the data from the completed form is transferred to the Google table
2 page - form 2, the data is transferred to the same table
3 page - thank you for filling
out what is the problem:
1. when one user fills out the first page, the data is stored in the first row in the table, when the second page is filled, the data is transferred to the second row of the table - it is necessary that everything be transferred to one
2. due to the fact that the data is transferred to different lines, it turns out that if 2 people start filling out at the same time, then their data is mixed
user 1 > page 1 > row 1
user 2 > page 1 > row 2
user 2 > page 2 > row 3
user 1 > page 2 > row 4

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Victor Golovko, 2016-12-11
@siptik

Send data to the table when it is fully formed, not in pieces. Or look in api how to get the line number in which the data is entered, and edit (update) this line in the second step

D
Dimonchik, 2016-12-12
@dimonchik2013

pass in two tables
only xs if someone has not filled in))) an empty line upon filling in the first

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question