Create_new option for form

[RipalPH]

Hello,

I need to create a dropdown that can allow user to create their own option if the option is not available in the dropdown within a form. Is that possible? I noticed row-parameter create_new and I tried in my code but doesn't seem to do anything. I did multiselect too to check.

Thank you!

[lovasoa]

Hello and welcome to SQLPage! Can you share the snippet that you tried and that didn't work?

[RipalPH]

Thank you for quick reply! I was trying following and I didn't have true as dropdown so my dropdown wasn't allowing to create new option.

select 
    'form'                        as component,
    'examples/show_variables.sql' as action;
select 
    'Fruit'             as name,
    'select'            as type,
    'Select a fruit...' as empty_option,
    true as create_new,
    '[{"label": "Orange", "value": 0}, {"label": "Apple", "value": 1}, {"label": "Banana", "value": 3}]' as options;

[lovasoa]

Everything seems to work for me

1	2

select 'form' as component;

select 'select' as type,
 'x' as name,
 true as dropdown,
 true as create_new;

 select 'alert' as component,
  :x as description;