Unique id - sequential order (and linking between forms)

[ivanradisson]

Hi,
I have two questions:

1. Is there a way to generate a unique id that consists of a sequential number? (eg. 001, 002, 003).
2. Is there a way to use this id to link submissions between two different forms ?

Here’s the scenario:
Let’s say there are 2 forms.

On the first one, I’m registering Users that will benefit from Services. For each submission I would like to automatically generate a sequential code (001, 002, 003). If this isn’t possible, it’s ok, I can manage with non-sequential, as explained here.

Then, on the second form, when registering Services that have been provided, I would like to say who benefitted from it. Is there a way to pick from a list of existing Users?

[Kal_Lam]

@ivanradisson, maybe this approach discussed previously should also be helpful for you:

Automatic code generation (Creating unique SN or UID)

@jessicanon, maybe you could do it as outlined in the image shared below: In the survey tab of your XLSForm: [Image 1] Data entry screen as seen in Enketo: When nothing is entered [Image 2] Data entry screen as seen in Enketo: When the name is entered [Image 3] Data entry screen as seen in Enketo: Now for other entries, you will not need to enter anything [Image 4] Reference XLSForm: Last Saved.xlsx (10.0 KB)