Populate a row with multi select input from a form?

[Corner]

Hello, I would like to insert a row with form inputs (new row for a new “Dossier”), but I’m struggling as one of the form inputs is a multiselect input :

• how do I do to send an ID to the row although the user is choosing a name (the user sees object names (“Concession” names) in the list but it sends the object matching ID to populate the row) ? I already tried to set up Label field and Value field like Label field = object name and Value = ID, but I still get a name input in the log
• Once it’s done, how is it possible to send several ID’s to a same column (the new “Dossier” can have several “Concession”) of a row while being a fk column ?

It’s a lot of information but I think my problems are easily solvable haha I just don’t know how to explain it in a simplier way

[Broberto]

Hello, it would be great if you added some more info, maybe even an example/image. What backend do you use?

From what you’re saying, you’d need to make the form repeatable, a.k.a bind it to an array/collection.

[Corner]

Sure, I’m using Supabase as a backend.

Enclosed, there is a screen shot of the destination table for the form. Here, the column “concession_id” should receive “concession” id’s, not “concession” name (but to be more ux friendly, I would like the “concession” names to appear in the form, while it’s the “concession” id’s that are sent to the destination table)