Ask the Community

Hi All,I'm not sure if this request can be better accomplished with a formula or an automation, but it feels like an automation, so I figured I'd start here. I have a form that populates several fields in a table, one of which is "Email Address".I have a field that is marked "User" which is a multiple user field that contains either a) a Base team member (from the dropdown), b) an email address of an external user, c) or several usersI have set up a few different views in Interfaces that are controlled by this "User" fieldIdeally, when a record is submitted via form I would like the email address they entered to be automatically added to the "User" field as a user so that they can then receive a link to access the Interface that shows their results. This is the use case 90%+ of the time.Is there an easy way to make this happen? I seem to have figured out how I could automatically add a Base team member thru automations, b

I'm writing a script to create records from an API call. One of the fields is a single select option. At the start of the script, I want to use the input option for the user to pick an option from the single select, which will be used for all the records. I don't see any option to pick from a single-select list. Is this possible?https://airtable.com/developers/scripting/api/input 

Hi all, I’m a novice at airtable and some of the lingo is even over my head, so please bear with me. I’m a small business owner. We use Airtable to track our projects, sales pipeline, contacts, tasks etc. I am trying to create a custom grid view of my projects by quarter so I can see our projections. I would like to hide other info to be able to see a focused view. I have a column which is projected close date - I thought I could filter by this field, but it’s too limiting. Could anyone help here? Appreciate the support!

HI,I'm implementing a base for approx. 20 users and for security and confidentiality reasons I need to use a grid element in the interface to display each user's  records .While the grid is working correctly,  I have some formatting questions that I have been unable to figure out the answer to.1) while the user can copy/paste from the grid out to Excel , is there any way to copy out the column headings as well (as in a CSV Export from the data layer) ?2) As this base is replacing a spreadsheet, I'm displaying 16 consecutive columns of numeric values. Is it possible to format any of these columns to make it easier to read ? ie Bolding, changing background colour of a column etc ?3) Is there any way to hide the Base's Key field in the grid element ?Any help or suggestions appreciated .John 

Heyo!I'm stratching my head as to how exactly format a formula down to first .00 numbers for an email automation.Inspite what I've attempted it continues to display all 13 numbers for "M1" calcuation. Screenshots attached.

Hi,I am using airtable base for my job. I visited persons and I have to repeat this visit every 2 to 4 weeks. When I finished my visit to customer,  I wrote in aitable base report and then airtable base recorded the day and time in the last modified field. Now I have my costumers who are not same level and I have a colon with numbers 14, 21 or 30 these numbers are a number of date which I heve to visit customers again. How I can do this in airtbale.example I was in visit of my costumer 1 septembar 2023, he is my important customer and I want to see him again after 14 days. I need formula in the fild where the Airtable will give me notification that I should see him 15 septembar 2023, Exemple 2 I was in visit of my costumer 1 septembar 2023, he is my not important customer and I want to see him again after 30 days. I need formula in the fild where the Airtable will give to me noti

I've created a form for collecting sign in/out info and times for a space here at my work. It's a simple form with a spot to input your ID# and then a single select question with two options (Sign in or Sign out). If you select Sign out then an Optional Conditional Field opens for Notes. It fills out a table for us to view who is in the space at a given time, and keeps track of who was in and when.The form works fine on a computer. There is no issues with that portion of this. But when I try to load it on an older iPad (iPad 2 Mini running 12.5.7 which is as high as this older one will go) in either Chrome (version 92), or Safari (version 12.1) I can't get the form to load. The link works, it tries to load, but I just get nothing. When I tried to view a Gallery View link all I got was the blue outline around the page. No cards, no info.Airtable's own spec page shows that the requirements to use the Browser view of Airtable is iOS 11+, Chrome 67+, or Safari 12.1+. I've

Hi everyone!i'm a "newbie" using airtable but i learn fast.I have already the integration w Slack, now i need to create an automation that remember 1 day before a Holiday happens AND I've to tag my partners.....any ideas?i can create the trigger and everything looks good! but i just can't run with the exactly date and tags.

I reached out to Airtable's support 10 business days ago regarding a significant billing issue (upgrading the incorrect workspace to a yearly plan) and then followed up at the 5-day mark with an additional message. Outside of an automated email stating that they would get back to me within 72 hours, I have received no correspondence. Are there any other ways to contact their support staff? Not responding at all is just unacceptable.

I am importing customer support tickets from another database (Hubspot) in an attempt to calculate the following:1) What is the duration between each ticket date (single field) for the same product serial number? The goal is to understand the average duration (in days) between customer tickets for each product (serial number) sold. For example, if one product (serial number) has three ticket records (imported from Hubspot) - If the first ticket record has a date of 1/1/23, the second has a date of 1/4/23 and the third has a date of 1/8/23, it would return the dates of 3 days and 4 days between each sequential record. How do I get Airtable to calculate the date difference from the same field? 

Hi and thanks in advance for the help!I have multiple IF statements that I would like to include in one Formula field. Essentially what I want is the output to be in one formula column with the output being:Result from IF STATEMENT#1(line break)Result from IF STATEMENT #2IF STATEMENT #1IF(  {Requestor job level} = "Individual Contributor","🍅 Individual Contributor",  IF(  {Requestor job level} = "Performance Leader (Manager)","🍋 Performance Leader",  IF

