Save multiselect dropdown into separate rows

[svankessel]

Hi Team,

I am rather new to the platform, so sorry if this question has an obvious answer.

I am organizing a game where people gets points when they organized an event and people get points when they participated to the event (max. of 12 participants). The participants are set in a multi-dropdown.

I want to save the participants and points individually in the DB table.

I got this to work, however assume there is a “correct” way to do this. Anyone that can point me into the right direction?

Current way looks like this:

[cmarchan]

@svankessel

I am organizing a game where people gets points when they organized an event and people get points when they participated to the event (max. of 12 participants)

Based on the above this is one way to approach the beginnings of the dB model:

Event
name (text)
participants (list of users)
organizer (user)
game (game)

Point
reason (options set) | reason1, reason2, reason3, etc
game (game)
points (number)
player (user)

Game
name (text)

Hope it sparks ways/ideas to complement your thinking about your project

[hergin]

If you want to create the things in the multi-select, right after save button is pressed and not while they are being selected, you can check this answer: Adding Multiple Things to Data type - #2 by hergin

There is no bulk create a thing in the regular workflow actions. So you should probably do the trick or find another workaround.