Each table is linked via linked fields in a hierarchy Job Family → Functional Focus ->Responsibility, and then using Softr lists, a user can select what Job Family they belong to, then functional focuses then responsibilities etc…
The problem I have is that I’m not able to remove a user from a linked record in a table using the same update method. I don’t want to delete the record, just add and remove the UserID from the linked records in each table.
I am able to remove records using a Make integration, however, using lists there is no way to call Make, so the UX is compromised with workarounds.
I’ve played with the idea of creating a column on the table i.e. “Remove Functional Focus”, and then updating to this field, then running a script automation in airtable , however I haven’t had any luck getting this script to work … it’s driving me a little insane.
Just my update here for anyone else interested… Kind of working.
I have been working on the hidden field of the UserID to a “Remove Action” column, that then has an automation in Airtable that removes the link to the User Record with this code in the Airtable script when the UserID is added to the “Remove Action” column:
Not sure about your use case but action buttons will be able to trigger webhooks soon (make and zapier).
There is a community event this afternoon about action buttons with Artur, CTO of Softr. This might be of interest for you (there will be a replay)