Ask the Community

Hi allI'm organising a straightforward, but extensive catalogue of books. My users are frustrated when they apply a filter, or do a Ctrl-F search for, say "Fried" and it returns all occurrences of that string, such as "Friedman", rather than the word on its own. Any ideas? I'm sure it's simple . . .ThanksEd 

Hi everyone!I am currently checking out Airtable to see if it can replace a number of tools currently used for a construction Company. Right now I am trying to build a Report tool, using the Interface designer. There are the following tables involved: - User: The worker of the Report- Project: The Project of the Report- Report: The Report itself -> New one is generated- Performed tasks: Things that have been done, always linked to Person/Project/date & include length in Hous + notes etc -> multiple new ones are generated- Activity of the performed task: One Activity from a database of all the tasks that can be done. Linked into "Performed task"Now the Activity of the Performed task is nested in the Performed task. I set it up like this so that you have your database with Activities and then in the report, a performed task contains the activity + how log, who, where etc. This way you can get a good overview over who did what when, how long etc. To give

Hi, I am trying to get some more sophisticated user interfaces and calculations into a form view or interface but am getting stuck. I am trying to have some pre-set instructions with calculated values in a form that employees would be able to fill out from a single link. are there any integrations/ extensions/ suggestions on how I might be able to do this?Thanks for the help!

