Hello everyone,In short, I am trying to use an automation to combine multiple single select linked fields into a single multi select linked record.I have two bases: projects and team. Depending on the complexity and size of the project, there may be ...
Hello everyone,I am very new to scripting, so hoping I can get some support here.In short, I am trying to use the "Find Records" automation action to get a list of records, and then pass that list onto the script to delete them. Below is what I have ...
Hello,I have an automation based on a button click that creates a number of records in a separate base based on what is selected in a multi select field. The automation itself works well, but I am having an issue with people accidently clicking the b...
Morning everyone,
I have a couple of questions about this solution posted by @Adam_TheTimeSavingCo (Thanks Adam, it works really well!): Create records from multiple select field choices
Question 1: Is there a way to populate a field in the new table...
Hello everyone,
I am having an issue with a pretty simple if statement with !=blank():
If({Date}=blank(), “Blank”, “Not blank”) - this returns “Blank” if the field is blank and “Not blank” if there is something is entered - as it should
If({Date}!=bl...
Thank you for the replies!To the first question, yes that is how we initially set up our tables ~3 years ago. I am sure there is a better way to structure it, but that is a knot that will take a lot of work to untangle. The main reason we stuck with ...
Hello! Because I am terrified of deleting a bunch of records, I am only "testing" the script. This is what I see: The numbers of record to delete will depend on a couple of things, but at the most it will be ~15. In this test, I am attempting to dele...
For anyone that may find this in the future, I used this as an excuse to start learning how to script in Airtable. The problem I was running into was getting a now() timestamp when the automation button was clicked, as the now() function has a lag of...
Thank you! The issue was that when I clicked the button I was updating a field with the now() function and comparing that to the last time the multi select was modified. Since the now() could have a lag of 10-60 minutes, is still allowed clicks and d...
Y’all are awesome, this is perfect!
Just for anyone else that happens to read this in the future, I utilized the “calculation” field to populate the drop down. It may not be the most elegant way, but it does what I want and doesn’t involve script or ...
