Answer the question
In order to leave comments, you need to log in
How to avoid skipping rows when updating data in a table?
Passing form data to google spreadsheet. BUT when I delete unnecessary data from it, the following answers are published with skipping lines.
How to avoid it?
Answer the question
In order to leave comments, you need to log in
What are you using to send data to google spreadsheet? Plugin or custom code?
Most likely, somewhere on your site (for example, in a database) the number of the last filled line is stored. And the next time the form is submitted, the data arrives at line number +1. And since you manually deleted rows from the table, avoiding the site, then these gaps are obtained.
Before sending data to the table, you can get data from it, find the last filled row (at the current time) and put the data in the next row.
> when I delete unnecessary data from it
Google has a simple logic - I look for the last empty line and insert values there.
If you have, for example, the range A1:Z999 is empty, and there is something in cell Z1000, then Google will insert new values under the last line.
I think the problem was that you did not remove all the data from the rows and therefore there was a gap. And when the lines themselves were deleted (that is, the data was deleted), the problem disappeared
In any case, the layout width is 1920px for background images, but the site grid is centered as a priority. In most cases, 960px will be displayed well everywhere, but it’s already necessary (possible) to draw on the bootstrap grid, and there 1170px.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question