Solved

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.

Hi, I have a lookup field that is showing the address of different radio controlled products i make.I would like to sort these using a script automation.Here is the script I came up with: const address = input.config()console.log(address)const sortedAddress = { address: [] };         //something wrong heresortedAddress.address.sort((a, b) => a - b);console.log(sortedAddress) Here is a screenshot  Any idea on how to fix this? I don't understand how to sort the object provided by the input.config().

I'm new to my company and there are a lot of existing bases set up that I have access to where I can use the Gantt chart feature and other features on the Team Plan. When I go to make my own base, mine are on the free plan. I'm a paid user, so is the team plan based on the workspace? I'm confused why I'm paying for Airtable but have limitations with my bases that other ones do not have.If I do need to be granted access to the workspace on the team plan, is there a way to not have all bases visible to me, just the ones I've been invited to?

Hello below is a table of scores and the corresponding status. I also have a risk register for each risk I want to be able to select the probability (1-5) and the Imapct (1-5) and it automatically returns the status as defined by the table below. Is it possible? Many thanks if you can help! Andrew  

For context, I am building an email automation that is sent every work day (Monday-Friday). The email would display any of the task records that are due on that particular day that the email is sent out. My problem is that Airtable's scheduling timing trigger is limited to posting every single day. I would not like to send out an email on the weekend.I cannot use "When a record is updated" as a trigger as it would send an email for every single task record that is due today, whereas I am trying to send only one email a day. I would appreciate any suggestions, thanks!

Hi,I am trying to create a simple IF Statement to produce the result PASS or FAIL if the value in another column is >= 80%:  In Column 1 ('% germination rate on second check') are % figures with values ranging from 0% to 100%. The purpose of the Column 2 ('PASS/FAIL'), is to produce the word 'PASS' if the value of Column 1 is >= 80%, or 'FAIL' if otherwise. Currently all cells in Column 2 are showing 'FAIL', irrespective of the % figure showing in Column 1. Is this some kind of syntax or formatting error on my end? Here is my formula: IF({% germination rate on second check} >= 80, "PASS", "FAIL")Thanks for the help! 🙂