I have a table of worklist items that are assigned to users. I want to create an automation that once triggered will execute the "find records" and would go through the distinct list of users that have open tasks. Open tasks I can do with a filter, ...
I don't know if this is actually that revolutionary, but I struggled to find examples on the forum but couldn't find one, but I was able to come up with a thing that works. Sharing this, it'll either be "duh, we all know that", or maybe something tha...
I've been working with scripts and have been loving it. I know the answer to this is probably no, and would be nice to have, but not a huge thing but....Is it possible to have a some common functions that I write shared across other scripts I use in...
I have figured out the update record action on the automations, but the parameters it asks for is so incredibly vague and unclear, it should be corrected. It should be something like:record to update:field to update:source record:source field:,It al...
I need to send a gmail via an automation that I need to format the body with a script as there's a lot of data I need to collate and format. Is it possible to have a step that runs a script (I have a team acct), populates a long edit text on a recor...
Hmm... Not sure what to suggest. In my situation the link I wanted to send them to was another fillout link, so it did what I wanted. I didn't try to send a URL outside of the platform. My guess is that they probably have a filter of sorts to prevent...
I ended up adding a new column "Unique" ("Yes"/"No") and wrote a script to update first occurrence of each entry to Yes. Then I created a new view with a filter on Unique. That will do what I need. Code listed below:// Load the "Worklist" table
let ...
FWIW, here is what ChatGPT said:Me:in airtable, is there a way to create a view of distinct values in a column, so if there was a column called "name" and it had "Jeff", "Jeff", "Bob", "Joe", "Jeff", "Joe", it would return 3 rows of "Jeff", "Bob" and...
Thanks for sharing your code. That is always appreciated, as I did stumble on this while searching for this answer.So to ask the braintrust, when we do this below, we still have to do the getcellvalue thing? I thought it might build an array in the...
Thanks. I actually got it working last night. The email table with it's own workflow works perfectly, and I'll be able to leverage it in other ways. Basically, I add a row, set status to queued. Then, in my script, I build the body of the email wit...
