Automations

Hi, I’m a beginner using an airtable since a week ago. I run a pet hotel. When a pet is booked, our staff will record the check-in and check-out dates on the booking table. Based on this record, I want to automatically create records for all days of the stay in the meal record table. ////////////////////////////////////////// for example [Reserved table] dog name: Charlie Check-in date: 10/1 Check-out date: 10/3 [Meal record table] automatically create 3records record1 name: Charlie Date: 10/1 Meal content: blank (filled in manually by staff after feeding) record2 name: Charlie Date: 10/2 Meal content: blank (filled in manually by staff after feeding) record3 name: Charlie Date: 10/3 Meal content: blank (filled in manually by staff after feeding) ////////////////////////////////////////// I set a trigger in airtable’s automation, but I don’t know how to set the action. Is it possible to achieve the above wishes with automation functions? Are there other more efficient ways? Best Regard

I have a script that generates the complete contents of an HTML file. I’d like to output this HTML file as an attachment in a field. Is it necessary to call off to an outside service in order to create an attachment with that HTML content? I don’t need the URL of the attachment to persist very long. The usecase is I need a non-technical person to be able to download the HTML file after it is generated with variables that person has just specified. I have a version of this working using GCP, but I’m wondering… can be done entirely within Airtable?

Hi everyone! Does anyone know how to actually build this out?: Build a No-Code Automated Infrastructure with Airtable - YouTube I want to build Operational Databases for my clients and would love to be able to know how to do so. Thanks in advance,

I have a table in my base where I’m trying to set up a create record automation. I have a few sheets with around 40 fields in each but each one has a core set of 20 fields with identical names, type and formatting. I’m trying to set up an automation so that, when a certain value appears in any of these sheets (in one of the core fields), it creates a new record in a central sheet with the data from those fields carried over. This seems to work fine for free txt/number fields but, when I select a field from the originating table that’s formatted as a drop down, the automation builder makes me pre-choose one of the values from the drop down to populate in the new record. It’s the same with check box formatted fields, it seems to want me to choose whether it should be checked or unchecked in the new record. I just want it to bring through whatever is in the original. Is there any way around this? I’m relatively new to Airtable so I may be missing something fairly basic but I can’t see an

Is there a way that the greyed out more info tab can be hidden? or atleast not visable only when the type matches with the if statement? i tried something with BLANK() // " " but it did nothing…

I am trying to create a system for giving out registration tickets for a work christmas party. The idea is, have a base that records Full Name, Email & Phone number. Then a form that staff can submit to get a “ticket” to the christmas party. the tickets would be Free, no charge. But we have a limit of 180 people maximum for the party and we need to make sure that every submission includes a COUNTDOWN. So there would be a cell column for “ticket number” and each time the form is submitted, there would be a new ticket number generated, with only a total of 180 tickets available. I have Zapier so can achieve with that, but i’d rather keep it in house with airtable automations. any ideas?

’d like to use the automation action to send the same text to multiple recipients. So, on Friday at 9:00am, send the “Can you volunteer this weekend?” text to everyone in the volunteer table. I’m having trouble formatting the “To” line for multiple numbers. I’m using the “find records” action, and pulling a list into the “To” field and I get the same error message if:1)the field is text and includes +1 2)the field is text and only has 10 digits 3) the field is a phone number. Can I send SMS to multiple numbers using this action? If so, anyone have any ideas about how the data should put in the “To” field?

Hello! Does anyone know if it’s possible in the Airtable/Google Sheets automation to hyperlink one of the fields? Basically, I’d like to enter in the text of one of my columns and then hyperlink it with the record in another column.

I’ve created a table of scheduled trainings called “Schedule.” I’ve also created a “Registration” table that has a form that users can fill out and choose which training from the Schedule they want to register for. I know I can filter out the schedules that have already happened in the Schedule table, but that filter doesn’t carry through to the linked Registration form. How can I hide records on a table and have them be hidden on a linked form?

I have setup an automation to send an email when a record has had changes, but the auto saving of records is so quick that just changing a text field can result it many emails being sent as every character or two when typing, it updates and the email automation kicks in and sends another email. Can anyone think of a field type or setup in automation that can be change so that it only sends one email when a full change has been made to a record? Cheers for any ideas

Hi, I’m a newbie, and I didn’t find an answer yet… I would like to create a form and an automation : every answer to the form creates a visual illustration with all the answers. And I would also like to create graphics with the form’s answers (rating tool). After that I would like to send an automatic email with the visual illustrations. If anyone know how I could do that with Airtable, I would be very grateful. Thank you in advance !

Hi everyone! We’re excited to invite you to try one of our newest features - Twilio Automation Action. With Twilio Automation Action, you can set up automations that send text messages based on triggers related to connected Airtable bases. To sign up for the beta, fill out this quick form and click on the link at the end. The feature should be available within a few minutes of clicking on the link. If it doesn’t, try refreshing the page. Please note that this feature will only work if you’re on a Pro or Enterprise plan. If you are on an Enterprise plan, you’ll need to ask your enterprise admin to also enroll in the beta via the same link and enable the feature from the enterprise admin panel. If you have any feedback about the feature, please submit via this form.