Hi there,I have implemented OAuth for my application (using Python) and everything was working fine for several days. However, this morning I received this message in my email: The "OAuth XXX" third-party integration's access to your Airtable account has been automatically revoked by Airtable due to security concerns around refresh token usage. This sometimes occurs due to misconfigurations of the third-party integration. To continue using "OAuth testing" you may re-authorize it. And these are responses I captures when tried to refresh a token (not sure if it's important, but just in case).The first message I received on my server (when it failed) when I was trying to refresh a token: {"error":"<!DOCTYPE html>\n\t<html>\n\t <head>\n\t\t<meta name=\\"viewport\\" content=\\"width=device-width, initial-scale=1\\">\n\t\t<meta charset=\\"utf-8\\">\n\t\t<title>Application Error</title>\n\t\t<sty le media=\\"screen\\">\n\t\t ht

Hi!I have the tables "units" "location," and "event."Events have a lookup field to location, and a location has multiple units. What I want to acheive is to create an automation so that when a record is created in event, a new event for evry unit in that location.I started, but seem to be stuck onTo give an example:Units are lightbulbs, locations are buildings and events are service missions. A user can change one or all lightbulbs in a location via a form as part of a service misson. If the user changes all lightbulbs in a location I want to create a new record for each of the lightbulbs in that location.The point is that it's important to track when the lightbulb last had maintenance.

Should there be a few second pause between multiple triggers? I have 100 records. Every record has a checkbox for approving. Once I check the checkbox an email automation runs. I have an habit of approving multiple records at the same time. Because of that I am not receiving the email. How much pause should be there between 2 triggers in different records?

Hi there, I have a database of social media campaigns with start dates and end dates. I’d like to have both dates add a year when the end date is older than yesterday (so once the campaign ends, it’s automatically set up to happen next year). Ideally, I’d like it to happen once per month, but it can be any trigger. I should add that I’m on the free tier of Airtable I’ve tried a few things, but I can’t seem to get the formula DATEADD({Start Date}, 1, 'years') to work with the automation. Any suggestions?

I have essentially a navigation bar on the top of an interface that has 8 buttons to take you from this interface to my other 8 interface pages. Is there a way to copy them to the other interface pages without having to reconstruct them one at a time on each page? I know that if I wanted to start from scratch I could create the navigation and then duplicate the page as many times as needed and then add the other elements but I already have all the pages built.

Hi. I’m looking for a way to calculate an average time of day for an average start time and average end time. Airtable has the date and time field, and the time duration field, butI need the average start time and end time, as separate values.I need to accommodate for a start time being before midnight or after midnight.This is to get an average time a person fell asleep (potentially before 11:59 pm or after 12:00 am) and their average wake up time. Based on my pretty thorough knowledge of Airtable, I can’t figure out a way to do this because Airtable’s fields don’t offer you a time of day without a specific date.A more traditional business purpose of this calculation would be calculating a person’s average clock in time and clock out time, as separate values, but still accommodating for before or after midnight, which could be applicable for a business with night/3rd shift workers.It's my understanding that there is no technical workaround and that this simply a limitation of the type

i have a sync to jira.. i want to assign an airtable user based on the jira user fieldFor example: if  CM2 field contains John Smith, Mary Jones or Kate Day.. Can i create a formula that assigns John Smith, Mary Jones or Kate Day as an airtable user vs just a text box.. so that they get a notification that work has been assigned.  or does this need to be an automation with a user table?Thank you

Hi, Wanted to check if airtable had automation enabled for email requests (sent by customers on a distribution list) received to be converted to a case/record for follow-up for client services?Need to check if the 'email to case' conversion capability is feasible in airtable?Thanks! 

Hey there, Is there some way to count the number of entries in a Lookup field in the same table? I have a Lookup field called ‘Roles’—it references another field on the same sheet called ‘Movies’ and spits out a list of acting credits associated with those movies. I need to count how many credits there are, but the ‘Roles’ field doesn’t appear as an option in the Count drop-down. Is there some other way to do this? A formula maybe? Any help appreciated! Thanks! Jez

I am building out a process to make billing time and invoicing easier.  Unfortunately the formula I'm using either results in $1 or a total that's completely incorrect. How in the world is it calculating $216? Should be 7 * $33.33=$233.31  

Hello! Any help would be greatly appreciated! Any idea how to get a formula for a record detail within a record detail in the interface?CONCATENATE("https://airtable.com/app/pag/" & RECORD_ID()) SO I have list, I want the formula to take me to that list in the interface, then to the record detail and then to another record detail within the first record detail - make sense? Basically, switching to the interface, having issues with email automations taking to a specific record detail, since before we could direct right to a view in the data layer base. Thanks for any insight!

I have a very simple interface, which just shows a list of fields.Whenever I load the interface fresh, the fields appear to have errors (see below):When I enter the interface editor, these errors disappear and the fields appear as normal.When I exit the interface editor, the fields continue to act normally until I close the page and revisit it later (then the errors reappear again).Inspecting the elements that give errors doesn't seem to reveal anything configured incorrectly.Does anybody have any idea what's happening here?

Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.DATETIME_DIFF({Sell}, {Buy Date} 'days')Well, there may be a problem, but I can't see it... can anyone help with the formula to display the number of days between two dates 🤔 🤔? Thank you.Here's what I'm getting for these 3 fields:Buy Date, Sell, #Days1/12/2020, (No End Date), NaN7/10/2023, 1/31/2024, 177120001/1/2020, (No End Date), NaN9/19/2023, 1/31/2024, 11577600

I have been building a income and expense tracking base for myself that has evolved from a Google Sheet. Thus far I am loving the Airtable features and am anxiously awaiting a plotting solution. I have a question about implementing main categories and sub categories. For each expense I have defined main categories and sub categories. I have currently implemented this by creating separate tables within my base. One for main categories and one for sub categories and then linking to them within my main table. My problem is that my design requires that each sub category belongs to only a single main category however I have to manage that manually as I do not know how to explicitly restrict that relationship. Thus far it works as I am the only one that uses the base and know which sub categories belong to which main category. I would however like to share the input responsibilities with others in my family and also make the base available as a more general solution. Additionally it would be

Hi everyone, may I know how or if it's possible to create 2 columns below a single field? Or 2 columns below a single cell?  

Hello,I am creating a base for performance reviews. Individuals receive Case Review scores (based on a form submission) in one table and then those scores are tabulated in a second Cumulative Scores table. My tables are linked. When I initially created my rollup fields in the Cumulative Scores table, I was able to pull the info from the Case Reviews table and populate my rollup without issue. Now when new forms are submitted, those rollup fields are not updating. I have tried adding lookup fields and automations, but I can't see to get it functioning. Can anybody help me resolve this issue?         

I would like to extract the months from dates in a multiselect field. If I use Month(Months) I get NaN, If I use DATETIME_FORMAT(Months, 'MMMM') I get #ERROR!.  Anyone know how to do this?  Thanks, Scott

Hello, I have a 'Client' table linking to another table that holds information about Event Labor. From the Event Labor table, I am trying to send an automated email to the client (email address linked from its own table.) When creating the action, the 'Email (from Client table)' is an option, and then I have the choice Linked Record ID or Value. I assumed to use Value but neither choice is working. Any solutions? Video to show my work https://www.loom.com/share/38183324bec943ca8c58bffa9ac91162 

I feel like I'm either being stupid or something odd is happening regarding LIST VIEWS.In my Interface, I can add a LIST VIEW and add levels and it works fine.  My table has a Providers Table at the top, linked to Payroll Table, linked to Transactions.  works as expected.BUT, in my Providers TABLE, when I add a LIST VIEW and try to add Levels, it ONLY shows the ability to add levels ABOVE, not below, like it does in the Interface.  There are no levels ABOVE, as Providers is the top. Why does this work fine in Interfaces but not in table views???

We are currently using Airtable Team and have  a billing question. So our team devolved 2 interfaces. 1 for managers and another for HR. Managers are only collaborators in the manger interface. would we still be billed the full amount of 20 USD per collaborator even though they don't have full access? 

Hello there! I've built a Base to track "Vacation Requests" and 'balance vacation days' in two simple tables:1) Staff: where fields are name, email, role, hired date, accrued days (formula based on hired date), used days (roll up from the sum of all approved vacation requests), balance days (accrued-used).2) Vacation Request: where fields are req. id (formula), name (linked from staff table), email (linked from staff table), start-date, end-date, requested days (formula), status, duration (formula, only populate if status approved, this field is used on a roll up in the 'staff' table). Up to there, everything's perfect. Where I'm stuck is how to keep track once the 12 month period is reset for each team member. Picture below illustrates an example:   Technically, for that team member that used 27 days already, now "his" calendar starts all over again, and he now should have 28 days available. Since all team members have different "hired dates" this is where I a

Hi Everyone,i am new to Airtable and try to build a small solution for our cycling club. We like to keep track of group rides, so i have three tables:Members (List of all Members)Routes with the fields:NameDistanceRecords with the fields:Member (multiple records, from Members table)Route (from Routes table)DateI have a form there a member can create a records and add a records for a group ride on a date and can select multiple members who joined the ride. A member can do the same route on multiple days.Now id like to create a view which shows a member list with the sum of the distance of the routes.Expected output:Marianne Westhoff, Distance 40Marcel Mertens, Distance 30Daniela Feuersträter, Distance 30Max Wievel, Distance 20Werner Heldt: Distance 20How can i do this?