Skip to main content

User Groups
Product Ideas
Events
Academy
Help Center

Home
Community
Ask the Community

Ask the Community

Connect, collaborate, and solve questions about using Airtable in Ask the Community.

10000 Topics

cballaghNew Participant

posted in Automations

Automated email when date is changed from A to B only

Hello! I am running into an issue automating an email notification when the date column is changed from one date to another. I have the automation set up so that when the date column is changed and the status is 'Sent', the email is triggered. The issue is that the email is getting sent every time the date is changed (including when the date is entered initially).The only workaround I've figured out so far is to set it up so that the record must match Status = Sent and Date is changed and we enter the date column second, but that leaves room for user error. Is there a way to ensure that that the email is sent only when the date column is updated from not empty?

Kosta_KondratenInspiring

posted in Formulas

Convert to standard mobile format (AirTable formulas)

Hi, So I’m using PHP which has this functionality built in (basically I give it a number and it converts it to how I would like it…) specifically I’m in Australia but the format I’ve chosen to go with is like this: +61415932797 so let’s break this down +61 = country code 415932797 < number obviuosly In Australia though when you call someone on mobile you dial 04… so it would be like 0415932797 if that makes sense (since you don’t use country codes when dialling within the country)… so I’ve got a bunch of these mobiles like this in my AirTable: 0402 930 888 - like this which I want to convert to +61402930888 - as you can see no spaces (random spacing in my original) - ideally also skip any fields that have text in them but that’s an easy thing… so… yeh long story short how do I regex 04 01 933 833 to +61401933833 also keep in mind a number could all ready be country code… but then again I could just filter those with + and fix manually or something but would be good if for example +6

MrEdNew Participant

posted in Base Design

search or filter for complete words only

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 

4N85_2Known Participant

posted in Interface Designer

I want to build a Report tool...

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

NicoleUngerer9New Participant

asked in Interface Designer

Form interface for manufacturing

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!

MrPythonNew Participant

posted in Development & APIs

A third-party integration's access to your Airtable account has been revoked

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

DidrikSaNew Participant

posted in Automations

Automatically add records based on a record

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.

mshah72Known Participant

posted in Automations

Pause between triggers

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?

Adam_YoNew Participant

posted in Automations

+1 year to date via automations

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?

Brite_AdminInspiring

posted in Interface Designer

Copying a set of interface buttons to a different interface

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.

fouadabourizkNew Participant

posted in Formulas

Calculating Average Time of Day

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

Mary_UsenNew Participant

posted in Formulas

Assign a user based on what is populated in a field

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

rullagaddimathNew Participant

posted in Automations

Email to Case conversion for Client services

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! 

jezburrowsParticipating Frequently

posted in Other Questions

Count the entries in a lookup field?

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

mnandNew Participant

posted in Formulas

Invoicing Formula Not Correct Total

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

Scott_Gardner1Known Participant

posted in Interface Designer

Interface Formula for a record detail within a record detail

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!

DevonMcMindesNew Participant

posted in Interface Designer

"Invalid Page Configuration" error in Interfaces

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?

Tom_DavidKnown Participant

asked in Formulas

DATETIME_DIFF({Sell}, {Buy Date} 'days')

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

Paul_SkorupskasNew Participant

posted in Other Questions

Categories and Sub-categories

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

RC16_2New Participant

posted in Other Questions

Spliting a column into 2 columns below a single field

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?  

rltourdotNew Participant

posted in Automations

Rollup fields not automatically updating when linked table updated

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?      

Scott_BrastedInspiring

posted in Formulas

Extract months from dates in a multiselect field

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

CficekNew Participant

asked in Automations

Using 'To' Email Address in a Email Automation as Linked Record Email Address

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 

Brian_ScottParticipating Frequently

posted in Other Questions

List Levels in View vs Interface

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???

PekaNew Participant

posted in Other Questions

Do I get billed the same if my collaborators only have access to 1 interface

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? 

1
...
260
261
262
263
264
265
266
...
1369

Page 263 / 1369

Badge winners

ArthurSteelehas earned the badge Welcome
jige1725has earned the badge Welcome
nlh21has earned the badge Welcome
db1593has earned the badge First Reply
williammarkhas earned the badge First Reply

Show all badges

Powered by Gainsight

Terms & Conditions Accessibility statement

Sign up

Already have an account? Login

Login with SSO

Log in with Airtable SSO

Login to the community

Login with SSO

Log in with Airtable SSO

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

Platform Platform Overview Integrations Extensions App Building AI Connected Data

Solutions Product Marketing Operations Human Resources Sales Finance

Learn Airtable Academy Events Video Center Demos Customer Stories Webinars

Resources Partners Services Developers Community Templates Airtable Universe

Company About Careers Blog Status Newsroom Try Airtable For Free

Security API Sitemap Privacy Terms Do Not Sell/Share My Info Cookie Preferences