Automations

I have 2 Airtbale Bases.One of my Airtables is importing a view from the other. The sync is 1 way and I see the data change as it is updated on the other base.I have some automation setup that looks for updates on specific fields.I noticed a load of automation shad not run, logged into Airtable with the data import and suddenly all the automations ran.Is this the expected behaviour? Is there a way to make sure the autoamtions run even if no-one logs in for a few days?Thanks

Hi,Is it possible to create 2 different forms on airtable ? 2 forms that would not be connected?thank you

I have a mysterious issue I have a field with this formula: IF(language_assessment_label="English",0,IF(SEARCH(TRIM(language_assessment_label),""&assessor_accredited_languages)=0,1,0)) It works very well in Airtable. However, when the automation transfers the column's values to a Google sheet, for some reason ALL the values are added as 1's, I repeat ALL the values are added as 1's. Even if the value is 0 (zero) in Airtable when it gets to the Google sheet it becomes 1.  I have a lot of other formulas which do not have the automation issue. 

Hi everyone, here's what I'm trying to do. This is a base used to track enrolment in classes.Column 1 (linked values): Enrolment HistoryColumn 2 (linked values): Classes - Current EnrolmentI want an automation that will run every day and add any linked values in "current enrolment" to the list of values in "enrolment history", **without** overwriting it.Here's how I've tried to set it up, but as you can see it doesn't work:  

My automation runs when a form is submitted. This form includes two pre-filled fields: Asset Name and URL Location that are located in the Assets tableThe form resides in the Updates table, and when the form is submitted, whatever value has been added to the URL Location on the form successfully updates that value in the URL Location field in the Assets table.Now, I want to modify the automation so that when the form is submitted, it will also update the Asset Name field in the Assets table. But I am unable to fiddle with the pre-filled Asset Name value in the form, like I can with the URL Location value. I think this is because the Asset Name field in the Assets table is the primary field. I can easily change the name directly in the table itself but can't figure out how to do this through the form.Any ideas are most welcome.

Hey, I have a problem with a repeating group, it does not accept my script as input source. // Load and filter table const table = base.getTable("Contact List"); table.selectRecordsAsync({ fields: ["First Name", "Last Name", "Title", "Email", "Phone Number", "Organization", "Address", "City", "Region", "Country", "Zip Code", "Marketing Consent", "Tags"] }) .then(queryResult => { const queryRecords = queryResult.records.filter(record => ( record.getCellValueAsString("Marketing Consent") === "true" && (record.getCellValueAsString("Tags") === "Fliese des Monats") )); const dataArray = queryRecords.map(record => ({ "firstName": record.getCellValueAsString("First Name"), "lastName": record.getCellValueAsString("Last Name"), "title": record.getCellValueAsString("Title"), "email": record.getCellValueAsString("Email"), "phoneNumber": record.getCellValueAsS

I would like to gain a better understanding of how the integration with Outlook works, specifically the aspect concerning the creation of new records upon receiving emails in the "Task" folder.I've set up an "Integration" that generates a new Task when an email is received in the "Task" folder. The integration seems to be functioning correctly, but I'm a bit puzzled about one thing. It appears that when I move a very recent email from the Inbox to the Task folder, the integration is triggered. However, if I move an email that's a few hours old from the Inbox to the Task folder, the integration seems to ignore it.Could someone explain the circumstances under which the integration is triggered? What specific conditions need to be met for the trigger to activate? This clarification would greatly assist me in using this feature effectively.Thank you for your assistance and support.

We are a land surveying firm with records for each project.  Each record contains latitude and longitude information so we can map the records for logistical purposes.  It would help us to know when we take a new job if we have done a previous job within a 1/2 mile or 2640 feet of the new record.  We could build off of our previous work.  Does any know of a solution for a problem like this using a zap or other app in conjunction with Airtable?  I have seen several posts about converting addresses into lat/longs or vice versa, but that does not solve my issue.  Appreciate any wisdom or guidance someone might provide.

Hello community I am having issues with a table of mine. I run a trucking company and have a table to calculate my estimated expenses down to a per mile bases. So I assign expenses and revenue to certain cells and it help generate my CPM. Although I am have an issue that is making things more time consuming. When I assign and revenue or expense to a cell it does not remove the item from the selected field of available expenses or revenue. Any suggestions on how to solve this issue? 

Hello, I have created a sign-up form in Airtable for our nonprofit. When the form is submitted, I would like to have that email, first name/last name contact record added directly to a Google Group. Is there a way to do this directly from Airtable?I have found work arounds with Zapier and Make, but would prefer to do it directly. 

Hello Airtable Community,Please, we have a problem when an automatic email is generated while reading the records from Table/Base. The numbers in the body of the email are returning differently from what they are placed in the Base. It looks like a bug during conversion since the screen preview is correct !!! Happens with date format and also values.I ask for help.Thanks in advance.

How many new records can airtable handle at once.Submissions from Gravity Forms to Airtable

HII've got my slack automation working really well for notification, but the link to access the record goes to the last VIEW in the Table I use or the person used in Airtable I can't seem to get it to go to a specific view that has only specific fields showing for that record.How can I make this work so the reviewer doesn't have to go through all the fields that are not relevant to their task. 

