User input into Google Sheets?

Ask for Help
1

I have synced Glide and Google sheets and when I input data onto Glide input which is connected to a Google Sheet, the data show in Glide but not in actual Google Sheets

But when I input on my Google sheet, the data correctly show up in Glide.

Is it possible to input data onto Google sheets when they submit a form in Glide?

3

Do you have any empty rows at the bottom of your Google Sheet?
If you do, scroll all the way to the bottom and check if there is anything there.

1 Like
5

Oh… I have set formulas in the empty cells all the way down to 1000th row, how can I make the user input into the next row instead of 1001th row? User inputs will be only in Column A-E and the rest is filled with formulas.

6

Yes, if you have formulas in your spreadsheet, Glide will see those rows as not empty and will add new rows at the bottom. There are a few ways to deal with this.

  • Option 1: Convert your formulas to arrayformulas and delete all empty rows.
  • Option 2: Get rid of your spreadsheet formulas altogether and replace them with Glide computed columns.

Option 2 is generally the better option, but it depends on the nature of the formulas and whether you actually need the calculated results in the Google Sheet.

2 Likes
7

Thank you for the answer.
I think I will first try to copy the same functions in Glide as well to see if I can

8

If you have trouble with that, feel free to ask for help. Many of us are quite experienced with this topic.

1 Like
9

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.