Automations

Hi! Is it possible to set a time in a date/time function? I have a formula field that calculates due dates for tasks. I would like to create an automation that will email the task owner (a sponsor who does not have airtable access) a Google Calendar invite on the due date so that it is on their calendar. Is it possible to do this without creating extra Date/Time formula fields for the start and end time of the task? Current Formula: WORKDAY(Date,-30) If this is not possible, can you add to that formula to determine a start time of 9:00AM and end time of 9:05AM so that I can get this on their calendar?

Hi There is a table that contains member IDs and credits allocated, which I would like to periodically summarize and distribute to a member of staff. I wish to sum the member IDs duplicated across multiple days, with different credit values, resulting in: A. Smith 23 B. Jones 12 C. Young 75 It is possible to create this output with a pivot table, but I need to be able to distribute it automatically, without a staff member’s knowledge. While I can send regular email/Slack outputs, I cannot get the summary to work (perhaps with scripting). Any suggestions? Thanks!!! Best Regards Jessica Layson

We are writing a script to call an API. This API will returns a file url. We want to download the file using the file url. Can we achieve this?

Dear beloved friends, I would do the automation to copy text from one column to linked filed in airtable, any one could help guide on this automations? Thanks inadvance and regard!

Hello, I try to use a single conditionnal automation to send differents emails each triggered by a different checkbox. checked box “check box 1” will send the “check box 1 email”, checked box “check box 2” will send the check box 2 emaiL. So i just need IF and not otherwise condition. If check 1 is pressed i want to send check 1 email even if check 2 is checked or not… Thank you

Hello! I am trying to create timestamps of the start can completion date based off of a status field I have set up. I have a status field, a Start Date field, and a Completed field. The status has the single selections of “To Do”, “In Progress”, and “Completed”. I have set it up, so timestamps are automatically populated into the Start Date and Completed fields based off of “In Progress” and “Completed” status. I wanted to know if there was a way to clear the records within the Start Date and Completed fields when the “To Do” status is selected? Is this possible? Thank you in advance for the help!

I have an automation that creates new records in table B when a record is created in table A. For those records, I want to have as a due date Today() + 3 days. How can you do that within the automation without creating a new field in table A (workaround)?

Hi! The wording of the title of this topic is unideal, but this is precisely what I’m trying to do: generate a documentation (pdf or whatever format) of the automations set in the base. As an example, it is easy to generate a document of all the tables and fields using the following: for (const table of base.tables) { output.text(table.name); output.table(table.fields); } However, there doesn’t seem to be a way to extract the definition/configuration of automations. Am I missing something? Best, Ludo

I am following the instructions here to be able to send slack DMs to our users. The use case is if we haven’t heard from them by a certain time of day, we want to send them a friendly reminder to check in. I have a view setup with the list of users who have not yet filled in an update for the day which I am using for this. So in the automation, the trigger is not when a record enters view, but rather on a schedule, say every day at 11am. We expect there will be multiple people that this will apply to, so I’m not working with an individual record as the example support article does, but rather a list of records. My automation currently look like: Trigger - at a time Find records - View1 (people who haven’t updated) Condition: If Find>0 and I have their slackID, then Send slack message I’m unsure what to do on the las

I have created a table with all of the accounts/venues that we work with on a regular basis. I have also created a table that I want to reflect the accounts/venue table but it is used to show their availability. Is there a way to create an automation for when I add a new account into the account/venue table, it will also add that same record in the avails table so I know that I need to get their availability?

Please i need help…I created an automation setup yesterday The trigger is when there is a check box a new record is created in another table I.ve tested and sync the records to be created and the field The automation ran sucessfully and records where created yesterday but today it’s no more creating records and it shows ran sucessfully Please i really need help The goal if when i check the box in opportunity table…that record goes to phases table

Hey Everyone, As someone who was previously using a lot of Airtable to Airtable automation through Zapier I jumped on the new built in Airtable Automation features. However I’m now having issues where I can’t create any new automations due to exceeding the maximum number of automations for the base. I can’t find any information on what the maximum amount actually is or if there is an option to increase this. I love this feature but I’m now at a dead end where I can’t use it further, I can’t see how to increase my usage and I can’t see how much this has been exceeded by. Any help from the community or from the Airtable team is greatly appreciated.

Hi Airtable product team! Is there any way to get more automations per Airtable base? We’re a small but growing company that runs our entire Customer Success and Project Management teams on Airtable. We use the automations to ping the right folks (different Customer Success folks) on Slack as a project moves through different stages, and we just hit our max of 25 automations per Airtable base. We would love to stick to Airtable (we love it so much), but if we can’t have more automations tied to it, we’ll have to figure out other tools as we scale. Help!

