Saving multi select field to database

[sbecks]

I'm just doing something similar...replace Staff with Doctors and Permissions with Locations on the screenshot below and you should find it 's what you're after..

If you're using the Wappler multi select or similar you'll need to replace the split with .values (this is in the Collections drop down). Both options are covered here:

Multi-Select Inputs - How to Write an Array to the Database

I’m trying to do this for a keyed array but it keeps returning [object Object] for every item in the array. I can add to the array all ok but it doesn’t display correctly in the input so i can pass it thrugh the form to a server side action. What i’m doing is sending an email, but when sending an email to multiple contacts using the sendgrid api it requires each contact to be in an array with each contacts name and email. So I created a way to input name and email then add to the array which sh…

This is the server connect:

So create an insert for your doctor, then add a repeat taken from the multi select for each location. The insert for the location will need to include the Doctors ID and the Location ID (+ any other data you need, if any).