Option Picker Issue

[navedsk]

Hi everyone,

I'm new to Budibase and here to learn.

I'm currently working with a form that includes multiple option pickers. The issue I'm facing is that when I select one option and then try to select another, the other option disappears.

I have a database provider set up, and I've applied filters so that when the first option is set to a specific value (e.g., "Something"), the second picker should only show options related to that selection. which works but going back to select any other options is a issue.

additionally,

how do i remove the first blank option?

[mikesealey]

Hey @navedsk

The issue I'm facing is that when I select one option and then try to select another, the other option disappears.

From the documentation:

The multi-select option is almost entirely the same as the Options Picker, with the only difference being you can select more than one option in the dropdown.

Docs on Options Pickers

Docs on Multi Select Pickers

how do i remove the first blank option?

It depends on how the value is populated. In the settings you'll see "Options Source" - Schema, Data Provider, or Custom.

If you're using this form component as part of a Form, the "Schema" setting will fetch options for the Form that correspond to the table you're writing to. In this instance, these values come from the Single-select column where a value is required for each option.

You could also choose to fetch options with a Data Provider - this is useful if you wanted to show a human-readable value to the user but use something less friendly under-the-hood. In my example I've got a list of dishes and their price in a table, which I fetch with a Data Provider

Then in the settlings for the picker, I can use the name of the dish to display for the user, and hold the price as the "value".

Something like this could be used to calculate a price for each diner's meals. In this instance, having a row in the "menu" table without a value in the "label" column may cause an empty item in that list.

You could also use the "Custom" setting for the options, and Define options like that - again having an empty "label" for the option might cause this behaviour.

[navedsk]

Hi Mike,

Thanks for the quick response.

As I mentioned, my database is coming from a data provider and it's a very simple table. However, I'm still a bit confused by your answer.

What I'm trying to understand is:

How can I remove the initial blank option from the dropdown?

How can I reset the dropdown to show all available options again?

Right now, once I select an option, I have to manually select the blank option to make the full list reappear in the option picker.

[mikesealey]

Sorry, I've misunderstood something here.

It looks like your filtering isn't set up the way you expect it to be. If selecting an option in the first Options Picker limits options in that options picker you're probably filtering it with it's own value - you should be using two data providers, one for each dropdown, and using the value from the first to filter the second.

Also, just for clarification - What do you have set as your placeholder text? If you return an empty value it should default to "Please choose an option" but if you pass in a space it will prevent the default value being used, but also show nothing - I suspect something like this is the case. Please clear your Placeholder text value.

[navedsk]

I've removed the space from the placeholder text, which was causing an issue earlier.

Now, I’d like to know if there’s a way to remove the default "Choose an Option" label in the dropdown, so that it directly shows the available options without that initial prompt.

Also, to clarify my setup:

I’m using a single data provider for all the option pickers. The data is filtered dynamically based on the selections made in these pickers. For example, selecting a value in the first option picker filters the available options in the subsequent pickers — and that part works perfectly.

What I’m trying to achieve now is to configure the first option picker so that it shows both my options when i select any of the options.

[mikesealey]

I think you want this...

[navedsk]

yes i want that.
Thanks so much! let me go through it. I appreciate your Fast replies. !!!

[navedsk]

well i tried but it doesnt work.