Trying to put together a proof of concept for using a Glide app to keep track of attendance for a social sports league. I have two tables in an Airtable database (players and games). I added a button for each game to mark that they will be attending and a table that shows the players that entered this value.
Originally, I was hoping for a way to directly update a row via glide, but I haven’t been able to see it in the list of actions (sorry if this does exist, I just started playing around with this today). Not finding this, I found a work around via Zapier to update my Airtable ‘games’ table and add the logged in users name to the record.
Then while testing this for a use case where there are already users in the attending table, so I had to add an additional ‘value’ in the Zapier trigger for the current attendees. This is where I got stuck as glide will not recognize an array as a variable for this. i.e. When the value is blank (value=“”), everything works fine. When the value is 1 name (value=“Kevin”), everything works as expected. However when the value is 2 or more names(value=[“Kevin”,“Tom”]), the value disappears as an option in the drop down for the Zapier integration and it removes the other users and only shows the recently added user as attending.
Is there a way to treat an array value as a variable for an action? Is there a better way than Zapier to append another value to an array? Is there an entirely better way to achieve the result of showing who is attending each game?