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 :
Is this 500 updates for all time or reset, let’s say, every month, for example?
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”?
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”?
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.
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.
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.
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.
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.
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.
