Automations

Hello Community, I am having an issue with an automation and would love some guidance. The automation is intended as follows (w/ pics below). Trigger: When Production Status field IS “Scheduled” AND Review Status field IS “Approved” AND Publish Date field (actually called Archived Publish Date in my table) IS “before today” Action: Update records’ Production Status to “Live” I can see that the tests are working, and the automation triggers when I add a new record meeting the above conditions, but when I run the automation, nothing changes to my existing records meeting those conditions. I was really hoping that it would update all pre-existing “Scheduled” records to “Live” to save time on data entry.

I have two tables set up. One lists a host of project related risks (Table A), the other is a database of risk summaries (Table B) Table A has a formula field which calculates a risk number (integer output) based on some user inputs in that table. There is a column next to this which I would like to output a Text response based on the calculated risk number. This text response is stored in a column in Table B. The link between the two tables is the Risk Number. Table B is a database of all the risk numbers and their associated data points (i.e. explanations, text outputs etc.). Each row in Table A will have a changing risk number as the project develops and as such, will need to “pull in” a text response stored in Table B each time. I can’t work out how to pull the text from another table based on a calculated value in the other. Any help with this will be greatly appreciated!!

I’m trying to create an automation that updates a record in one table based on a trigger in a different table (same base). The trigger table row contains the key to find the record in the action table. So I use the ‘find records’ automation action. Problem is, I cannot specify my key. I’ve selected the ‘Dynamic’ option as shown in screen print, which gives me the blue cross so I can inspect and select items from my trigger record. But when I click through to the column with my key I don’t have the option to ‘insert’ the value. Instead I can ‘continue’ to the columns properties and can ultimately insert the length property, but not the value itself. The column is a formula. Am I missing something here?

I created a new automation: Trigger - when a record is updated Action - create a record in another table I have selected the table and field to create the record. Unfortunately this is not working. Do I need to choose a record to link for it to work?

I am having difficulties with update action of automation. it keep failing the test and I do not understand why.

Let’s say I have a list of 10 vendors in a grid. One column contains email addresses. Another column contains a mark if I want to send that vendor an email. Now let’s say I’ve marked that column for six vendors. Can I create an action that will email those six vendors using the email addresses in the column?

I need to automate sending Ad Preview URLs to a client when the URL is created. I have their email address and the URL in a record. Please advise on how to automate sending emails?

Hello! We have a team of about 25 and we sell retreat weekends. Each team member sends us their available weekends and we work with clients to find the right match. We need a way to track what weekends we have available and where. We might search weekends by team member or we might search by the state they are located in. The sales process can be long and so we would like to be able to mark a weekend as tentatively booked, booked, or available. Right now we are manually writing dates in like a text field but that keeps us from using the calendar view or running the kinds of reports we want. Any apps that you can think of or integrations to help us track this? Please note that clients are not self-booking, we only need a back end solution for this.

Hello! I’m trying to achieve the same effect as this post but running into problems actually inserting the string value of a linked record’s recordID as a dynamic automation value. Automation Assistance - Linked Records

I’ve created an automation that splits a record from one table into several other records by their steps and displays them on a new table. It then links them via dependencies so that they are optimized for the Gantt display. The automation will only work for one category at a time even though there is nothing in the automation specifying category, as this is social media it will only work to create dependencies for the records in Pinterest OR TikTok and it makes it very difficult to switch between them but I don’t understand why it’s doing this or how it even knows that the records are of different categories since it’s not a part of the automation. Additionally, it will let me automate dependencies for anything with a start and end date but if Airtable could make it so that I could also add a dependency for the final publication date as a milestone so that I don’t have to go through and do them all by hand that would be immensely helpful.

My Facebook automation stopped working two weeks ago and Airtable Support can’t recreate the issue. The initial test worked fine so I created a regular post. It published at the proper time but also posted one that was scheduled January 2021. Now I get this message: “The permissions for Airtable to use the configured Facebook Pages account have been revoked in the external service. Please re-create the external account and reconfigure this step to use the replacement external account.” I created a new automation and have the same results. Has anyone else experienced something similar?

Hello community, i have an automation that sends a gmail email to a contact when i upload an attachment to a record (invoice), the problem being that last time i did upload an attachment to a record two exact same mails have been sent to my contact. Does anybody knows why ? Thanks a lot ! :slightly_smiling_face:

