Ask the Community

Hello,I need two solutions or two ideas for reflection concerning my use of forms via the Interface part of Airtable.I have two separate forms for my CRM build with Airtable :- Form 1: Create a product that will be stored in the product table of my database. (Each time I have to create a new product, because I make unique products)- Form 2: Create a quote, which will include one of the products created in Form 1, and stored in the quote table.I've noticed a few limitations, and I'd like your help.When I create a product via Form1, instead of getting a message telling me that my item has been created, I would have liked to have the id of my created product displayed in return.When I create a quote, and I want to associate one or more products, unfortunately I don't have access to detailed data in the pop-up that displays the complete list of my products. All I see are IDs...Perhaps these are unavoidable limitations...If so, would you have a solution to help me manage the creation of pro

Hi there,I understand that Airtable webhooks have this limitation:The number of webhooks per base is limited to 10. A single OAuth integration can create up to 2 webhooks per base.In a nutshell, users of our integration are creating automations picking Base and Table, and configuring what they want to happen when an event is received. Meaning, a user may build 5 automations for the same Base, which obviously conflicts with the above limitation; however, our users aren't and shouldn't be bothered w/ these API limitations.In order to mitigate this, I'd like to register notifications to a Base (and all, or all relevant tables within that Base), and would then like to broadcast events that I receive from Airtable to the interested consumers. A problem here is that the event payload only contains `base.id` and `webhook.id` (along w a timestamp and the content-mac header). That's pretty unfortunate, as it prevents me from doing that broadcast.Is there a chance we could have the table.id spec

Hi, I would like to extract only the 2nd character of a data field, to concatenate with another complete data field.Can this be done please? Many thanks.

Hi. Still learning here! This support is invaluable, thank you. 🙏I have an automation that sends an email with when 3 specified fields are 'not empty'. The email contains an invoice as an attachment. I want to make absolutely sure that the automation will never run again on that record under any circumstances, - even if I accidentally change a field and the record records a new modified date/time.Is this possible please?

I'm trying to create an interface which will enable review and selection of candidates, in order to select them for our program. They will be reviewed by 4 jurors, so I want each juror to have their own view in interface to give grades (1-5) to each candidate. So basically all 4 jurors  will review and give points to each candidate. I see there is an option in Interfaces to set up to 'view as', but I'm not sure if I can set it up this way, so that each collaborator has their own 'view' all in one interface page, based on their collaborator account. I have attached a screenshot to refer to, as to what I mean with the 'view as' option for different collaborators. Otherwise, is there a better way to set this up? 

I've having a little bit of trouble wrapping my head around this automation. I believe I know how to do this using multiple automations but I'm wondering if there is a way to get it all done in a single automation.Table 1 essentially calculates payments to submit to contractors for each "job". Example of relevant fields in a single job record:Joe payment = $100Sally payment = $150Bob payment = $80Jane payment = $0Bill payment = $0Table 2 includes ALL transactions for the business (income and payments). Record entries linked to a single "job" may look something like:TRANSACTION STATUSCATEGORY (single select)AMOUNT ($)CONTRACTOR (linked field)ProcessedIncome$800 PrecessedMisc Expense$120 ExpectedContractor Payment$120JoeExpectedContractor Payment$120SallyExpectedContractor Payment $70BobWhat I'd like to do is set up an automation that triggers when a new record is added to Table 1. The automation then:Check Table 2 for records linked to the same job referenced in the new T

Currently, I need to integrate my app with Airtable, my customer can connect Oauth with Airtable and sync data from my app to Airtable view calendar. I need to get a list workspaceId to create a new base or table, but I only can get workspaceId with enterprise API, I am a little confused should I buy plan enterprise with my account developer or do all my customers need to have an enterprise account?

I'm so stumped on this. I've been creating automation to autolink my records, but now I have a messy array field and I cannot for the life of me figure out how to autolink it. I've tried six ways from Sunday using all the code available here. Here's the code I've been using: //Define the main table and query let mainTbl = base.getTable("BIOD CALC"); let mainQuery = await mainTbl.selectRecordsAsync(); //Define link table and query let linkTbl = base.getTable("ECO ↔ CREDIT"); let linkQuery = await linkTbl.selectRecordsAsync(); //Loop through the records and find the field to update for (let mainRecord of mainQuery.records) { let mainId = mainRecord.getCellValue("ECO ↔ CREDIT"); //Loop through linked table and match ID values for (let linkRecord of linkQuery.records) { if (linkRecord.getCellValue("eco_id") === mainId) { //Update field mainTbl.updateRecordAsync(mainRecord, { 'ECO ↔ CREDIT': [{id: linkRecord.id}]

I've read the solutions for how to update a multiple select field without overwriting via automation. However, I have a bit of a wrinkle—this doesn't seem to be possible when using a Repeating Group.The background:I have a list of live performances in a table called Shows. I have a list of performers in a table called Artists. The two tables are linked via a Linked Record field so that Artists (one or more) can be added to specific shows.Some Artists perform on shows year after year. I have a multiple select field in the Artists table for "Years Active."The desired automation:When an Artist is attached to a show, I'd like the "Years Active" field in the Artist's record to update to include "2024" in addition to any existing years already in the field.The issue:Normally, I would insert the current value of "Years Active" followed by a comma and then "2024." However, the only two fields I can insert are the record ID and name field. This seems to be a limitation of working within a Repea

Hello everyone! I'm fairly new to Airtable and have a question as I'm building my database.I've found it helpful for me to assign "focus times" for tasks independently from their due date in previous systems, so I added a Single Select field named "Status" that has several options: Today, Tomorrow, This Week, Backlog, Completed, and On Hold. I have attached a screenshot of how that looks.Is there a way to create an automation that (at midnight) automatically updates anything with the Tomorrow status to have a Today status instead? I was able to create an automation to change a singular record, but I failed to find a method to update them all. I'm not sure if it's impossible, or if I just don't understand automations enough yet.Regardless, thanks so much, and have a great day!

Hello all, I have a question, and hopefully there's some type of solution to this issue. I managed 3 properties, but for now - we can just focus on 1. Property A has a total of 100+ units. When an end user fills out the form - they type in the unit number - and this is how I have my automation set up:As you can see from the above image, I have a find record and it will update that record for it's respective tenant. Example: The concern here I'm facing is, because Property A has 100+ units, is there a simpler way of creating automations to find records for each unit?Here's a view of the configuration for Property A, finding the "101" integer:Essentially, the goal is to not create 100+ automations for this property to statically assign each unit, but my fear is maybe I have to?I hope I articulated this!Thanks! 

Hi, Is it only me or are Rollup Filters not working. Tried this with date fields and text ones, and still without any success. Please let me know if there is a solution or it's a temporary bug? Thanks!

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