Ask the Community

Hey y'all, hoping you can help me solve a thorny issue. We use Airtable in a big way across all of our teams, and we've built a Daily Duties board to give ownership and sightline to the must-happen daily needs of the business. Individual team leads assign their team members to the tasks weekly.The issue I'm having is in maintenance - currently we are duplicating the empty records weekly which is cumbersome and time intensive. I'm sure there is a way to do this via automations, but the issue I run into is date/time fields - running an automation to create records at a date/time, but neither configuration for start/end time - static or dynamic - is getting me what I'm looking for. We have both a start and end time so that it can be easily shown in a calendar view like the attached image. Any advice? I've bopped around here on the boards for a bit now but haven't found a particular case that matches what I'm looking to solve. Thanks!

I am working to automate a process that feels like I should be able to script but have been struggling. Admittedly I am new to scripting so I may not be understanding how to structure this, I have asked around, tried to get an assist from Chat GPT, and poked and prodded this along but the final outcome has eluded me. Let me break down the intended function and drop the code in. Any help is greatly appreciated.  Intended function:The automation is initiated when a record enters the "Meetings" view of the "Connections" table, there is a text field called "Attendee Emails" where a formula has collected and concatenated emails using ", " as a delimiter. We are passing that through to the script as an input variable called "attendeeemails". What we need is for the automation to go through the string stored in "attendeeemails" and pull each email out one by one, and check each individual email against the "Email" field in the "Full view" in the "People" table. When any individual e

Hello,Not sure if I overlooked the obvious, but I could not do the following which seems simple :I have a table with contacts (persons) with their mail, function etc. They are linked to 1 Company in the companies tables, companies which have an address and Zip code. I need to display a list of all contacts filtered by the Zip code entered in Filters: how can I retrieve that value from their company ?I already placed all companies in a nice Googlemap addons so salespersons can visualize where clients are, but values were all in the companies table, whereas here I need to show the contacts emails to reach them if someone visits their region. Thank you !

Dear all,when I recall the records of a base table (es. company) in a record of a second table (goods), I need to filter the former directly in the windows of recalling; if I insert the chatacter "*" it is not seen as "any character" but as is and the filter does not find nothing.Is there a character that does the function of "any character"?Thank you to all.Best regards.A. Borriero

I’m using the Send email action in automations but having a problem with the signature line. I want it to be: Katherine Kasmir Executive Director BRITE But it shows as: Katherine Kasmir Executive Director/n BRITE Is there any way to get it to look like the top version?

Hi, I’m looking to build MVP using Airtable. So, I would create Airtable form where customer would choose answers. After form is filled based on the answers, at the end of the form customer should see XY amount. Customer should be able to pay that amount via PayPal or Stripe. Is something like this possible to do with Airtable? Thank you for help.

I've just read that there will a limit of 1000 calls per month to the API... I use the API on several base to expose data on small website but I can't find where is current state of those usages... So I can't have any idea about my monthly number of calls - How can I check this ? There are statistics of items in base, automations, users... but where is the API consumption state ?Thank you.

Is it possible to have an input Mask in the tables / forms? I want a field to be displayed in the format S0123, or another field to be displayed as 4 digits such as 0025 (not simply 25). Thanks in advance all.

Hi allI have an interface which allows users to add new rows, using the 'Record review' interface layout and the + button form at the top of the list of records on the left.I have a simple linked field, linking to a company table. Why doesn't it display any data from the company table as it does in some grid views when linking data? The linked field has the code as a primary field, but it has extra fields such as name and type etc, that would be really useful for the user to see which company they are linking to. This seems like a bug?  any suggestions?thanks 

Hi! I'm building an extension and I need to make sure that now that is done everything is working like it should. I need to test it but I was wondering if there's any way I can test it live or upload a beta version? 

Is there a way to easily setup and use “constants” across an entire Base?For instance, the price of oil per barrel might be 40. I have a lot of formulas that depend on that price. In addition, I might have several numbers like this that need to be referred to from multiple formulas - for instance the /mile that the IRS accepts for the mileage deduction, the number of tons of gravel contained in a gravel truck, etc.The advantage of the “constants” is that, if the price of oil changes, I need to change just one number in one place; I don’t have to hunt through tons of formulas looking for a hard-coded “40” in the formula.Is there an easier way to do this?

(This might end up in Features request, depending on what I hear back). Wondering if there is a way to do mailing address validation. I am looking for something like Smarty Streets or apparently there is an add-on to Excel (Windows only) from Pitney Bowes that will at least check to see if the address is possible (i.e., it will tell you that there is a 100 Block of Main Street, but not that 123 Main Street actually exists, as I understand it). I am developing a Base with Form entry, where people can enter addresses. In the past (not on Airtable), I have had to export a special CSV file with addresses, submit it to Smarty Streets, reimport it into the sheet. I would love to have addresses validated as they come in. Thanks!

HiI would like to create a number field "recall" that each time the record is update make something like that: recall = recall +1.I used the automation with the update record filter and I try to apply formula on the recall filed by used a formula like tahs: SUM({recall}, 1) but it is returned an error about the format of the value.Do you have idea how to increment the value?For the moment I fixed by add string +1 and the result is "+1+1+1+1+1" for each time the update is execute.Thanks

HelloI want to copy one cell into another when the first cell gets updated. I have a formula field that generates an output: eg. Monday, Tuesday, FridayAs soon that the formula field gets updated, i want to copy it in to a multible selection.It is important, that not the whole row gets copied only the cell with was updated.Thanks for yout Help!

