Solved

How do I update a record on a table, based on a record on another table that just got updated, it requires a record ID but the update record automation action only gives the record ID of the just updated record and not the ID of the target record

Hi and thank you for any help you can provide.I have created an automation so that when a record status is set (trigger = Pending), I get an email and Slack notification.I would like to know how to include record information in the notification. Right now, I'm just getting the message I typed in the Message field. Can I add record specifics there? I would like to see when the record was last modified, which in this case would be when it was set to Pending. I would also like to include other fields, such as the headline and writer.Thanks for your help.

Hi,I'm a relatively new Airtable admin. We have a user who can log in using SSO, but when he does he gets an error message saying that his free trial period is almost over. Since we have an enterprise account, I would think he shouldn't see that message.His account looks ok to me in the airtable admin area:(I covered over his real email address for privacy, but it looks like the rest of our users - uniqueid@dartmouth.edu.) I've tried signing him out of all sessions from the button shown, and had him log in with a different browser and a private window. None of those things helped.I opened a ticket with Airtable support, but I thought it was worth posting here as well. Any thoughts on how to fix this?Thanks and have a good day,Joe MontibelloManager of Library IT SystemsDartmouth College

Hello everyone,I need to insert the current date in a filed when a second field is updated (Yes or no) in the record updated.My need is that the first field is a "Date" because it could be modified inserting a different date in the case of any modification.I can not find any solution: automation with a button is too difficult for me (script) and automation does not the job for the record updating.Please can you help me? It seems so easy ... (I surely prefer Airtable but actually Spreadsheed does it in a minute). Best regards A. Borriero

Hi,I'm sharing a private link to a data set (can't share here as it's got user-data). Sometimes when entering the password it works fine. And then other times on an incognito browser, and for other people trying to access it it doesn't work. It comes up with this same message, see photo attached.What could be going on here? I need a fix asap so would really appreciate some help/troubleshooting.

Hello,I set up an automation to notify certain colleagues when an asset is due to expire or up for renewal. Everything looks right, but when I send a test of the notice to myself and one other person, the notification goes through, but the identified asset that is due to expire is not included with the email notification. How do I sync up the notice with the asset? Thank you,Alisha

