Unique user ID - trying to combine multiple inputs to form one unique field

I am trying to create a unique user id built from registration input:

State = ky
City = louisville
count = sequence order of registration

1st person to register in louisville,is kylouisville001
2nd person to register in louisville is kylouisville002

Then the user id added as a new type under user info
I can get the individual data items displayed, but joining the bits of data to form one combined type or item is boggling my mind.

I’m going to try and break this down the best I can.

“State Input’s Value” = ky

“City Input’s Value” = louisville

“Search for User’s [filter: city = City Input’s Value]'s count” = 0
+1 = 1
/1000 = .001 (always format to 3 decimal places)
find & replace periods with a blank space = 001

Now to put them all together, you’ll have to contain the number in a custom state (text value)

So the final expression may look something like this:

“State Input’s Value”“City Input’s Value”“Custom State’s Value” = kylouisville001

This should work when the user count for a specific city less than 1000.

Let me know if this works,
Daniel

Thanks Daniel! I will give it a try and let you know.
Pete.

1 Like