Ask the Community

I was just checking out the docs page of airtable interfaces, and this was at the top, updated July 6. “While elements-based interface layouts are still currently available, we invite you to try the newer. These layouts offer a more streamlined building process that ensures consistency and efficiency throughout your organization.”Does that mean they’re completely removing the customizable, drag-and-drop interfaces? Is this the plan? Because that would completely kill my interfaces.

Hi there, I have an email automation that is set to send an email 1 day prior to an appointment date. The date conditions are simply based off of date, not time. Do you know what time the email should expect to trigger?Thanks!

Hi all,I have read up that Airtable inserts double quotes if there are commas in the contents of the array, and I have seen reference to removing them by using either Substitute or Regex_Replace, but I have an IF statement and no idea how/where to put either to make it work (I'm new to formulas and they are def not my strong suit!)This is my formula:  IF({Inspection}=BLANK(),{Art}&" ("&{Condition}&")", {Art}&" ("&{Condition}&" "&DATETIME_FORMAT({Inspection},'YYYY-MM-DD')&")")

Can someone help me with this - it is not calculating if over 99 only if over 49 IF({Miles}>49,"0.10", IF({Miles}>99,"0.15"))

Did I miss the announcement where Airtable said that they were changing the format for share links for Forms?The change briefly broke access to my form and now my prefill formulas are no longer working. Is anyone else seeing this change / am I late to the game?" 

I do not use AirTable but am in charge of the billing. A team member added 3 people to edit a document and their permission level is EDITOR. How can they edit the document without being charged?Can someone explain how can I make this unpaid and they have access to the document. I've been trying to chat to a person for the last week.

My Airtable is a simple deposit of client data most of which is there for storage purposes such as address and only some details I will use all the time such as phone number. I am an accountant and I could group blocks of fields into sections like PHONES, ADDRESS, TAX, PAYROLL, ACCOUNTS (AND OTHERS) and I guess there might be 100 fields or columns but I only ever want to see 10. The ADRESS section will have 5 fields for 5 lines of the address and the TAX section will have about 20 fields for all the tax reference numbers. How can I “GROUP” sections of fields such as ADDRESS or TAX and HIDE or UNHIDE them whenever I want to. Also would this GROUP hide / unhide function be available in both the grid and expanded record view.

Hi All,I use Airtable on my iPhone, Mac.I have photo attachment on a record 360. I can see the photo attachments in full, on the Mac, but I cannot see the photos in the same record, on the iPhone.I can only see the thumbnails.Also, I can still see the photo attachments on record 1-359 on my iPhone. However, cannot see photo attachments from record 360 upwards. Again, only thumbnails. 

Hi there,I'm trying to script something but it's been ages since I used Javascript and I'm getting myself tied up.I have a list of rehearsal  dates,  and next to each date I have a linked record showing the actors required for that day's scene, and a linked record showing the actors unavailable for that day. I would like to script something that checks if any item of the array in "Actors Unavailable" for each record (rehearsal) matches any of the people in the "Actors Required" field. If so, we have a conflict and I need to change something. So I'd like it to then either check a checkbox or colour the record to indicate it needs fixing.To duck debug for a second, what I want in plain language I think is"For each record in table "Rehearsals"Check each item in array "Actors Unavailable"See if it appears in the "Actors Required" array of this recordIf so, change record colour (or tick a box)If not, do nothing"Troubl

Hi All I am creating a New Patient Form which requires the patients physical address set out as following. Address line 1 Address line 2 Address line 3 City Country Postcode Is there a way of creating one Question on the Form (ie Address) that bring up those fields as answer boxes to that question? Thanking you in advance for your help 🙂

Hi. I'm wondering whether there's a way to search a table or interface using text that's passed through in the URL itself. Like this: https://www.google.com/search?q=test which searches Google for "test." I think no because the search uses Javascript, but maybe there's a way that I'm overlooking. Bonus question: What's your preferred method for quickly getting to a table or interface and drilling to a specific record quickly? Thanks,David  

I have created a new form and set email triggers based on a form condition. Each trigger sends to to 3 google groups. I tested quite a bit and all seemed well until I just learned that not everyone in the groups are receiving an email when a form is submitted. We uses the groups regularly so I know the problem is not with google. Is there any reason some recipients in a group, including myself, would not be getting a notification when a form is submitted?

I'm trying to use the datetime_diff formula to configure a field similar to the ootb duration field in Smartsheet, but in Airtable.I have a start-date and and end-date field. My goal is to have a duration field show the number of days between the start and the end dates.Here are my constraints. 1) I want to be able to show only weekdays. 2) If the start date and the end date are the same I want the duration to equal 1, not 0.Any suggestions?

Hi all !I've a concatenation formula wich works fine with all number but the 7%...That's crazy.... When I put 7% somewhere my formula return 7.0000000000001%... My fields are all in percent (precision 1%) but the concatenation field is in text format.There's nothing in my formula about the number 7 or else that could launch this error...Any idea ? >Thanks !

Hello, I am trying to calculate night working hours for my employees and I can't figure out the right script. Each day, each employee registers its time hours in a table through 4 fields : (Shift1-Start) ; (Shift1-End) ;  (Shift2-Start) ; (Shift 2-End) With those fields, I am able to calculate duration of work each day, and through a pivot table, I am able to calculate the sum of those hours, compared to the "theorical" hours of each week of the year, hence calculate the real OT. Most of my employees start at 6:00, but some times some of them start a little bit earlier. And sometime they have night work starting at 10 pm and ending the day after at 4 am. In this case, we register 10 pm to midnight on Day 1 and the then midnight to 4 am on Day 2.What I want to calculate now, is the hours worked at night, that means those who are worked between 9 pm and 6 am. Would you have any script in mind?  

Need Help please.I have decided to record my workout sessions on Airtable, and I want to customize the "Set" field depending on the "Type" field. My goal is to format "Set" to duration when the "Type" is "Dead Hang". Otherwise, "Set" format will be number.I have tried this formula, but I am getting an error message saying "circular reference". Can anyone help me with this?Thank you

Sometime between two weeks ago and today, my INTERFACE form changed on create (submit) - from having just the create button when click which showed a small dialog that popped up (still leaving the layout behind empty asking 'do you want to create another entry' which I tend to close to now a full fledge white page with the verbiageThank you for submitting the form!Submit another response If I wanted this I would have made an outside form.I have folks entering data into the system - they do not need this.  And there is no way to customize it, and turning it off the submit another , prevents them from getting to the form at all. Please bring back the keep the form present / small dialog option! More so - please make change notices available.  Al

Hi All,How would I extract only the end of unique URLs on airtable. complete URL https://lucyshops.shopping.com/#opportunities/12345ad-2gh7-115a-07f569f605dpart I want to extract 12345ad-2gh7-115a-07f569f605dif this helps the formula required is similar on this link but doesn't work because I have a different URL Structure.Solved: Extract a part of a link using Regex - Airtable Community

Hello guys,I have created an automation that is being executed when a new record is created, what I wanna do is to get that specific new record in the script, the last one, how can I do that? 

Several of my automations send emails, inevitably I get some bad email addresses and will get a notification in AirTable of a bad email address. Is there a way to incorporate these notification into my automations to alert the person entering information of the bad email?My use case:Hosts are entering Guest information, I want to send an email to the Host that they entered a bad email address automatically.Thanks,Tommy 

Hello!I am trying to create if statements to categorize products.  For example: if the product id is 02568, it will be category a; if its 12487 it will be category b; if 25777 it will be category c, an so forth.  However, each product id number is not the same.  So, category A would have serial numbers like 03577 as well as 06554 and so forth.  Each category starts with the same first number.  First problem is trying to identify in airtable only the first number to categorize.  I tried doing this: if({Product ID #}=0, "A", IF({Product ID #}=1, "B", IF({Product ID #}=

Hello,Could someone please help point me in the right direction?I have an automation which is triggered by clicking a button in an interface. I want the automation to send an email (containing a grid summary of some records) and then update the status of the same records to indicate that those records were sent in the email.However, the updating of the record status is not working.This is how the non-functioning step is configured.Once the email is sent, I need the status to change from 'required' to 'ordered'.This is how the conditional logic is configured.This is the error message. I have gone through the 'how to fix

Hi guys,I have 2 columns in Grid view, each with date and time. One is a "Created" column, the other is a "Resolved" column.I am wanting to have a formula to put into a 3rd column / field to work out the business hours between the two other fields. However, I need to be able to specify the working hours start and finish in the formula (having the option here to have 2 shifts would be even better Ie 8-10 and 11:30-16:00), as well as have it exclude certain days of the week (Ie Tuesday, Friday, Saturday). I would also like to be able to list public holidays that it will exclude from the calculation.Thanks 🙂

Account restrictions: Free PlanPlease note that rows are very precious as I am creating a database, so creating more rows is not feasible for me. I have already hit the row limit on the free plan. &#x1f605I would like to automatically select a size from a drop-down menu when the user enters a number.For example:A user enters a number from 100 - 119 and the table will automatically set the single select drop-down as "Medium".A user enters a number from 120 - 300 and the table will automatically set the single select drop-down as "Large".I am not sure if this is even possible, or perhaps it is possible with a formula.Tips and suggestions are welcome!

So I found a formula someone else made that does exactly what I need it to do.  I need to display the dates of certain events as "week of" so I can group the event by the week and see how many posts are made during the week.  The problem with the formula is it makes the "week of" appear as Apr 3, 2023, when I need it to say 04/03/2023.  The formula is:  DATETIME_FORMAT(DATEADD(Date,1-DATETIME_FORMAT(Date,'E'),'day'),'ll') Can someone help me out?  Thanks! (Field on the left is the date of event,