Ask about row and update

Hi again,

I want to ask about “update”. I read the definition of “update” is written “update are used to change data and sync changes from external source of data like Gsheet”. Since my plan only allows me to cover maximum 500 updates, I want to ask :

  1. Is this 500 updates for all time or reset, let’s say, every month, for example?

  2. I made this type of page :

which every form in the page will connected to the table from g-sheet. If the form is empty, then the g-sheet will be empty too.

If the user write the information in the form in that Glide page, and of course, it will causes the g-sheet to be automatically filled, is that counted as an “update”?

  1. As you can see in the picture, I made the form to be filled by user with numbers. The numbers written in the Glide App form will be written in the g-sheet. I made the formula in the gsheet where in specific column, it will generate another numbers (let’s say percentage). This percentage created in that column in the g-sheet will be shown in the field in Glide App. Will the percentage that is shown in the Glide page be counted as an “update”?

Thank you for your answer.

It is reset every month.

Yes, but you should ensure that you use User Specific Columns. These do not sync with your Google Sheet, and so will not incur any updates.

Hi @Darren_Murphy Thanks for your answer.

In my g-sheet synced table, there are more than 20 columns per row that should be filled by the user via Glide App. So, if every user update the columns, even it is still in the same row, it will be counted as 20 updates?

Updates reset every 30 days at the end of your billing cycle.

It’s unclear to me if your screenshot is a native form (Show Form Screen or Form Container) or if you are using entry components which a submit button.

With a native form which includes a submit button, one single update is incurred only when you hit the submit button. Filling out the individual fields does not incur updates.

If you created your own custom form, then changing individual fields will incur updates. In my understanding, syncs with external sources such as Google Sheets happen in intervals, every few seconds, so if a user changes fields between two syncs then the batch of changes would incur one single update.

As a general rule of thumb, for updates related to a data add/update/delete, one update is counted for changes to the entire row, even if multiple columns are changed. Note that some integration columns do use up multiple updates.

1 Like

Hi @nathanaelb Thanks for your answer.

It is container, not a submit form. There is no submit button in the page, so it is like mirroring between the page and the data in g-sheet table. I can conclude that it consumes update when every character typed / created / deleted / updated in the form will be counted as an update.

So, I think, it will generate a lot of updates, like a lot.

It won’t be every character, but yes, custom forms will consume many more updates than a native form.

Two ideas:

  • Use a native form with a submit button rather than a custom form.
  • Use Glide Tables instead of Google Sheets, since Glide Tables don’t incur updates.

Couldn’t you move to math logic into Glide so you don’t have to rely on the google sheet so much. If you can move everything into a Glide table, then you won’t have to worry about update counts.


Hi @nathanaelb and @Jeff_Hager

Thanks for your answer.

I haven’t try the Glide Table yet, But from I saw at a glance, I think, the way the math logic is translated in Glide Table (math) is different from google sheet or excel. I think I will struggle a bit to understand. I don’t understand any code at all since I am not a developer, but I do use excel formula a lot.

What does the math formula book like?

Hi @Jeff_Hager it goes like this for example :

=IF(C1=“Fully owned”,“5”,IF(C1=“Rent”,“3”,“1”))

or maybe something like this :


I have no idea yet to turn this formula into Glide math logic.

I did see the “if > then > else” logic in Glide table. I think I will give it a try.

1 Like

Yeah, none of that is math, so the IF column is your best bet.

I think have found the thing that I don’t understand here in this “then” logic.

How can we add calculation in this “then”? Is it value only?


For example if I type the formula in excel, it will be :



You can do the math in a math column, and then have the IF column return the result from the math column is it matches your condition.

1 Like

@Jeff_Hager so let’s say in math column, it calculates without condition. Then in IF column, what should it shows depends on the condition written.

Quite mind-blowing for me, but I will try. Thanks Jeff.

1 Like

Yes that is correct. Instead of doing it like you would in Excel in one column, you just need to split it up a bit into separate columns and bring it all together in the end with the IF column.

@Jeff_Hager How we can use formula like COUNT and SUM in Glide Table? I would like to count how many rows that is already created, and total of number in the column.

Sorry, just got it. I found rollup function.

1 Like

In Excel or Google Sheets, you can write a function, which you can wrap inside another function, which you can wrap inside another function, which you can wrap inside another function, and so on. This is an onion method where you build (and understand) functions built inside one another from the inside out. A complex function can be in its own column. You could break up a complex functions into many columns, and this in fact can be done to troubleshoot.

In Glide, each computation must be in its own column. In a way, the approach in Glide is cleaner, more logical.

1 Like