I have a base that mirrors a health record system. I have a Forms table and a User Role table connected by a linked record field. Whenever new or existing forms get added to user roles, I have been manually adding and linking the forms to the associated roles. I can pull an updated list of forms associated with a given user role from the system and clean it up in Excel, but when I try to import the new list and merge it with the existing list using the CSV import tool, it always ends up creating duplicates, even when I select "merge with existing records". I've tried using the Import Data tool, but that won't let me update linked record fields.What am I doing wrong? I wish there was some way I could just copy and paste from the form list in Excel into the Forms field in Airtable and have it just overwrite what's in the cell and create new records as needed.Thanks!

Hi there,may I add a button in Interface Designer to allow my users to import CSVfiles?

Hello,I am looking to create a rollup field to display the next task due for a project.  What I would like to do is have the rollup field display the task name, but the formula should reference something like the MIN({due date}) in order to select which of the many tasks are due next?  Can't seem to make it work and am wondering if it's possible or if I'm going about it wrong?Thanks!

Is it possible to send more than 160 characters with the native Airtable/Twilio automation integration? I have a couple clients set up on Zapier to achieve this end but am trying to avoid the added expense in this situation. Thank you in advance!

I got a button field that triggers a URL webhookI want to run it for all records in my table, but one at a time.Hit the button for row (i)... wait (could be time based... say 30 secs), then run row (i+1)How can I achieve this?Thanks

Hello! Whenever I create a new record, one particular value from a Multi-Select table automatically populates. I didn't intend to do that and can't figure out how to reverse it. I've tried to figure it out on my own, but haven't been able to yet. Thanks so much for help!

I am building a custom extension which will send data from Airtable to a third party API (the user will provide their API key to this API). This third party API will then send updates to the base, which will update a given record. I cannot find any solid example of how to create a custom extension that can update a base async (this API runs twice a day) rather than when a button is clicked or another action performed by the user. I know I can use an Automation to trigger the response to the incoming webhook, but I want it to all be bundled within the extension. Is there no way to do this without having the extension and automation separate?

i can t create an api key I don't even see the option  

Hi all,Ok - new to Airtable.https://airtable.com/appbgoYJec9KPYoqi/shrYzlz5OShqp6xpLBasically, i'm creating a timing sheet for a racing event. I'll add the times manually as the event progresses, and I want the crowd/competitors to see the details on their mobile devices WITHOUT HAVING TO REFRESH PAGE EVERY TIME.I initially thought this could be done by embedding an iFrame on a Wix site, but iFrames don't update automatically. Well, the LINK does, but the page doesn't.So then I thought maybe I could just share the view with the "share link to this view" feature, but that doesn't update automatically either.The only other thing I can think of at this stage is to get everyone to install the Airtable app and have them view it through that? Is there a way to share the link so that they can somehow see it, NOT be able to edit it, and don't have to refresh the p

HeyI want to build a "lessons" table with all the lessons that I have with my students.I want to recursively schedule an event each week with part of my students (like I can in Google Calendar)Is there any option to do it?thanks

How to Create Formula that Returns the Data in Field 1 (if data exists), or Field 2 (if no data in field 1 and has data in field 2), Same for Sequentially Fields 3-5? I see there are several posts on how to choose a “text” result by writing that text in the nested IF statement. However, I am looking to return the data in field 1 (check this field first and return the data in field 1 if data exists in field 1), and if no data exists in field 1 move on to check field 2 (check this field next and return the data in field 2 if data exists in field 2), and if no data exists in both fields 1 & 2 move on to check field 3 (check this field next and return the data in field 3 if data exists in field 3), and if no data exists in all three of fields 1 & 2 & 3 move on to check field 4 (check this field next and return the data in field 4 if data exists in field 4). There are 5 layers through field 5. Thanks so much in advance for your insight and time! I appreciate it.

I want to sync PDF files via Google Drive however this method renders a low res PDF and the important copy that I need the reviewer to approve is not readable.Is there a way to stop this or is loading the attachments manually the only option?Thanks!

I'm trying to send data with a series of prompts to chatgpt and get a response of each item back into Airtable. I want each subsequent result to be based on the whole conversation so far. When I try and run this as an automation I keep getting a time out error.Can anyone help?Here is the code I have:let table = base.getTable("Brand Guidelines");let view = table.getView("Grid view");let records = await view.selectRecordsAsync({ fields: table.fields });const apiKey = 'OPENAI-API-KEY';const url = 'https://api.openai.com/v1/chat/completions';// Set the batch size (adjust as needed)const batchSize = 10;for (let i = 0; i < records.records.length; i += batchSize) {const batch = records.records.slice(i, i + batchSize);for (let record of batch) {// Initialize the conversation contextlet conversationCon

hai my name basi , from india in my airtable i trying to make summary table for purpose of make an interphase, Our airtable  have a two table name as, 'JOB NO' and 'SUMMERY copy'and in 'JOB NO' have 3 fieldwhich has ,'EMPLOYEE' - employee name'DATE2' - it formula field with like this '9/8/2023 12:00am' in date phrame'DUTY TIME' - duration fiedso i am try  convert the 'JOB NO' data in to another table like thisif  TABLE 'JOB NO' DATA LIKE THIS :-BASI--11/07/2023--2:0SKIL--12/07/2023--5:0BASI--11/07/2023--1:0BASI--12/07/2023--2:0SKIL--13/07/2023--5:0'SUMMERY copy' need BE like this :-BASI--11/07/2023--3:0SKIL--12/07/2023--5:0BASI--12/07/2023--2:0SKIL--13/07/2023--5:0employee name need in 'EMPLOYEE' in table 'SUMMERY copy'date need be in 'DATE' ( date field ) in table 'SUMMERY copy'sum of duty time from JOB NO in 'SUM'( duration fie