You might check out this hack that Gap Consulting posted about a few weeks back https://youtu.be/PW3A2Vi1_fw?si=4-rJIdxibNdH1-7F
You might check out this hack that Gap Consulting posted about a few weeks back https://youtu.be/PW3A2Vi1_fw?si=4-rJIdxibNdH1-7F
Thank You! I checked this video and tried out something. When the button as shown in the interface above is clicked, an automation runs as shared below:

I will be creating a dynamic view and use that view to show the results on the interface. However, in the automation I seem to have trouble with the last step 'Update Records'. I am selecting the records using ids from the previous step and then using those to update (see screenshot below)

However it just gives me error without any detailed explanation of what the error is. I tried adding the record id statically and it works but whenever it dynamically selects ids from the previous step, see this error 'Received invalid inputs'. I also checked each record id one by one to see if they exist in my base and they do. I am not sure what invalid inputs mean. There is no detailed explanation in the Results as well. Any thoughts?
Thank You! I checked this video and tried out something. When the button as shown in the interface above is clicked, an automation runs as shared below:

I will be creating a dynamic view and use that view to show the results on the interface. However, in the automation I seem to have trouble with the last step 'Update Records'. I am selecting the records using ids from the previous step and then using those to update (see screenshot below)

However it just gives me error without any detailed explanation of what the error is. I tried adding the record id statically and it works but whenever it dynamically selects ids from the previous step, see this error 'Received invalid inputs'. I also checked each record id one by one to see if they exist in my base and they do. I am not sure what invalid inputs mean. There is no detailed explanation in the Results as well. Any thoughts?
I figured out from airtable support that I wasn't using a repeating group after 'Find Records' which is why I was getting the error. Now the script works fine. Thanks for this response!!!