So I want to use a button to append or remove from an array, as far as I can read, only computed columns in Airtable can do this, but I still can only see the basic columns in the “Set Column Values” dropdown after switching to Airtable what could be wrong with me?
It doesn’t sound right with this part. You can not affect the computed columns using an action. You can only change data in a basic column.
We might need to hear more about your use case, but I think what you can do is:
- Have a comma-delimited list of things you have in the array: say thing 1, thing 2, thing 3
- Make an array using the split text column, let’s call this “Current Array”
- Create a user-specific column, let the user have a choice component and choose whatever things they want to remove from the array. This choice component should be marked as multiple-choice, and only allow users to choose values available in the “Current Array”
- Create another split text column, let’s call this “Remove Array”, based on the choices in the step above
- Create a “Remove Elements” column, remove the “Remove Array” from the “Current Array”
- Create a joined list column to join all the remaining elements from the step above, delimited by a comma
- On a button click, set the value of the joined list of remaining elments to the list in the first step to update the “Current Array” as a result.
2 Likes
Thank you so much for taking the time to help me:
- Have a comma-delimited list of things you have in the array: say thing 1, thing 2, thing 3
I wasn’t aware I couldn’t just read directly from an array but had to make a list before… a bit hacky but users now follow groups, thank you so much!
R
1 Like
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.