Hello - We currently use Airtable for our content production processes. Right now, when a user submits a request to our intake form, it generates a record on the base, creates a Jira ticket, and sends a confirmation message to a shared slack channel, that links the Jira ticket and adds the Jira URL to the Airtable record. It works great, and as we try to move people to an easier process, we want to continue to use that Slack message to communicate cross functionally about the specific request. However, I am wondering if there’s a way to link that slack message to the airtable base somehow via automation? It would likely be the last step in the automation to update the record with the thread link. Is this possible? If so, has anyone accomplished this or know how you might?

Hi I have a table containing member IDs and credits allocated, which I want to periodically summarise and distribute to a staff member. The table will have the member IDs duplicated across multiple days, with different credit values, which I wish to sum, resulting in: A. Smith 23 B. Jones 12 C. Young 75 I can create this output with a pivot table, but I need to be able to distribute it to a staff member automatically, without their access. I could send regular email/slack outputs but cannot get the summarise to work (perhaps with scripting). Any suggestons? Thanks

Hi airtable community! We teach classes and utilize Airtable as our class schedule. I am attempting to create a new table that sums the number of attendees for each class by the class type and date/time. We currently have an attendees table which contains the individual reservations and another table called class totals which contains a record for each event. I am able to achieve a total by using a rollup field with Sum(values). Is there a way to use automations to link these records automatically? I utilized the “Link Records by Field” app to do the initial linking but it would make a lot more sense if it was an automation.

Hi. I need an Automation that adds a file to a multi attachment field while a file is uploaded to a different attachment field in the same record. Does anybody knows if this is possible?

I saw a few articles here where people are just sending the airtable record ID in the webhook URL when a specific trigger is met. I’m trying to do the same thing but I want to send the data to Okta Workflows. I currently have the following script: let inputConfig = input.config(); let recordId = inputConfig.recordId; let url = “OKTA_WORKFLOWS_API_ENDPOINT_URL” let request = url.concat(’?recordId=’,recordId); await fetch(request); My trigger is set so that when there’s an update in a specific field, the script should be ran. The trigger seems to be working according to the Airtable automation logs but I’m not seeing anything on the Okta side. Has anyone gotten this to work? I have an input variable created in my automation with the name “recordId”. EDIT: Actually realized i forgot a ; on my url line. Anyway, i see the trigger making it to Okta but i don’t see the recordId going over so curious how I can send data in the script i

Hey all, I am struggling to find what I’m looking for, and hoping someone might jump to the rescue. :slightly_smiling_face: I’m making a to-do list using a Kanban view and would like to limit the amount of active tasks or “in progress” tasks to a fixed number, I would ideally like to run an automation to detect when something leaves “in progress” into the “completed” or “deferred”/“rejected” status and take a new task from the “to-do” tasks. However, I cannot think of how to solve this using the options available in the automation. Has anyone dealt with this? I’m thinking of having a counting row in the table that the automation checks for when selecting which row to add next, although I’m not sure that’s the most elegant/smart option. In summary: I would like to limit the number of rows that have a particular status to a fixed number, I cannot manual

Hi helpful people, I have a list of voucher codes. When someone fills out a form requesting a code, I’d like to update their record with the first unused code on my list. I’m stuck on how to update an existing record with a value from another table. Could someone help me with that part, please?

Anyone know what does this mean: Microsoft reported an error while processing this action: Resource could not be discovered. I have linked my outlook to airtable successfully. Create Automation to send email when certain conditions apply but I am getting this error when I test the Automation. Has anyone experienced the same issue before? I know Automation works because if I choose Airtable “send email”, I can send, and receive emails, but it doesn’t work from Outlook

hello community: I have a question, I have a status field and a date field. I would like to change the status when the day of the date arrives. (if date = today). Is this possible?

Hi all Is there any way of blocking a card from moving to the next stack until a field is filled? Thanks - ravi

Hello, I have a table A of 100’s lines with the name of different projects and their status. I am updating it on a daily basis, sometimes several times a day. I would like to create a table B which summarize the changes that happened in the table A during the past week. I did succeed to create a table B which create a line with the project name and its new status every time the status changes in the table A. However since I may change the status several times a day, I would like to create an automation which edit the previous line if the project name already exist in the table B. The goal is to avoid having 10’s entries and line for the same project. Could you help me out ? :slightly_smiling_face: Thanks a lot !

I have created an automation that runs a custom script after a record is updated. In the script I would like to perform different operations depending on the overwritten values. Is there any way to access those values from the script? (Similar to how one would use OLD in a SQL trigger).