Automations

Hi there, I’m using Airtables automation to output an email report for managers. You can’t control the order of fields when outputted at a HTML list or grid and my report doesn’t make sense if I just list the fields in the order they were added to Airtable… …so I’ve used a formula field to concatenate the fields in the order I want, taking the opportunity to give better labels for the reader too: CONCATENATE("Station: " & {Station (from CycleCode) (from CycleEvent)} & "\n" & "Module: " & {Module (from CycleCode) (from CycleEvent)} & ", " & {Project (from CycleCode) (from CycleEvent)} & "\n" & "Started at: " & RIGHT(CycleEvent,5) & ", duration: " & DowntimeDuration & " mins" & "\n" & "Reason(s): " & Reasons & "\n" & "Notes:" & {Corrective Actions}) It gives me a nice summary field that looks like this, with line breaks: HOWEVER once I pull that data into the email automation, whether as a list or grid, the data on

I am getting the following URL appended to my google sheet using automation after submitting a web form. https://cdn.filestackcontent.com/MhkjUkhvQsyBzNgk6S0Z However, if I perform a run test on the automatic, I am able to get the correct attachment URL append to my google sheet like this. No idea what went wrong here.

I have a webhook that is meant to create new records on a table. Some records have new values for a singleSelect type field. I tried to create a function (code bellow) to provision new options but it fails with “Error: Cannot update field config from scripting automation”. Without the field my await table.updateRecordAsync also fails if I pass text to this singleSelect field. Is there any way to provision new values on a option field, to mimic the behavior of the UX where if you paste a new value it is provisioned automatically? if not, a feature request would be the passing of an option to the value of updateRecordAsync such like “create non existing values” or something. async function updateIfNeeded(table,field,choiceName) { const selectField = table.getField(field); if (!selectField.options.choices.find((choice) => choice.name == choiceName)) { await selectField.updateOptionsAsync({ choices: [ ...selectField.options.choices,

Is there a way to trigger an automation when a record is removed from a view? I know there is one from when a record enter a view, but I need the opposite and my random tests have not been working!

Hello, I have a problem with automation trigger on update. I have configured update trigger on 3 fields: features, nextfeature, scripts. But when i’m doing an update by API of this table in this way, trigger is firing. await updateRecord(data.id, ‘Accounts’, { “last_check_status”: date, “status”: ‘active’, }); I’m don’t update the field that i configured to listen. Is there any mistake on my side or it’s airtable’s error?

Hello all – I’m working on an airtable base which will run an application process for organizations. I have one table called “Organizations” which includes info about organizations (ones that have applied and ones that haven’t) and another table called “Applications” which feeds from a Typeform which applicants fill out. In simple terms here’s what I’d like to happen…check for matches, update matched records, create new record if there isn’t a match. Here’s what I want in more detail: Script runs and checks for matches between the Organization table and the Applications table. A match is a record in the Organization table with the same name as in the Application table. For records that match across both tables I’d like to update the Organization table to reflect that the matched organization has an application in the Applications table. (Can be a check box or linked record, doesn’t really matter) For records that don’t match I’d like to create a new record in the Organizations table w

Hi Is it possible to edit the fields selected fields in the digest (ie add/remove) when creating an HTML Grid. All I seem to be able to do is start a new one which is a pain if I want to add extra fields. Also, as a seperate question, is it possible to copy/paste parts of one automation to another? Thanks in advance

Hi there We have a pro account and I have a simple approval for set up that when someone submits me an idea on a form, they can add their email address if they would like an emailed update as to the approval status of that idea. But, when I put that e-mail address in the “To” Field I just keep getting told the e-mail field is blank - despite me having made sure there are no blank fields on the table. Is this fixable or can the automation only send to a set email address and not one from the table itself? As stated, we have a pro account so it should not be the e-mail address itself that is causing the problem. Thanks Shaun

I have been digging around the forums for an answer to this, and wondering if someone can help me with a creative solution here or point me to a similar problem. I am trying to set out a work flow that is automated, and checked off when a new “Student Note” is submitted” So here is the flow: If “Services” = “1 qEEG”, the flow should be as follows: qEEG 1 Report1 ROF1 Finished If “services” = Pre & Post” or “4 Part” qEEG 1 Report1 ROF1 qEEG 2 Report2 ROF2 Finished So for example, if someone submits a “Student Note” as “qEEG 1”, I want the status to read “Report 1”. But if there is also a note that says “qEEG 2”, I want that to read “Report 2”. I am wondering if the solution lies in a Gantt chart (which is new to me) or if I should play with nested If statements, or both. Here is the base: Airtable Info View - Airtable Explore the "Info" view on Airtable.

I’m working on building an automation in Airtable that alerts a specific Teams chat member that something has occurred. I’ve found MS documentation about using the tag to format a mention for a bot, but I can’t seem to get the mention to actually work in the automated message. Every combination I try just ends up as a plain text representation of what I put between the tag, but I know the automation can read tags properly because it’s properly formatting a hyperlink I’ve added to the message using <a href " "> I’ve tried (with and without the @ symbols included): <at>@ First Last</at> <at>@First Last</at> <at>@FirstLast</at> <at>@ FirstLast</at> <at>@emailaddress@domain.com</at> …and probably some other combinations of email address, the person’s name, and the @ symbol. Any insights would be super valuable - thank you!

Hi We have an Automation that sends a reminder email when a record enters a view which is done on a date basis. Is it possible to get these to come in at a specific time, say 10.00, rather than at 01.44 (we are based in the UK). As they get lost in other overnight emails when people come into work. So idealy the automation would check at a specifc time. Thanks in advance.

Using the API, I create a record in a table with 6 files. Once created, AIRTABLE deletes one of the files. All files in ‘dxf’ format

Hello all, I found the “Create child linked records” script and it does exactly what I need to do, but I want to trigger it from within an automation, and instead of entering the number of child records, pull that information in from the input.config() from the trigger of the automation. I have a parent table called “ListInfo” and a child table called “List”. The primary key of the of the parent table is a field called “ListName”. The child table has a linked field also called “ListName”. I would like this automation to create the “ListSize” number of child records in the child table each time a record in the parent table is created and meets the triggering conditions of the automation (the “ListName” is not empty, the “ListSize” is not empty and the record was created today) . My input variables for the automation are “parentRecord” with a value of the record ID of the triggering record in the parent table and “newRecordCount” with a value of “ListSizeNum” which is a formula field t

Is there any way to create an automation or something that would allow me to push a button in AirTable and it would change the content /value of another field? Example: Field 1 - Record title. Field 2 - Button called. e.g. “Reset Date” (button field) - this button would initiate change in Field 3 Field 3 - Date field (with a manually selected date) - This field date will be changed to “Now()” I want to refresh the date in Field 3 to “now”. But I want the Field 3 to remain a static field with manually selected date. I want to update the date manually (without having to use the calendar widget in the date field) Is there a way t create a button to trigger that? I looked at Batch Update app and Automations, none of which seem to be able to be triggered with a Button. I see scripts as an option for Buttons. Is script the only way to get what I am looking for? Last option is Integromat or course and they have the mobile app which can trigger flows by pushing button there.

Hi, Is there a way to automate a Slack or Email message based on criteria in multiple cells? I work with several clients and want to send automated messages to our team if it has been more than 5 days since the last point of contact. Ideally the body of the email would contain the name of the client and the date of the last point of contact, as follows: Client A 21-07-2021 Client B 20-07-2021 Client C 19-07-2021 Thanks!

HI people, I work on a booking system for workout coach They have differents mensual subcriptions plans for 4 to 8 sessions I need to follow the number of session of each subscriber based on the plan they choose (up to 4 or 8) So i have 1 table to follow the mensual subcriptions And 1 table to follow the booking of the sessions. I think to follow the number of sessions booking by each subscribers, i created a 3rd table based on the mails using for the booking. For that I make a link to another record field of the booking session and a rollup to count each time the mail appear (in the same cell). When i add mail manualy in the link to another record cell it’s okay But i want to automat this action but I still can’t find to do this I tried Integromat and Airtable Script, that add data in the next line (cf: screenshot) Can you help me ? Regards, Julien

Hello people, My goal is to use sweet airtable to store the data from my psychology experiment. I would like to create 5 table (Metrics, 1-4 experiment). Each experiment needs to contain a lot of fields. Data schema is -probe[i]-id -probe[i]-feature1 -probe[i]-feature2 -probe[i]-feature3 -probe[i]-feature4 Each experiment will have i === 192 which means I need to create 960 fields. I was searching for script to do it automatically, however I did not find per-defined one. I found this site (Airtable Blocks SDK), however I have not clue how to get is going (tried automation, apps). Im not sure, if the tool is not suitable for the task or my programming skills are not suitable for the tool. I would be grateful, once I will get advice how to overcome the problem. Cheers

Hello. I am trying to automate linking one record in one table to several records in another table. I have one table called ‘Payments’ and another called ‘Entries’. Each payment is for several entries. Once a record is created in Payments I need that to trigger an automation that first finds all the records in Entries associated with that payment (I have these as a list, separated by a comma, in a single line text field in the payment record) and then update those records to link them to the payment. Is this possible? So many thanks to anyone who can help!

Dear Experts need guidance for “at a scheduled time automation” while test run on signle record worked as expected with sending one email on trying to send reminder to 3 teammates - i created 3 records but only one email got created which is sum of all 3 records id and subject and body into one email for the time being 3 diff automation created with action -1 find record diff as team type identified but i am sure there will be simple alternate to send record wise email find record action 1 was earlier marked as track = [y] and now track=a or track =b or track = c is made up kindly share your experience and logics to overcome this multiple automation and each record to send its own email thanks

I have created a feedback form within one of my Airtable bases that is collecting data about different facilitators. I have set up multiple automation’s to funnel the information into a google sheet for the individual facilitator but when I test it seems that the data from the form is populating a row in the multiple google sheets at the same time. Automation steps: A new record is created (submission through the form) Find records - I have put in a condition for the automation to find records where it contains a particular name within the Facilitator Name field in the form. Append a new row in a Google Sheet - I have selected the spreadsheet for the specific individual. The row data is selected and working properly. Sends an email through Gmail to notify the individual that they have new feedback. Has anyone come upon this type of thing before? Am I missing a step?

I use Airtable forms where users book timeslots. When a record enters a view, I like to send the users a calender invite. This works fine when they book 5 events, but the 6th will fail because of the error “Calender usage limits exceeded”. I contacted Google, but they say I have not reached my quota (by far). Looking for a solution!

Hello! Im trying to create an automated reminder - after setting a certain date record, a new field will be automatically filled with a date + 30 days Example: I filled the 1/1/21 in Date 1 - and I want Date 2 to be auto-populated with 1/2/21 Help please :pray: :pray: :pray: Thank you! Liran

Hi everybody, I’d like to scan records for keywords and apply tags to them if a keyword is found. For example, if the record text is as follows: ‘My mom had a bad experience at this restaurant’, I want to be able to tag this record for containing the keyword ‘my mom’. I have a list of other keywords I’d like to do this for as well. This would save me a lot of time manually looking for each of those keywords with the filtering option in Airtable. Anybody have an idea of how I might accomplish this? Would love to hear from you!

We want to auto-populate the current date and time in a column when updating the multiple choice field in a separate column. Everything looks correct in the automation but it is still not functioning correctly. Real-use scenario: We have an Airtable for issue tracking. When the “Status” column is marked “Completed” we want the “Completion Date” column to auto-populate the current date and time. We ran a simple three step automation for this and it is not functioning. Anyone have an existing process we can use?

Hi, I’m new to Airtable and hoping for some help. Not sure how easy/difficult my scenario is to set up or achieve. I have one table with records of student applications and a linked field to another table with records of character references that the applicant supplied. What I would like to be able to do is automatically update the status field in the student applicant table based on whether their character references have been marked as returned/complete. My statuses would be something like: 3 References pending 2 References pending 1 Reference pending All references returned Thanks for any help, and I apologize if I didn’t articulate my issue clearly. Happy to answer questions or to dialogue with anyone able and willing to help! -Kevin Detroit, MI