I'm trying to associated ID's to the data I store in the DB tables

Hi guys, I’m a newbie, I want to say I appreciate all the help and support from the community, it has been so valuable.

Could someone please point me in the right direction? I’m creating a restaurant/RSVP app. I have designed a page where guests have to enter their names, when they click the enter button their name gets stored in the database. I know within bubble you can get the unique ID, but is it possible to generate your own ID on the fly and store it in the DB as I will like to use it later, for bookings, orders and payments?

For example, Mary Smith enters her name on the form. She clicks the enter button, and a guest ID is generated against her details and stored in the database

Thanks for your help in advance

What’s the purpose of this additional ID?

Yes, you can create a random number/string for each Guest and Store that.

That would be part of your workflow on hitting Enter.

It is in (rather confusingly) Calculate Formula.

Hi adamhholmes,
Thanks for reaching out.
I just thought creating my own IDs across each data type would allow me to trace guest orders more easily throughout the whole order process. I thought because each field type just states a unique ID so it will become difficult to keep track of which ID below’s to what. I might be wrong in my thinking, I have never done anything like this before.
The basic flow is

Guess enters their name, they then select menu items, the items are stored in a basket, they confirm their order, the order is held in a pending state, it gets sent to the event admin, the event admin puts the order through.

I need to be able to link the guest to their orders.
Thanks

1 Like

Hi NigelG,
Thanks for responding to my message. Thank you for providing me with a solution, I really apricate the time taken to do so.

I will try this and let you know how I get on. Thanks again, super helpful.

2 Likes

You don’t need any IDs to do this (not even the Bubble unique ID)… just link the guest to the order directly…

3 Likes

I was thinking that just encase guests have the same name, I would be able to use the guest ID to link guests to their event, order and booking.

Hi Nigel, thanks for this, I failed my first couple of attempts. I will try again and hopefully have a mini break through.
Thanks

I was thinking that just encase guests have the same name, I would be able to use the guest ID to link guests to their event, order and booking.

Guest names are irrelevant… don’t refer to a guests name… refer to the actual guest…

You’re making this much more complicated than it needs to be…

2 Likes

Thanks for the tip, I’ll do that. Thank you, really need and appreciate the help.

1 Like

Hi NigelG,

Thanks for this; it’s working now. Thanks for helping out.

1 Like