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 number of the line (+row()) to a base number, but when I upload it to GLIDE, it doesn’t work.
Is there any method to achieve this?
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 correctly, but i couldn’t aply this method. There is another way to do it?
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 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.
I tried to follow as in the video, however, in the new table created (Lookup), specifically in the second column (template), there is no option to link it to my data table, only to the user table. I don’t know if I’m making a basic mistake, but it seems that there is no option to link to any of the other tables I created.
This shouldn’t matter. In @Darren_Murphy’s example, he has a separate Lookup table. It doesn’t matter if the user has access to all the SO’s or not. All that matters is what the next available number is in that Lookup table. Whenever someone adds an SO, you should be performing an action to increment the number so it’s ready for the next SO. I don’t believe he is using anything like a Rollup that would require access to all rows. He is incrementing the number in a normal number column.
You still want to create a link between the user table and the lookup table. The reason for this is because you ultimately want a single value column containing the next number in the user table as well as the relation to perform the increment. Values from the user table are accessible everywhere in the app, including the form where you would add a new SO, so doing this will make things much easier.
With some very minor differences, such as retrieveing the next number from the user profile and incrementing the next number through the relation in the user profile, everything else should be exactly the same. There are a couple of other things that would make it slightly more efficient, but they wouldn’t change the outcome. You also don’t need to use the OnSubmit action in the form to set the number since you can now add User Profile Value components directly to the form, but you will still need an OnSubmit action to perform the increment.
Keep following @Darren_Murphy’s instructions. The only important differences will come at the end when configuring the form that adds the SO.
Also be mindful that this isn’t a perfect solution. If multiple users are adding SO’s at the same time, then you may get duplicate numbers since this calculations are handled locally on the device before syncing with Glide.
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!
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 with any other table. You don’t even need the template column if you are just expecting a number.
If you follow his example exactly to get the tables set up, everything should work, and like I said the only modifications would be with the form itself.
For the first template column you need the User Row ID like you have from the user profile, but it seems that you are trying to get a sequence number out of it. It should be the user Row ID so you can use it to create the link between the user table row and the lookup table row.
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.
Glad you got it figured out.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
