# Ask about row and update **URL:** \ **Category:** Ask for Help\ **Created:** [February 13, 2024, 11:18am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777 "2024-02-13T11:18:25Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 13, 2024, 11:18am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/1 "2024-02-13T11:18:25Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 13, 2024, 11:38am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/2 "2024-02-13T11:38:53Z")
> [@Yoga](#): > > Is this 500 updates for all time or reset, let’s say, every month, for example? It is reset every month. > [@Yoga](#): > > 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”? 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. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 13, 2024, 11:44am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/3 "2024-02-13T11:44:04Z")
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? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 13, 2024, 11:44am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/4 "2024-02-13T11:44:41Z")
> [@Yoga](#): > > - Is this 500 updates for all time or reset, let’s say, every month, for example? Updates reset every 30 days at the end of your billing cycle. > [@Yoga](#): > > 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”? 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. > [@Yoga](#): > > 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”? 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. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 13, 2024, 11:50am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/5 "2024-02-13T11:50:02Z")
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. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 13, 2024, 11:52am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/6 "2024-02-13T11:52:52Z")
> [@Yoga](#): > > 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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 13, 2024, 1:44pm UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/7 "2024-02-13T13:44:30Z")
> [@Yoga](#): > > made the formula in the gsheet where in specific column, it will generate another numbers (let’s say percentage). 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. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 14, 2024, 2:02am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/8 "2024-02-14T02:02:22Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2024, 2:50am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/9 "2024-02-14T02:50:00Z")
What does the math formula book like? ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 14, 2024, 2:56am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/10 "2024-02-14T02:56:57Z")
Hi @Jeff_Hager it goes like this for example : =IF(C1=“Fully owned”,“5”,IF(C1=“Rent”,“3”,“1”)) or maybe something like this : =IF(AND(A1\>3,A1\<0),“Invalid”,IF(AND(A1\<3,A1\>0),“Valid”)) I have no idea yet to turn this formula into Glide math logic. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 14, 2024, 2:59am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/11 "2024-02-14T02:59:59Z")
I did see the “if \> then \> else” logic in Glide table. I think I will give it a try. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2024, 3:07am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/12 "2024-02-14T03:07:04Z")
Yeah, none of that is math, so the IF column is your best bet. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 14, 2024, 3:07am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/13 "2024-02-14T03:07:09Z")
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? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/5/d54307802e9a87b0e882846b7b6a26db39df3f2c.png) For example if I type the formula in excel, it will be : =IF(C2\<4,D2+E2) @Jeff_Hager ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2024, 3:08am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/14 "2024-02-14T03:08:07Z")
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. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 14, 2024, 3:16am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/15 "2024-02-14T03:16:57Z")
@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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 14, 2024, 4:00am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/16 "2024-02-14T04:00:41Z")
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. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 14, 2024, 5:12am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/17 "2024-02-14T05:12:29Z")
@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. ---
**Author:** ![Yoga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yoga/32/70778_2.png) [@Yoga](https://community.glideapps.com/u/Yoga)\ **Post date:** [February 14, 2024, 5:14am UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/18 "2024-02-14T05:14:17Z")
Sorry, just got it. I found rollup function. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [February 14, 2024, 10:57pm UTC](https://community.glideapps.com/t/ask-about-row-and-update/70777/19 "2024-02-14T22:57:01Z")
> [@Yoga](#): > > Quite mind-blowing for me, but I will try 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.