# How do I create an auto-incrementing row number with Glide Tables? **URL:** \ **Category:** Community Resources\ **Tags:** tutorial\ **Created:** [March 13, 2022, 4:33am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572 "2022-03-13T04:33:25Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![marcos\_correia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/marcos_correia/32/54954_2.png) [@marcos\_correia](https://community.glideapps.com/u/marcos_correia)\ **Post date:** [March 24, 2023, 9:25pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/22 "2023-03-24T21:25:43Z")
Preciso fazer com. que o sistemas ema gere numeros automatico a partir de um numero de referencia… ex. 5300 - ai quando cadastrar os novos numeros, eles seram a partir deste numero. ---
**Author:** ![siraj-samsudeen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siraj-samsudeen/32/54801_2.png) [@siraj-samsudeen](https://community.glideapps.com/u/siraj-samsudeen)\ **Post date:** [April 2, 2023, 4:46am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/23 "2023-04-02T04:46:31Z")
Thank you so much. I was able to achieve this - the videos took sometime to load. Is it because it is on another platform? It would be helpful to have these 2 videos on YouTube - very useful for a common scenario. ---
**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:** [April 2, 2023, 4:51am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/24 "2023-04-02T04:51:04Z")
The videos are hosted on Loom. They should load and play normally (they do for me). I don’t maintain a Youtube channel, sorry. ---
**Author:** ![siraj-samsudeen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/siraj-samsudeen/32/54801_2.png) [@siraj-samsudeen](https://community.glideapps.com/u/siraj-samsudeen)\ **Post date:** [April 2, 2023, 4:59am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/25 "2023-04-02T04:59:54Z")
I understand that you hosted it on another platform Darren. For some reason, it took a long time to load for me. May be, Glide has some place for aggregating very useful community content like this? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 3, 2023, 12:24am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/26 "2023-04-03T00:24:41Z")
I’m loading it normally here. Chrome on MacOS, Vietnam. ---
**Author:** ![Werther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/werther/32/60106_2.png) [@Werther](https://community.glideapps.com/u/Werther)\ **Post date:** [June 7, 2023, 1:53pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/27 "2023-06-07T13:53:53Z")
Hey, guys Great videos and tutorials, thanks for that. Unfortunatly, I’m having this strange problem in the final step: the increment action just isn’t working on my relation column, and I really have no clue why. Could someone enlighten me? I did just like in the first video, created a table only for the increments and relation, but when I try to create the action to increment the column by 1, Glide simply does not let me select the column and I can’t figure out the reason for that behavior. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27cbdb69dd9c9b0c4136155b9fb1f7e8a4b4d851.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6fefdf6c158961ba207300bd38f54248a1fae9b7.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/332ddfa51f8ffe9713ee193beb56d7fc0e3d9487.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bba8834945061cb7ce3b34b10c955afa457df8b3.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b0f62c0c453e9bd372c3d6bc4da98732219b622c.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/6/4684ba2651a200cad72c9c014fa7d8a96b376f6f.png) (right here glide shows me the column I really want to increment, but when I click on it simply doesn’t select it) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9ba6fb2f6e673e26d3b7edc912ef23e59f8d3c2e.png) (and then it stays like that) Thanks in advance, guys ---
**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:** [June 7, 2023, 2:41pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/28 "2023-06-07T14:41:22Z")
I’m able to reproduce the behaviour you are getting there. It appears to be a bug. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 8, 2023, 12:01am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/29 "2023-06-08T00:01:55Z")
Darren has reported this to the team. We’ll let you know if there are any updates. ---
**Author:** ![Joseph\_AMMAR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_ammar/32/65416_2.png) [@Joseph\_AMMAR](https://community.glideapps.com/u/Joseph_AMMAR)\ **Post date:** [October 20, 2023, 12:20pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/30 "2023-10-20T12:20:40Z")
Hello, I used the same method, but when I add a row in my users table, the column that retrieves the next user ID does not load, so I have always the same USER ID for the next user and so on. I should refresh my page so the column takes into account the next user ID. I have a free version for testing, is it the problem ? ---
**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:** [October 20, 2023, 12:35pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/31 "2023-10-20T12:35:53Z")
Does your Users table have Row Owners applied to the email column? ---
**Author:** ![Joseph\_AMMAR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_ammar/32/65416_2.png) [@Joseph\_AMMAR](https://community.glideapps.com/u/Joseph_AMMAR)\ **Post date:** [October 20, 2023, 12:58pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/32 "2023-10-20T12:58:56Z")
What do you mean by row owners ? row IDS ? In my case, I have a simple table for users with the next columns : ROW IDS Email Points Another table for the products with the next columns : ROW IDS Name of the product Price (currency = points) Another one for the orders with the next columns : ROW IDS Number of order User Product ordered And last one for the parameters where I have two columns with one row : “Last number of order” : single value that retrieves the last value of the column “Number of order” in the orders table “Next number of order” : Math operation : Last number of order + 1 The problem is that when i add an order in the ORDERS table, the table of PARAMETERS does not refresh and does not get the last number of order in the ORDERS TABLE. I have to refresh so it could work … I hope it is clear. ---
**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:** [October 20, 2023, 1:01pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/33 "2023-10-20T13:01:54Z")
> [@Joseph\_AMMAR](#): > > “Next number of order” : Math operation : Last number of order + 1 Can you show me how you are using this column? ---
**Author:** ![Joseph\_AMMAR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_ammar/32/65416_2.png) [@Joseph\_AMMAR](https://community.glideapps.com/u/Joseph_AMMAR)\ **Post date:** [October 20, 2023, 1:26pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/34 "2023-10-20T13:26:26Z")
Question : is there an option to refresh data while configuring the actions ? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/4/04f97fbb9cf25ed02e49b857842b12b84b5d4b38.png) ---
**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:** [October 20, 2023, 1:37pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/35 "2023-10-20T13:37:27Z")
> [@Joseph\_AMMAR](#): > > Question : is there an option to refresh data while configuring the actions ? Only with Big Tables, but that won’t help you here. If I understand correctly what’s going on in your screenshot, it looks like you’re first using a Set Column Values to write a value to your User Profile Row, and then immediately use that value in an Add Row action. Is that correct? If it is, I wouldn’t expect that to work reliably. A better approach is to create the Single Value and Math column in your User Profile Row, and then use it in your Add Row action. Also, given that you are using Add Row, I assume that means you are using a Custom Form, and not a native Form? ---
**Author:** ![Joseph\_AMMAR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_ammar/32/65416_2.png) [@Joseph\_AMMAR](https://community.glideapps.com/u/Joseph_AMMAR)\ **Post date:** [October 20, 2023, 1:42pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/36 "2023-10-20T13:42:35Z")
Hello, No the set column values is to add another unique id not used in this automation. I tried to do what you proposed : create a single value and math column directly in the user profile row, but I have the same problem ---
**Author:** ![Joseph\_AMMAR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_ammar/32/65416_2.png) [@Joseph\_AMMAR](https://community.glideapps.com/u/Joseph_AMMAR)\ **Post date:** [October 20, 2023, 1:44pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/37 "2023-10-20T13:44:38Z")
The problem is when I add a new order with a the next number and then try to add another order after let’s say 5 seconds, the number of the last order does not increment in my user profile row. I have to refresh my data as an editor so It works … ---
**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:** [October 20, 2023, 1:53pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/38 "2023-10-20T13:53:04Z")
Okay, that doesn’t sound right. It should be instant as soon as the row is added. What is your Data Source? Are you using native Glide tables, or some external Data Source? Earlier you mentioned: > [@Joseph\_AMMAR](#): > > “Last number of order” : single value that retrieves the last value of the column “Number of order” in the orders table > “Next number of order” : Math operation : Last number of order + 1 The above are both Glide Computed columns, right? ---
**Author:** ![Joseph\_AMMAR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_ammar/32/65416_2.png) [@Joseph\_AMMAR](https://community.glideapps.com/u/Joseph_AMMAR)\ **Post date:** [October 20, 2023, 2:15pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/39 "2023-10-20T14:15:42Z")
User : google sheets table Orders : google sheets table Products : google sheets table Parameters : native glide table Do you think the problem comes from here ? ---
**Author:** ![Joseph\_AMMAR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_ammar/32/65416_2.png) [@Joseph\_AMMAR](https://community.glideapps.com/u/Joseph_AMMAR)\ **Post date:** [October 20, 2023, 2:16pm UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/40 "2023-10-20T14:16:49Z")
I need to have the users, orders and products always in a google sheets because it is easier to modify and bulk change data whenever we want ---
**Author:** ![ttmmaacc](https://avatars.discourse-cdn.com/v4/letter/t/35a633/32.png) [@ttmmaacc](https://community.glideapps.com/u/ttmmaacc)\ **Post date:** [February 26, 2024, 12:31am UTC](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572/41 "2024-02-26T00:31:27Z")
The videos no longer load. They are just preview GIFs. Can you fix or put them on youtube? [Previous page](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572.md?page=1) [Next page](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572.md?page=3)