Dropdown Menu Difficulties

Need help
1

Hello Bubble Friends,
Getting a little frustrated with my initial foray into Bubble, ha, so lemme start with something I assumed would be simple:

What am I doing wrong with dropdown menu? This has been exceptionally frustrating.

In my Database, I created:

  • Data Type: Admin QG
  • Data Type Field: Record Size, set as text.
  • Admin QG app data: I created 3 new Record Size field entries intended as default options for the dropdown menu: 12", 10", 7".

In my app:

  • I added a dropdown element
  • Placeholder: Choose Record Size
  • Choice style: Dynamic choices
  • Type of choices: Admin QG
  • Choices source: Search for Admin QG
  • Option caption: Current option’s Record Size

Preview:

  • I expect the dropdown menu to display the options of 12 inch, 10 inch, and 7 inch. But instead, the only option is my placeholder text “Choose Record Size”.

What am I doing wrong?

Now to complicate things:
My intention is to create a quote generator used by employees. Each line item on the quote may contain multiple dropdown menus that are dependent on previous dropdown menus, and when the values of those dropdown menus align it will yield the price for that combination. The employee then enters a quantity for the line item, and an extended price is generated. At the bottom is the sum of each line item’s extended price.

I would like for the admin user to be able to edit the contents of the dropdown menu (and the default prices yielded) allowing them to add custom options to the default options.

Some of the fields the employee should be allowed to overwrite the entry, when customization is needed.

Once complete, the employee can save the quote to the database for later reference (with a unique Quote #), and/or can export as a .PDF to send to their customer.

To do this, I am making an admin only page that contains the default options for each dropdown menu, and allow the admin to add/delete options to any of these dropdown menus. These will feed into the actual quote generator page which the employees utilize. Feel free to criticize this workflow if there are better options. I am open to hiding admin only elements on the actual quote generator page itself, if that simplifies things.

So how can the admin add items to the database options that make up the dropdown menus?

For reference, a complete table of items and their prices can be accessed HERE.

Thoughts?

2

What are your search constants?

And what are your privacy rules?

1 Like
3

I knew this was going to be something stupid, ha.

So, none of the tutorials/guides I viewed mentioned anything about search constants or privacy rules. I messed around with some privacy rules and the options now show as choices in the dropdown menu. Thank you! I didn’t do anything with search constants though.

Additionally, with that settled, it seems I am able to allow an admin to add options to the drop down menu by adding an input field followed by a button that when clicked > create a new thing > type: Amin QG > set another field: record size = input value.

Now I just gotta find the way to reject the input if one already exists in the database.

1 Like
4

search for Admin QG [where name field is input's value]: count ≥ 1

1 Like
5

This topic was automatically closed after 70 days. New replies are no longer allowed.