is there a way to get the text from a formula or linked field in an automation? When I try to add them as a dynamic record property I just get the length result not the text. thanks in advance

Hello, I set up an automation rule to get a message sent to slack every time a certain record is updated. I use the CSV import app to update this same record weekly and the slack message doesn’t seem to be triggered when the record is updated through the CSV import app. However, it works when I update it manually. Anybody faced this before and knows how to fix it? In the screenshot: the record has been updated properly but the message was not triggered. Thanks

Hello, I am building a service that lets users hire experts to answer industry-specific questions. And this is how the workflow would look like: I have two tables called User and Expert. User fills in an Airtable form that asks the following questions: Name (Single Line Text) Question (Long Text) Industry/Topic (Multiple Select) Location (Multiple Select) Airtable automation finds an expert meeting the criteria by matching the Industry/Topic column along with the Location column and sends them an email requesting them to answer the question. Here is the problem I am facing, How do I devise the automation in such a way that it matches the right expert with the user based on the Industry and Location? Currently, the problem I am facing is that I am unable to match using multiple topics from a single multiple select field. For example, Us

I have a base, and I’m not sure if I’ve designed it in the right way, but I’ve made a table for all the purchases, and I have another table for the customers, so I thought it would be easy to link them … but I don’t really know what I’m doing. I created a linked field type … but maybe it should be a formula … ? Anyone have any insights on this for me? I’ve also played around with the ‘count’ field type … but I don’t know how to make the email a variable. Is that what I would need to do?

Ok, asking about a functionality that I hope exists and I just haven’t figured out just yet. Here’s my situation: I am scheduling vaccine clinics for first dose and second dose. I have a formula set up already so if Vaccine Clinic A for the Moderna Vaccine is scheduled for March 1st, I have a field that tells me the second dose needs to be scheduled for 4 weeks later (i.e. March 29). That field is labeled Second Dose Target Date Now what I would like to do is this: When that Second Dose Target Date field is populated, I would love for it to automatically create a new record with a Clinic Date indicating March 29th (using the example above), and carrying over additional information. For example, If Vaccine Clinic A administered 505 First Dose Moderna vaccines on March 1st, is there a way to use automations to auto-create a record for 505 Second Dose Moderna Vaccines on March 29th? (In my situation,

Hi :slightly_smiling_face: I have automation set to run when an record is updated. Thank I have “Find record” action to find records which should be updated. Last step is “Update record”, but I can not select record from “Find record” step. Anything I select it gives me error. :frowning: Does any one know how to do this? Thank you, Pjero

Is there a limit to the number of data elements I can put into the body of an email for my email automation? This works: But this doesn’t: All of the fields are populated. I’m on the free plan. Do I have to upgrade to get this to work? Thanks, Simone

Hello. Complete noob to Airtable. Currenty I have an Excel file that handles incoming jobs, 90% of these jobs are based on a recurring schedule of weekly, 1-4 weekly, monthly, yearly and so on. Not time dependant, only date. In excel I use VBA to copy a new recurring job entry record x amount of times based on the frequency calculated by the frequency between the start date and end date and the schedule (end date max 2 years to eliminate forever). So example: Start Date 27/3/21 End Date 27/3/23 Schedule every 1 week . 7 days Total number records to be copied is 104 with the Start date of each record to be previous Start date + 7 days. Each job record will have a unique ID number, and each recurring job record will also have a Recurring Job ID. Recurring ID for one off jobs will be 0. I would like to know if anything like this is possible in Airtable. Thank you.

Hi! I’m trying to create an automation that will send out a reminder email if a record has not been created on the previous day: My team members each fill out an air table form every weekday. One of the fields is a dropdown with their name. I’d like to make an automation for each team member that will send out an email to them if the previous day does not have a record with their name. The automations don’t really seem to be set up for If/Thens based on records that HAVE NOT been created, but I’m pretty new to the whole thing. I have gone down a few rabbit holes on methods but I can’t seem to figure out what I imagine shouldn’t be a terribly complicated solution.

I am running an automation to create a new record when another record enters a view. The new record a date formula field and use that as the date for the new record. The data test runs fine and the automation runs, but the data field never gets filled in with the information. Any help?

I would like to send someone a copy of a base I have set up and include all of my automations. Is this possible? Thanks!

Hi, I would like to create an automation that checks if one field (number) becomes equal to another field’s value then it riggers something. Is that possible? I only see in the condition to input a value but not select another field thanks a lot