Multiselect Dropdown write to collection

Get Help
1

Is it possible to write records to a collection for each item selected?

I have a collection of locations.

I have a form that has 3 data collection points that need to be written to each location, but only the locations that are selected using the multiselect dropdown.

How do I do this?

2

Hi @ThunderBlade,

So you have a form which has 3 fields to input and also a multiselect dropdown which is connected to your locations collection. Now user input data into the 3 fields and select locations from the dropdown, then that data should get saved in another collection and each selected location stores as it’s own record with that 3 fields data, am I correct?

Thank you and have a great day!

3

Yes. The 3 Input Fields are filled in by the user. The Multiselect is then used to select the locations to which the user wishes to write to. When the user clicks the “Save” button, I would like the button to write to the “Locations Data” collection with the data the user input into the 2 Input Fields.

All in All, there are 2 collections:

  1. Locations
  2. Locations Data

Thank you for the reply, and can the Multiselect Dropdown work in this capacity?

4

Hi @ThunderBlade,

Thanks for the update!

When the user selects a location, you can create the record with other fields data but then if the user deselected that location, the component cannot access that record data and couldn’t delete it. One solution would be using another screen to delete that record on deselecting. (as a deselect action, link to a loading screen which includes lottie and a hidden countdown as a list which founds that record, and delete that record, and link back ) Or you can use a custom action which calls a webhook in MAKE to do that same steps.

Another solution would be using a custom list to show the locations with two buttons (one to select and other one as a list with a filter to find the record and delete it). Or else you could hold the 3 fields data along with the selected locations in a m2m relationship as temporally and when clicking the save button, a custom action fires up which calls a MAKE scenario that find the user’s temporally data and do a batch record creation process with that data.

Let me know what you think!

Thank you and have a great day!

5

The second option seems closer to what i’m looking for. Let me toy with that a bit.

Thanks

1 Like
6

Awesome, thanks for the update and let me know how it goes!

Thank you and have a great day!

7

OK….I see where I can setup the list to create on selection, and how I would have to have the user reselect to delete unwanted records.

Can you elaborate on the m2m and MAKE scenario option?

8

Hi @ThunderBlade,

Thanks for the update!

Do you meant a video tutorial? Additionally, that method would cost more credits in MAKE when more users starts using the app and selecting more locations.

Thank you and have a great day!

9

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.