Creating users with a unique membership number

Hello There

I would like to have my app generate unique new membership numbers on sign-up.

So I created a custom function that generates the number (In my desired format) and it works.
I am struggling to create a conditional action to check that number against the base of existing users and then regenerate IF the number already exists.

I am new to FF and come from the Outsystems platform where I would have created this DB query in preparation for the page (Onload) then I would add the new membership number once the user creates their account.

Any thoughts would be helpful.

2
2 replies