Dynamic Chance OptionPicker

[Balowser]

Hey,
i have an optionpicker with some fixed values.
Now I have a form which fetch ghe data from an api.
Now i have created a update sidebar. When I click on a row all values should get shown in the sidebar.
All "normal" fieles ware working. But not I habe a Boolean-Column in the form and want that the option picker gets the value of the boolean field of the clicked row.

I tried it with the Update Field Action, but the picker don't change.

Could someone help me?

[ondarrataberna-dotcom]

The same problem! I have a form with some text fields, date picker and option picker, and a table with data. When I click on a row I wish to populate the form and all the fields works fine but the options pickers.
The form is custom type form.
The optionspickers are populated by a data providers that get (id, value) from database. Each optionpicker have is own dataprovider.
The data are checked and are ok.
I tried the update field action (working fine with other type of input fields) and with restore to default action by setting the default value to a sistem variable and updating it before launching the restore action.
In both cases the option picker lost the translated placeholder "elegir una opción" (in spanish) and reads "choose and option" but do nothing more.
Furthermore the opcion picker do not accept a default value, same behaviour lost custom placeholder.
It seems it appens only with dataprovider option pickers, if the option picker is custom type it works fine... maybe a bug?

Workspace is 3.18.0 working on premise

Every help is apreciated

[mikesealey]

Hey @Balowser @ondarrataberna-dotcom

There's a user experiencing similar issues in: #17043 but I've not been able to recreate the problem. If you could upload a workspace-export it might help us debug the issue.

Please replicate the issue in a separate, dummy app, and don't upload your production app. If your app is working on external tables, please also provide the create scripts for any tables you're using. I'm not looking for your whole app, just the simplest recreation of the issue.

[IchthysMaranatha]

This is a data type issue. It can show the correct option for default value also but you need to use the correct data type. For eg if you have number ids in your data provider, then using javascript return 1 will work, but 1 as text won't work. Also remember that state variables are strings so again use javascript to provide equivalent number