I tried other posts and a lot of videos but couldn’t figure it out.
I need to add a simple column similar to auto_increment columns in SQL.
Basically, this column gets a unique number every time a new user signs up and creates a new entry in the database.
Can you guys help me out?
Thanks
Farhan
Why? Bubble has a unique id you can create primary and foreign key relationships with.
I didn’t want to use it. But apparently, I have to use it…
What’s your use case? Are you wanting something more like microsoft access primary key auto increment? You could implement such a thing, but I really think it’s inefficient in bubble.
Just building an app that allows users to create multiple rows in different tables (database). Then I’m using the unique ID to call those values and display them in their dashboard using the same unique ID.
Just wanted to have another column for user ID generated using autoincrement while they signup. But that’s way too complicated I suppose…
To cross reference or JOIN ON in bubble you would have a field in 1 table of another table type. For instance, if you’ve got your user table User and wanted to ‘JOIN ON’ Users Contacts you would have a field called Users Contacts (or really whatever you wanted to name it) of type Users Contacts. You wouldn’t store the unique id in a text field and do a search on it.
Well, I’m using unique ids to map these rows while calling for the specific user. Creating another column for userID with autoincrement numbers seems a bit hassle in bubble.io.
