form with bind field

[ionv06]

Hi,
How can I bind an options field from a form to a text field?

select
    'form' as component,
    'Invoices' as title,
    '' as validate;
select
    'CIF' as label,
    'cif' as name,
    'select' as type,
    (select 
        JSON_ARRAYAGG(JSON_OBJECT(
             'value', cif,
             'label', name
         )) 
         from companies
    ) as options;

I want to add another field in the form, 'name', whose value should be linked to the value selected in the 'cif' field defined above; if the user selects another value from the 'cif' dropdown list, the value of this field must change ('cif' is a company id and 'name' is, of course, the company name)

[DSMejantel]

Hi,
You can try with thé multistep form like in the examples from the documentation.

[lovasoa]

Hi !
Your sql pages are entirely rendered on the server side, which prevents dynamic client-side behavior. However, you can easily use a multi-step form to achieve a similar behavior.

You can have a look at /examples/multistep-form/index.sql which is heavily commented.

[YunusMechery]

@ionv06 try: #628