Hi! Is it possible to create an automation that will email someone the results from one column (not the full record) of a grid?We are doing an exercise where staff fill out an airtable form saying what they value about other people on the team (long ...
Hi everyone, I know I certainly need automation. But I am not sure what I am going to do.Description of the problem:I created a delivery driver pickup form (in Table 1) for volunteers to submit their pickup schedules for one or more schools. Right no...
I am attempting to use Airtable as a month end close tracking form. Is it possible, that once a task is completed, it will create a new task for the same day in the next month? As an example, this task would be completed on December 15th, then once c...
Hi, I need help with an automation that I can't get to work. I have set up 2 separate automations, both triggers "when record matches condition" (different conditions) one adds one linked record, to field "work" and the other automation adds another...
Basically, I want to import a Google Sheet into AirTable then I want to be able to edit fields in AirTable and those fields are automatically updated in the Google Sheet.Thanks for any help!
Hi everyone,It appears that I cannot use the "Find records" action with a condition on a date field "is within" "this calendar month".It is fine if I choose any other "is within", such as "the past month". But it won't work if i choose "this calendar...
Hey All,I am trying to add a button to an interface which will simply duplicate the existing record the interface is looking at. The Interface is a quote builder and we often want to make different iterations of a quote for a customer. I know we ca...
Emails sent via automations replace underscores with nothing, thereby corrupting the URLs, and other values, that contain underscores. I've read the many posts about this and still can't figure out the syntax to use to make this happen.Here's an exam...
I'm trying to adjust the column width in an digest email but the truncate fields doesn't change the layout and I'd like the columns to be spread out more. Is there any way to set this? Even adjusting the view I'm pulling from doesn't change anything....
Hello! I share my Airtable calendar view to my Google calendar so that I can see dates for different clients. A few days ago, I changed a date for a few projects and they're not reflecting on my Google calendar. I've refreshed and unselected the "Syn...
My data schema is such that I have Programs which contain projects, each has its own table. I then have workers as a separate table, where I can link the workers to programs and/or projects. I am trying to set up an automation that checks if a worker...
Dear AllI am trying to automate "master project status" in the base, hopefully through creating a formula. "Master project" is a made of all small "projects". Logic as below: - If all of "project status" is "concluded", then "master project status" i...
When I click 'activate options' no options are showing. I've double checked that activate options isn't already ticked on any other orders. It's been working fine, so not sure why it is suddenly not working. It's not working on multiple devices, and ...
Hello,I'm working on an automation that, when triggered by a new record being created, runs a script. The script should take that record, parse a comma-delimited list, then create new records in a separate table. The new records are include the uniqu...
I want to send a webhook when a button is pressed on a record :// Use recordAsync to get the record associated with the buttonlet record = await input.recordAsync();// Check if the record existsif (record) {// Construct the URL based on the fetched r...
Is it possible to embed a calendar view in an automated email?
Hi all,I have an automaton where at X time, once a week, records are scanned for any projects that are within the next coming week, the status is to be changed to "Upcoming". I am recieving an error message on the update record part. I have attached ...
Title.I am still getting the hang of scripting, Airtable, and scripting for Airtable. Goal of script:User chooses up to two options in multi-select field.Those multi-select options are 1:1 with the names of the records that are being linked. (IDs are...
Hello all!I don't believe this is possible with how automations work with Airtable as I know them, as they seem to be restricted to only automating one table and that one table's records. Regardless, I'm hopeful there's an extension or something that...
Hello! Here's my situation.I have a table 'Part List' that is automatically updated with parts from an external base that I do not control. One of the data entries inputted is "version" and "iteration". So I could have the following table:Part #Versi...