We are working in a Film festival, and it would be fun at the office to have a custom audio clip play whenever we receive a film copy. We have a field called Status Delivery, and would like this to happen when its changed to Received. Can anyone help?

Hello all wonderful AT’ers. Quick question. I have entries in Airtable that Box folders are created off from. 110122 - 203.02-Lighting - Cinematic Fundamentals 5.00 IS there a way to have Box folders created with the above format based on the date and course fields? Of course it’d have to create a main parent folder first of the Client name, THEN the individual date-course folders. I do have integromat/Make(r)?, in case that helps.

Hi, I want to create a new record in another table whenever a field in another record = X. I.e. If we add a record to table A, and within that record, one of the fields is marked as #1, then, a particular record should be added to another table. How is this possible using Airtable? Cheers!

Hello, I am building an automation to create a record when an email is received. Each of these records also need to include an attachment that is received with this email. Is there a way that I can import that attachment into airtable as well.

I’m not having success using Zapier Find Record. Is my Zap Find Search Value query format in Step 4 off? (see screenshots: ZAP query value and AT field value match) AirTable Automation Step 0: send a Slack Message that includes the RecordID (from field with RECORD_ID()) Zapier Steps Step 1: Monitors slack channel for New Messages Step 2: Filters to ensure it is sent by Bot and contains a RecordID Step 3: Formatter extracts the RecordID Step 4: using Formatter OUTPUT value to search the Record_ID() field, but tests return: # Failed to find a record in Airtable. Error from halted execution: Nothing could be found for the search. Thanks for reading, appreciate any assistance!

Hello airtable scripting experts. I am building an automation using a script to update a single select field in a table from a form in another table. For context, this is a CRM, and the form is updating the lead stage after an interaction occurs. I want the updated lead stage in the form to update the single select stage in another table (accounts table). It seems the only way to automate this is through a script in an automation. With some troubleshooting, I’ve written some code to send the ‘NewLeadStage’ to the proper record, but am receiving an error that the field is not accepting the provided value. Can anyone help me troubleshoot my code? See screenshot below:

I have a button that runs a script to select a record in a different table and change a field in that record. Whenever i run it I get a warning: Can’t use record from button field This script is set up to use records in the “Farm Details” table, but was opened from a different table. Is it possible to prevent this warning or edit it in some way as i know the button is running from a different table. Thanks very much!

For the following simple database example: Table called EMPLOYER with the following fields: EmployerName, Employees, Country. Table called EMPLOYEES with the following fields: EmployeeName, Employer, Country. Required AirTable automation: When EMPLOYEE/Country is Empty, copy the EMPLOYER/Country value to the Employees of each EMPLOYER. How would you setup the automation?

Hello! Apologies if this is a repeat question, but from my initial searches in the community threads I haven’t found a great answer as of yet… I have three near-identical automations that are meant to send an email through Gmail to contacts, and they all include a hyperlink to a pre-filled form that was created within Airtable. The difference between the three automations is the language used in the email itself, as they are sent to contacts that are either 1) currently in our database but need to update some of their information, 2) are currently in our database but need to update a lot of their information, or 3) are not currently in our database and would need to complete the pre-filled form from the beginning. I first created the automation for the third group, those contacts that we need brand new information from. I have since sent out the emails via this automation and it looks like 1000+ emails sent correctly, with the hyperlink pre-filled form being pulled in correctly, looki

Hello, i had comisioned some dude on Fiverr to make this script automation for Airtable but he is facing this error and is unable to resolve it, can somebody help out?

So I have 2 bases, let’s say A and B. Table 1 in Base A is synced to Base B. When 2 records with the same name lets say X are created in base A table 1, they enter a view on the synced table on B. When they enter this view an automation runs to create two new records in base B table 2 with the same name (dynamic field value). However when X and X are created in base A, I only want one new record to be created in base B’s table (when the name is exactly the same). What would be the easiest way to have the automation only create 1 new record named X? And it would be a bonus if I could have the new record in base b’s version field number to fill out as 2 when there are 2, 3 when there are 3 records with same name in base A and so on. Thanks!

I have two automated emails that are failing to run. When I test the automations, they work just fine on trigger and action, and the preview loads fine. But when they run, it comes up that the email has no “to” input. The input I’m using for the first automation is the outcome of a formula that finds an email. The other email is two email fields with a comma separating the emails. Help!!

When they say - Image 2022-09-20 at 6.36.31 am - 19th - what they reall mean is 20th lol… well that screwed up my whole follow up strategy lmfao - how do I tell AirTable that all dates are MY dates - Brisbane time! Lol - when it comes to automations - I don’t know what the heck format AirTable is following - but I know I made the automation to send me an email when a record falls into the “current day” - any input much appreciated. Thanks! Edit 1: Because look the automation says when it falls into Today - Image 2022-09-20 at 4.34.12 pm … and the date is… Today! - Image 2022-09-20 at 4.38.04 pm - so why is it coming up one day late? :thinking: