Skip to main content

Possible to use automation to create a link between two records without deleting any existing links?

4
Forum|alt.badge.img+4

Hello!

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.

Is this possible?

    2 replies

    TheTimeSavingCo
    Forum|alt.badge.img+28

    Yeap, you should be able to use the data from the record itself

    Assuming your automation is triggering on the record that you want to update, it’d look something like this:



    And here’s a link to the base so you can check out the input tokens yourself

    Adam, Consultant @ The Time Saving Co
    ScottWorld
    Forum|alt.badge.img+33
    • ScottWorld
    • Brainy
    • 8764 replies
    • November 7, 2022

    @49erAllie Adam’s automation above will not work if the new entry is the very first entry in your linked record field.

    You have to swap the 2 items in the linked record field: the new entry has to come first, and then type a comma, and then add the linked record field’s values afterwards.

    Reply


    Most helpful members this week

    Terms & Conditions