Hello,I have been creating interfaces for my techs to use so they can update jobs while in the field - the interface is designed to give them the information they need about a job, and allow them to quickly take notes, upload pictures, and log their time. Unfortunately, when I open the iPhone app and pull up this interface, I'm not able to edit any of the records! I can see them all just fine, but it's just not editable. According to the announcement of interfaces on iOS (https://community.airtable.com/t5/announcements/introducing-mobile-interfaces-on-iphone/ba-p/160766), we should be able to edit records, but the option just isn't appearing for me.I'm using the List interface, and have enabled the option to allow users to edit records inline. I can edit records using the interface on desktop just fine, but the iPhone app does not allow it. Am I missing an option?

Hi I have a formulaDATEADD({Kick off},{Time Estimate (Fibonacci Minutes)},"minutes") Whereby {Kick off} is an date field set to ISO and 24 hour time{Time Estimate (Fibonacci Minutes)} is a drop down with a Fibonacci sequenceI want the DATEADD formula above to return the expected job completion date and time so that I can feed it straight into my calendar. Weirdly, it's an hour out.For eg a kick off date of  2023-05-10 00:01 with a fibonacci of 21 returns 2023-05-09 23:22, when it should be 2023-05-10 00:22.Any ideas? 

Hi, How do I get currency (ie. $22.00) to display the cents “.00” when exporting? I have an integromat automation that links Airtable to email and when I use mapping for my dollar amount it only shows the whole number (ie. $22.00 shows 22 – $22.50 shows 22.5). Thanks!

I am attempting to send information from Airtable to Zapier and ultimately a message to a client. I am using the Automations > When Record Is Created trigger to Run Script. I am using the script from this article: Instant Webhooks with Zapier and Airtable My automation says it runs successfully in Airtable, and my Zapier says the Catch Hook runs successfully, but my QueryString is returning everything “Undefined” Basically none of the data is being sent from Airtable to Zapier. let url = "[ZapWebhook]"; // Replace the [ZapWebhook] with the webhook provided from the Zap Trigger step. let config = input.config(); // This allows the Input Variables to be used in the code. await fetch(url + "?RecordID=" + config.RecordID + "&FirstName=" + config.FirstName + "&LastName=" + config.LastName + "&Phone=" + config.Phone + "&Email=" + config.Email); // Concatenates the webhook URL with query string parameters and Input Variable values. ^^^ code being used if you don’t want

Dear community,We have a group coffee and drinks pool at work that everyone can help themselves to as long as they write up their use. I am using airtable to track everyones consumption and payments, which works great. I managed to set up automations for emails to notify what the users owe and when their payment has been received. The only thing that I can't figure out for the life of me is how I set up an automated email reminder if they haven't paid after 14 days.I have the following table (simplified):Let's say I do the invoicing every 15th of the month and want to send out a payment reminder on the last day of the month. In my example above person ABC wouldn't need a reminder because they already paid while person XYZ still owes $30. I figured out how to send out an email if the Total is >$0 but I can't figure out how to make it conditional that this email is only send out at the end of the month.Of course I tried to read up on that because I guess I am not the first person who

Hi all,I am stumped but I feel like the answer is staring me in the face!  Hoping yall can help!I have a membership tracking base set up as follows:TablesPeopleEventsAttendancePeople and events are stand-alone tables.  The Attendance table basically links them with a field for People and a field for the Event.What I need is a total number of events (within a date range) to be used in calculating a minimum attendance requirement per person.Anyone have an idea how to accomplish this?  TIA!EDIT:  I know how to calculate how many events each person has attended.  What I need is the total number of events so I can do a formula something like {# Attended} / {Total Events} = % of Events Attended.  Thanks!

Good afternoon, I am very new to Airtable. You will realize it, if you read my post ! :slightly_smiling_face: I have a table with the dates and times of arrivals and departures of guests at the airport. I want to know the number of days I will have to allocate the cars that will transport them. The cars are rented on a full day basis. I am trying to calculate the number of days for the cars, taking into consideration the dates of arrivals and departures of the guests. I am using the formula DATETIME_DIFF({Date departure},{Date arrival},‘d’)+1 The formula is returning the result taking also into account the time of the day of the arrival and departure, and I really want only the full day. I believe that the solution is very simple, but someone can help. For example, one guest arrives on 26/06 at 11:00am and departs on 02/07 at 09:00am. the result that I’m trying to obtain is 7 days, and not 6 days Many thanks in advance…

Continuing the discussion from Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B: Dedupe - Merge fields from duplicated records, Merge data A (AND) data B, instead of data A (OR) B To me this sounds like a job for a rollup. Not knowing the specifics of your base, I’m going to just take a stab. I’ve tried to make sense of a dozen posts about merging fields, etc. but can’t find something that I can understand, to merge two fields - which are referencing records in another table. Here’s the scenario: “Table A” has hundreds of sources “Table B” has a field “Column1” which links to a few records from Table A “Table B” also has a field “Colum2” which links to some records from Table A e.g. Colmun1 might link to 6 records e.g. Column2 might link to 7 records Some of the records in Column1 and Column2 are the same. Let’s say that 4 records are the same. We want to combine or merge Column1 and Column2 so that all linked records are in on

All, I’m trying to import a file doc file that exists in an airtable attachment field into Google Drive in integromat. So it actually creates a file, by the name that I have assigned. But when you open it, here’s what it looks like: You’ll notice first that it doesn’t open in editor. And what you are able to make out of the text is the address of the file in airtable (according to airtable). As far as the setup in Integromat, here’s what the settings look like:

Hello,I need to sum the two smallest values between three values.Example:- Value 1: 10- Value 2: 20- Value 3: 30The two smallest values are "Value 1" and "Value 2".How to do this via a formula (or other

Is there an option to only edit a record in expanded view only?I'm getting issues where people are accidentally editing a record by mistake and not knowing about it.I'd like for the main view to be in view/non edit mode only and only allow change in expanded view.

Hi Everyone,I have two automations that I need to combine into one. Is there anyway to merge the two or move pieces from one to the other without having to rebuild the content? I would have set it up as one automation to start with, but I was new at this and didn't see how to do so at the time. We're bumping up against automation limits, so it's important to combine them.Since they both trigger the sending of emails with a lot of inserted fields, it's a hassle to do it manually as even if I copy and paste, I have to manually re-insert the custom fields.  I tried searching but only got results related to automations that merge records, not anything about merging the automations themselves. Thanks for any insights you can provide! Regards,Anne

Hi all,I'm creating an automation to retrieve data from an endpoint then update a record in Airtable.The api call works, the data is formatted into a string, and correctly passed into the `updateRecord` function.However I'm getting the following error when testing the automation:Error: Request parameters failed validation.Here is the code:  let inputConfig = input.config(); let table = base.getTable('Orders'); let record = inputConfig.recordId; fetch(`https://api.myEndpoint/${record}`, { method: "GET", withCredentials: true, headers: { "Authorization": inputConfig.apiKey, "Content-Type": "application/json" } }).then((response) => { return response.json().then((data) => { updateRecord(data) return data }) }) const updateRecord = async (data) => { let status = data.status await table.updateRecordAsync(recordId, { "Status": status, }) }   To follow up, I modified the code to query the table and pull

I cannot decide if I'm better off with an automation or else I'm just not meant to do if else formulas. I need to first check if a date field is not blank. If it is not blank, then I want to compare it with another date field. If it's later than other date field I want to show 'launch date moved out'. I know this formula is not comparing but it's what I ended up with (and it's not working)IF({Original Launch Date} & "-"THEN {Launch Date}>{Original Launch Date},'Launch Delayed') 

How do I change the name of a table's "noun"; the noun is listed in a row's context menu: In this case, the noun is "vehicle".

Hi,I am trying to create an automation where:If "Adviser 1 ranking" column has been updated as "Outstanding", then the "Adviser 1 rating" column will automatically have 5 stars appearing. Same goes to any update on "Adviser 2 Ranking" will update the "Adviser 2 rating", "Adviser 3 Ranking" with "Adviser 3 rating". In all 3 single select Adviser ranking fields, I have "Outstanding" (i.e. 5 stars), "Very good" (i.e., 4), "Good" (i.e.,3), "Poor" (i.e.,2), "Try Again" (i.e.,1).Could anyone please help out?Thanks! 🙂

Context:I've encountered an issue in Airtable where an automation I've set up to group records in one table within a linked field of another table works correctly for records with unique primary field values (the leftmost field). However, for records with the same primary field value, it only groups and links the most recent record while unlinking the preexisting records with the same value. This poses a problem for what I'm trying to achieve.Goal:My goal is for the automation to link all records in one table to the field in other table, as long as they meet the conditions of my automation, regardless of whether or not their primary field value is the same.Path:Triggers:- When an updated cell is detected in Table 1, the following actions occur:Action 1:- It creates a new record in Table 2.- This record contains two fields:- One for the updated cell's value (placed as the primary field on the left).- Another field with the record name of the updated cell in Table 1.Action 2 (Condition 1

Is it possible to limit the number of records syncing from one table to another?For example "Table A" has 15000 records and I want records 1-100 to populate "Table B", 100-200 in "Table C" etc.

Has anyone found a solution to have a junction table automatically updated, when new records are created or existing ones deleted? I love the Junction App that is supported by Airtable, but need a solution that triggers it to run. And from what I understand there’s no way to run an app through an automation. So I tried to take the script used in the App and use it in an automation, but can’t get it to work. I’d even hire a programmer to do this, but when I tried to find someone on Fiverr they knew less than I did about scripting … LOL.