Hello, I am trying to integrate with AWS, but I keep getting the issue of “Missing Authentication Token” when running my script to update records onto my AWS DynamoDB. I am following the guide given by Airtable on how to integrate this. Has anyone had a similar issue? Thank you, Sahith

I am trying to combine an IF formula with a DATETIME_DIFF formula and I am not getting the results expected. Goal: Determine the difference between two dates to see how long something takes, but never have a value of "zero." I want the lowest value to always be "one."Start DateEnd DateDuration (what I get)Duration (what I want, instead)1/1/20241/1/202401 1/1/20241/2/2024111/2/20241/4/2024221/4/20241/4/2024011/5/20241/10/202455 I started with this DATETIME_DIFF formula to calculate duration:DATETIME_DIFF({End Date},{Start Date},'days')Then I tried introducing an IF formula to replace "zero" with "one" when duration = "zero" (I tried many variations on this):IF(DATETIME_DIFF({End Date},{Start Date},'days'),0,1,DATETIME_DIFF({End Date}{Start Date},'days'))Airtable accepted some variations on this formula, but when it was accepted, it was automatically changed to this:IF(DATETIME_DIFF({Date Finished},{Date Started},'days'),0,1)And the result is this:Start DateEnd DateDuratio

So i have a problem that i have been trying to figure out for awhile now. Some of the data that I am tracking contains Julian Dates when i paste the data in. It is currently in the format of YDDD where 9045 = 2/14/19 or 0105 = 4/14/20 . I have been using excel to convert these 4 digit Julian Dates into Calendar Dates using the following formulas. For 2019: =DATE(2010+LEFT(C1),1,RIGHT(C1,3)) for 2020: =DATE(2020+LEFT(C1),1,RIGHT(C1,3)) This has been by far the fastest solution i had been able to find at the time to convert the date as all it takes is a few minutes to copy paste from airtable into excel and then copy paste into a different column in airtable the converted date from excel. I have not found a viable solution to convert the 4 digit Julian Date to a Calendar Date directly in Airtable so i thought about converting that 4 digit Julian Date to a 7 digit Julian Date (YYYYDDD). by breaking down the 4 digit date into several different columns in Airtable and using additional colum

Hi AllI am trying to build a formula to reflect Master project status based on (sub)project status. Here's what I have. So the hierarchy should be:If ANY of the project status contains "ongoing", then master project status to reflect "ongoing"If "ongoing" does not exist and any of the project status is "planned", then master project status to reflect "planned"If "ongoing" and "planned" do not exist and ALL of the project status is "hold", then master project status to reflect "hold"The remaining should reflect as "concluded"So in the below table, the correct reflection should be:Row 1, 3, 4, 6, 8 should be "ongoing" (because "ongoing" applies to any)Row 5, 7 should be "planned"Row 2, 9, 10 should be "concluded" Thank you!!

Hello!Situation:I have a table named « Leads » in which is all the information of my prospects (first name, last name, email, phone Numbers).These prospects, via a Tally sent by email, inform their needs with regard to 9 products (always the same). Some customers take all product references, others only 1, nothing is mandatory.With my current organization and a Make automation, the columns that have the title of the different product references are also in the leads table, which is not very optimized.So I created a new "products" table in which a row corresponds to a 1 product and each column to information containing the latter (name, reference, power).Here is my question: how can I ensure that when prospects indicate the products they want via the Tally, the information is properly / correctly stored on airtable?I don’t understand how to establish good relation/look up.The purpose being in the second step to concatenate the product infos + quantity in order to be able to place it on

 

I have made a formula to calculate the date difference between start date and end date and returns a value in terms of day and hours as a fraction like "4.75" here is the formulaIF(  {End Date} >= {Start Date},  ROUND(DATETIME_DIFF({End Date}, {Start Date}, 'hours') / 24, 2),  'Invalid')But right know i want to change the above formula only for working days tho, i know there is a formula to calculate the working days difference  WORKDAY_DIFF({Start Date}, {End Date}) hence it returns in terms of days only like "4" but i want to return the hour also like "4.71" 

I wish to add files to records from Google Drive.I thought Airtable's Attachment field had no native integration for this - but, actually, when I open the "Add an attachment" window, I see a range of files services including GDrive, with which I can authenticate (what's going on?)...However, there is also a problem...Whilst the subsequent file browser shows my GDrive files which I own, it does not show files shared with me to which I have access. While shared folders are visible, their file contents are not available to select.This is in contrast to Monday.com. In that, I notice that shared-with-me files are available to add just fine.Is there any way to enable this, please?

If anyone from airtable is reading this my extension was submitted several weeks ago and I've heard nothing so far. thanks. No reply from the reply address I was given when submitting it.

How do you work on Airtable when ther is no network ?Modern Web&Mobile developpement provides features to cache content and postpone request in order to make UX available partially offline.But ...Interface, Forms, etc ... are not available as a mobile app (unless you hack it using Kiwi Browser)AirTable mobile App seems not to be a lot of cachingDid someone find a workaround or a Chrome Extension wrapper ?

Hi all!Maybe someone has solved a similar problem.I'm making a kind of task tracker, but I can't solve the following problem. I want to do the following in the task picker interface:1. You can select a record from the database (already done)2. For the selected entry, using the button, you can create a related task entry, which will be linked to the firstHow to solve the second point? I tried different variations of automation, but nothing worked for me