Help: Admin feature for adding/removing users to concerts (Trebuchet method)

Hi everyone! :waving_hand:

I’ve been building an app in Glide where users can sign up for and leave concerts. It’s working well for regular users, but I’m stuck trying to implement an admin feature that allows adding and removing users from concerts manually.

My setup:

I have two tables — all using RowID:

Concerts

  • RowID
  • Array+newItem (Make Array)
  • Array-item (Remove Element)

Users

  • RowID
  • Role (Text: either Admin or Member)
  • Favorites (Multiple files)

I’m following the Trebuchet method described by Robert Petitto (great video tutorial here: https://youtu.be/L1giKujUHxo?si=1VTbiJelSm5cAWI5)

The problem:

I can’t figure out how to create a working admin UI to let me:

  • Add users to a concert
  • Remove users from a concert

I’ve tried using a Form Container with a Choice component, but I’m struggling to understand how I can write to the columns I need to update (such as the array columns, or the relation columns that determine which users are linked to which concerts).

It’s becoming frustrating because everything else works — I just can’t make this part function as intended.

I really appreciate this community and all the amazing support I’ve seen here. Hopefully someone has a smart solution or example I can follow. :folded_hands:

Final question:

Should I switch to using a separate Participants table where I can simply “add row” and “delete row” instead of trying to make the Trebuchet method work for this?

Thanks in advance!

– Adrian

1 Like

This should be the most straightforward approach, if rows count isn’t a problem for you. Trebuchet is intended to be used mostly to save rows.

In your approach, do you mean you’re storing the IDs of concerts a person is going to in the “Favorites” column of Users?

What is your ideal frontend flow for the admin feature that allows adding and removing users from concerts? Do you do that from the concerts side or the users side?