Hi everyone! I am new to Glide, and I’m having trouble to assign a sequential number to each new form submission. This numbering is not assigned by the users when they submit the form, it should occur automatically so i can use it to be reference for a search. I can do this in EXCEL by adding the …

[image] Beardi: I don’t have the option to link the Template column of the Lookup table with the OS table I don’t understand what you are trying to do. In @Darren_Murphy ’s example, he is just using the second template column to attach the letter ‘U’ to the number. He is not doing anything w…

[image] How do I create an auto-incrementing row number with Glide Tables? Community Resources This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers.…

Okay, but it seems that this only works for inserting new forms into the User sheet. However, I need the data entry to be in another sheet, and when I try to create the Template Column, the option for the other sheet does not appear, only for the Users sheet. I’m not sure if I explained it correctl…

I think I need more information. The methods shouldn’t be applicable to only the user table. The same techniques can be used anywhere. Also, it would be helpful to know which of the two methods you are focusing on.

It would be the first case. I have a limited number of 3 users, and initially no new ones will be added. In another table, I have the data for the Service Orders (SO) that these users can open, and each SO can be placed in different statuses, and they can also be closed or reopened. Since each SO …

[image] Beardi: Since each SO will be in different statuses, and the user does not have access to all of them, they cannot know the number of the last admitted SO, and consequently could include an incorrect number. This shouldn’t matter. In @Darren_Murphy ’s example, he has a separate Lookup…

The problem is that I don’t have the option to link the Template column of the Lookup table with the OS table; there’s only the option for the user table. How can I make the other tables I created appear for the Template? I didn’t thank you earlier, thank you for the help! [issue]

It worked. I was the dumbass who wasn’t doing the right relation. Thank you very much for your patience and attention, it helped me a lot.

Sequencial Number on New Form entry

Ask for Help

Jeff_Hager February 23, 2024, 1:55pm 2

Topic		Replies	Views
How do I create an auto-incrementing row number with Glide Tables? Community Resources tutorial	54	10517	April 18, 2025
Does glide have auto increment id ?or number other than this one Ask for Help	2	194	November 25, 2024
Increment Personal ID Number for new User Ask for Help	4	1998	October 5, 2021
Auto Numbering Ask for Help	58	7804	April 18, 2025
Add rows sequentially Ask for Help	1	297	October 18, 2023

Sequencial Number on New Form entry

Related topics