Automations

Hello : :grinning_face_with_big_eyes: I’d like to integrate a button in an email which will update a checkbox in one of my table. The goal is to validate a customer lead from a collegue. Could you help me out. Thanks a lot

When I put content below the “grid of records” on a client email alert, it shows much larger on mobile than it does on the desktop (see picture). Is there any markdown language I can use to make this smaller than the table?

I am trying to figure out how to auto-populate fields in my Projects table using text from the linked Procedures table – preferably using some type of “apply procedure” button. The Project table has two text field: Project Name and Project Details. There is also a field that links the Project to one of our Procedures. The Procedure table stores default text for the project name and project details that I want to apply to the new project when we specify the procedure to use. After the fields are pre-populated with the default from the chosen procedure, I need these text fields to remain editable from that point forward so we can customize the work as needed for each client. Not sure if this can be done outside of a script? Or if anyone has seen a script like this? Thanks!

There is currently no way to do the following search when finding records in automations: “Where {text} is within {field}” I need this so that I can match records containing a tracking number assigned by an outside entity with incoming email messages that are entered into Airtable. I am currently using Zapier, which does this just fine, but would love to see this in Airtable natively.

I’ve got a table where I add records, and I have another table where I’m trying to make an annual summary of all the records I’ve added to the first table. So I should end up with one record for each year on the second table, with multiple records listed in a linked field. This will happen for several tables across the space. Currently I’m achieving this by having a filter view, to the last 12 months, and then linking the linked field to that view. Then I can just manually select every record that shows up when I press the plus button. However, I’d like to automate that process. My first thought is that I could use an ‘update record’ automation to somehow update the last record in the Summary Table every time I add a new record to the first table. Then perhaps I could use another automation to create a new row (last record) in the Summary Table each year (I’m not sure if that’s possible). Or perhaps it’s possible to pick the record to update based on the corresponding date fields ie us

Hi there, I am trying to create a script that will create new records in one table based on ‘template’ records from another table, and I’m running into an issue when creating the records with Multiple Select fields. I can successfully use the “creatRecordsAsync” method to create a new record, and can successfully push a string or a boolean to the record. But when I try to create a new record and push a Multiple Select value in, it is erroring out. The string value that I am trying to push in matches the string value of the Multiple Select option in my target table. But I am getting this error when I run the script: Error: Field “fldntpeWlvbdfgN8Z” cannot accept the provided value. Any insight? I’m guessing I need to find out the id of the Multiple Select value I’m trying to push somehow?

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!