Unique Property Number Generation (4 different options)

Need help Database
1

Hi Bubble community, I am trying to create a SaaS app where essentially a user can create a property/entity to then charge payments through.

The four common solutions I’ve found are(I’ve read through the other forum posts):

  1. Use a sequential number
  2. Use a random number
  3. Use a combination of letters and numbers
  4. Use a unique identifier

Each has it’s own host of issues for example sequential may have doubled up users if they register at the exact same time. Random numbers may not be the best either if there is not defining structure to how it is generated.

Since the property entity will be used in the url for navigation, my main concern is security so that you can’t just put in the SN of the property and you access an account that isn’t yours. Is this even a concern or just handled in the privacy settings?

I see companies like Salesforce has their account SN numbers which I assume is for security reasons so I am leaning towards a scrambled SN but I could be approaching this wrong.

Any tips on how to best implement this while focused on security, ease of implementation, and scalability would be great.

2

All Things already have a unique ID property. You don’t need to do this.

1 Like
3

Regarding protection against people just typing in the URL and getting access, your privacy rules can take care of that. Usually something like this:

owner2
owner22110×892 58 KB

If a user logged and their Property Manager wasn’t the same one as the page’s Property’s Property Manager, and they typed in the URL and got to the page they would just see your page with it’s elements, but no data filled in. So you just need a “Page is loaded” workflow with a condition opposite to the privacy rule and redirect them to the homepage or something.

For unique IDs, already built in. Your URL bar would be something like https://yourdomain.com/property/1477501458054x757140743779018500
But no one has to type that because they would be navigating your app picking that property from a list, and that list would be showing a picture, address, name, etc.

1 Like
4

Thank you very much for the advice, this really helps.