I have a table for “teams” and a table for “tournaments”. There is a linked field between the two.
I want to create a button in a Glide app for my end user that allows them to “Register” their team for a specific tournament, but I can’t find a straightforward way to update a linked field to add a linked record that doesn’t clear out existing linked fields.
Example: When the administrator for the red team clicks a button on the tournament page, this tournament is added to their team’s list of tournaments in the “tournament” field and vice versa.
Because a team can register for multiple tournaments and tournaments can have multiple teams, I want to update this linked field without clearing out existing records in these fields.