Hi Community 🙂Is it possible to make an Automation - send Slack message if 'anything changes anywhere in the whole base', not just in one Table? Or I have to make Automation for every Table separately?Thank you all

Hi there, would like to get help on the followingI would like to create an "I'm interested" button and redirect to WhatsApp. However the text message I wish to customise it according to the field they selected above. This is the link format I used: "https://wa.me/60392128545?text=Hi%20Chup,%20I'm%20interested%20in%20licensing%20for%20the%20location%20of%2"{Location Name}" Error: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text. I would like my viewers to hit the button and send a WhatsApp message of "Hi Chup, I'm interested in licensing for the location of [Location Name Field]

In an email automation, I am trying to populate the "From" and "reply to" fields from a user card (see attached screenshot). However, when I preview the message, both fields are blank even though the field has a user card that is associated with both a name and an email. Is it possible to populate the "from" and "reply to" fields in this way?

Hello - Is it possible to add a signature card image (see attached) from my computer to an email in an automation? 

I am trying to create an automated email with inserted % fields. However the percentage is not showing up correctly.For example, the % for the record is 55.50% and it is showing as 0.55% in the email.I've attached screenshots of the Automation Email, Email Preview and the actual Record. Thanks!

Hello, I'm trying to create a new record in my base every time a new row is added to a google sheet. However, when I try to configure the Automation I don't have the option to select the fields I want to add (Title, Brand, Supplier, Cost) but instead it shows me "Product" and "Detail" that are in the headers in first row of the google sheet.Any way to solve for this?Thanks! ProductDetails TitleBrandSupplierCostPantsXTBD$4.00ShirtTXYZ$5.00

Hey Y'all!I'm struggling to figure out how to do the following and would love some help!I've built a base that tracks registered and onboarded people in a "People" table. "Registered" and "Onboarded" are options in a single select field. The end result of what I'm trying to build is a simple graph that has day on the X axis and a record count on the Y axis. I want to have daily snapshots of total number of registered and onboarded people as my Y Axis. I want to automate this somehow. I think I should make a new table with dates as the primary field and then one field that is the total registered people for the day and another field that is total onboarded people for the day.But how can I automate this so I don't have to check and update daily?I figured automation would work, but the options are so limited with a time as a trigger.I'm thinking I might need a script that runs daily?Can someone help me out here? Thank you!-Taylor

I have a time tracker table and a time tracker rollup table.I have a Formula in the Time Tracker Table which Concatenate({Department},"-",{Week #},"-",{Employee}).So the output becomes: Logistics-35-John DoeIn this Time Tracker table, I have a Duration time based on a (Start Date/Time) and (End Date/Time). I have two automations.- 1. When a new record is created take Formula Column and enter the output into the Linked Column cell.- 2. When a record is edited take Formula Column and enter the output into the Linked Column cell.The process that occured, was that an employee uses a form and enters their department, time, and start/end time. When the record is created the formula then creates the data entry (e.g.: Logistics-35-John Doe). The automation would then take the formula and enter it into the linked cell. The linked cell would then populate the linked cell which was a single row (Logistics-35-John Doe).Lastly I had a rollup to aggregate the linked cell duration time. So

Hello. I have data that is in 2 separate sheets on my Airtable and the common reference is the vendor ID.I want to link the column Vendor ID on the Data Page to get information available on the Cost Center Information page when I click on the Vendor ID in the Data Page.On the Cost Center Information page there are multiple cost centers for a single vendor ID in many cases.I tried to link the Vendor ID column to Cost Center Information page but it is only picking up the first line having a cost center.Can I get some help on how I can do this?

I set up an actionable message so that when copy needs to be reviewed my client can either approve or reject the design. But when they go to submit their answer, Airtable requires them to log in to AT to answer. My client has no use for AT it is purely my workflow system.Id there a way to get around this issue or does AT need to make an update?

I am running an automation that:reads a set of logics from a tablefor each logic (repeat for each > logics list) executes a script that does some calculationsI want to add a trigger that in the final "repeat for each" loop, a script updates a record in a table so that I know that the whole automation has been executed and can trigger the next one. I can write a script and input the length of the logics list but I am not sure how I can keep track of the current loop number (through a counter or variable?).

Hello! I'm trying to create a button in a table that when I press it, moves the whole record to another table within the same base and, AFTER THAT, deletes the record from the original base. I'm using an API Token. Also, both tables have exactly the same columns, in the same order.However, I'm stuck with how to retrieve the record ID of the row where the button pressed is.Could someone help out with the script? This is what I have so far: // Airtable's API token and base information const API_TOKEN = 'aaaaaaaaaaaaaaaaaaaaaaaa'; const BASE_ID = 'appaaaaaaaaaaaaaaa'; const SOURCE_TABLE_NAME = 'Table1'; const DESTINATION_TABLE_NAME = 'Table2'; // Get the current record ID using input.recordAsync input.recordAsync('Select a record to move and delete').then((record) => { const recordId = record.id; moveAndDeleteRecord(recordId); }); // Function to move and delete a record async function moveAndDeleteRecord(recordId) { try { // Step 1: Get the record data co