Ask the Community

I just imported an Excel Spreadsheet but one of my formulas did not come through – namely, =INDIRECT(SUBSTITUTE(fieldname," “,”_")) The value of the previous field determines the single select options for the subsequent field. I notice another user posted this request last year, but for some reason the topic was closed a short time later. Does anyone have a workaround? Dynamic dropdown options on forms

Is there any substitute for INDIRECT in AirTable?

I have a table that generates specific tasks for clients on a frequency that required an interesting set up, but got me the result I was looking for (leveraging multiple formulas, jump tables, and linked records). Currently, the tasks are generated into a table called 'Client Work' that my team works the tasks out of. I have other team members that need to submit tasks to that same table, but are one-off tasks, not auto generated tasks. Unfortunately - the primary field (Task Title) is a formula generated field that combines multiple look up fields to generate the title, so I am not able to have Task Titles. I am looking to add an "OR" function, IF the fields that the formula is referencing is blank (aka: a work around to have another field that acts as the task title that will only be used whenever a task is generated via a form). For the task name issue – I feel like I have a potential solution, but need some guidance on the formula for th

Hey there!I've been having problems calculating and displaying a metric through Interfaces. My ideal end use will be displaying the rate/calculation in a chart so it can be displayed overtime, but I'll settle right now for being able to set the number to a Number Element if it's too hardSo - I'm trying to get the metric Contacts per Purchase. I have a contacts table that has all the contact information plus two relevant fields deal_status (single select) and email_date (date lookup field from the campaigns table).This metric would be easy enough in other system because it would be the simple (Count Contacts / Count {deal_status} ="Purchased") grouped by email_date month buckets or dashboard filtersGiven that neither the Numbers or the Charts elements allows for internal calculations, does anyone have an approach to this issue? I'd rather avoid heavy automation of nested linked because of volume

I am looking to update multiple linked records w/ the current time/date in one table when a button is clicked in another table.Here is a screenshot (shows checkbox, but a button would be my preference).I tried creating an automation but if I understand correctly it is not possible to run an automation on multiple records. So I believe I may need a script.I know enough to be I can make small edits to a script but if someone could help get me started and confirm if this is possible it would be a big help.Any and all guidance welcome and appreciated. Thanks!

Hi! Enjoying the automation features of Airtable. It would be great to be able to sort the records found via the “Find Records” automation before sending them to the next step. As of now, they are sorted by the time the records were created, which is logical but seldom what we’re looking for. Thanks!

Is there a way to use formulas in the Send an Email or other action in Airtable automations that takes the data from a Find Records step and does some simple manipulations with it, like a SUM() function of all properties of listed records?In my example, I charge my car off of an electrical outlet in front of my landlord's house and pay them each month for the electricity I use. I have a base with an entry for each charging session that calculates the money I owe for each charge. I can easily send an email with a list of all the charging sessions for the previous month, but I would like to send a sum of the cost property (a formula field in the base that outputs numbers) instead of just the list of individual entries.What seems like the most simple way to do it would be something like a "Formula" action that takes data from previous steps and manipulates them using the Airtable Formula Field reference, and then lets subsequent action (update record, send email) use the

Just recently noticed when printing from a list interface, the field headers are now off center from the data below it when printing / PDFing. They appear aligned as they should when viewing the interface itself, but are off once you print. And this is different than the field columns I have for the next level up on the hierarchy, I know those can be resized independently.Anyone else see this happening?Interface view herePrinted view hereUsing this function to export PDF reports daily so hoping I can find a fix to make this look more organized again. Currently using Arc, but happens in Chrome as well of course. Haven't been able to get this view to ever print fully in Firefox or Safari, but in the portion that will show up when printing, the hea

My Customers book appointments through google calendars. When they book I want their info to be added as a new contact in my airtable base. The issue is that the info doesn't show up clear and their email, phone number, and name all show up as one massive gargle with page breaks and such. How can I tell airtable what info to pull for what column (name, email, phone number)? Also, Once this data get cleaned I want to set up an automation to add that contact to google contacts so that when someone calls their name shows up on my phone. Is there a way to link their airtable customer history to their google contact? 

Hi there, I am wondering if it is possible to assign records a queue number? I have created a view that would be great if all records in this view are numbered >1 and all other records 0 or something similar. This is so customers can log in and see their order is number xxx in the queue. Thanks!

How to make a line break when I do strings concatenation? For example, I have 4 fields and I do a concatenation: "field_1: " & value_1 & ", field_2: " & value_2 & field_with_lots_of_text I’m trying to do smth like that: If I do like thins, it works ok: But I want to add more data and add a line break:

I'm trying to update a long text field with rich text, but the documentation seems all over the place,How do I update the field via a POST request? (or any other way).For context, Airtable says that Markdown is supported in rich text fields which is partially true. A different doc shows that only a small set of Markdown is supported in the long text field.I'm trying to update the field with links and bold text, which apparently isn't supported Markdown syntax, BUT it is supported in the rich text field.In the base's api documentation, they show an AST:[ { "type": "paragraph", "value": [ { "type": "paragraphLine", "value": [

Hello everyone. Looking for a way to share an interface form (registration for one of our programs) but  not allow submissions yet. We want to promote the program, show where to register but we do not want to allow submissions to the program for about a month.  Any advice?

Using the API, how can I retrieve a list of possible values for a Select field?The documented way is with the Meta API - https://airtable.com/developers/web/api/get-base-schemaBut, for me, https://api.airtable.com/v0/meta/bases/{baseId}/tables returns: `[404] INVALID_API_VERSION`

Hello everyone,I have two tables. Table 1 contains campaigns and table 2 contains events. The events can then be linked to the campaigns with a linked data record. Now I would like a notification to be sent to the creator of the event if something changes in the campaign.I would also like to display both the campaigns from Table 1 and the events in a timeline overview. How can I do this with values from two tables?Thank you and best regards.

TL;DR: Do I just need to replace my Airtable API key with the new personal access token or is there anything else?I read about the Airtable API key depreciation notice that says API keys will no longer work from Feb 1, 2024.I am using the official NPM library airtable.js in my Next.js project. This is how I am configuring Airtable in my codebase: const base = new Airtable({ apiKey: process.env.REACT_APP_AIRTABLE_API }).base( process.env.REACT_APP_AIRTABLE_BASE ) To adhere to the new changes, I have created a personal access token from `/create/tokens` as mentioned in the

Hello everyone,I have created an Approval / Status Process for a table. The following options are available: Planning is automatically selected when a new element is created. Then a user should be able to select Ready to Review but none of the other options. This starts an approval process. After approval, the status is automatically set to Approved. Now the user should be able to switch back to Realization but none of the other statuses. Completed is automatically selected when the end date has passed.How can I ensure that the user can only select the desired options? Thank you and best Regards.

Can I add a table to “long text” field?I want to add table that include columns " code - description - price" example:code - description - price“1167 - bike tire - 75”

Hi all 🙂 I would like to import a larger amount of old emails into my base (at this moment I use a ZAP between Outlook and Airtable, but it is only for the current incoming mails).Is there a solution, or somebody had a similar problem and experience?Thank you in advanceImelda

Hi!I'm trying to design a database where products are made up of a number of different units. Let's say there are a maximum of 10 types of units, but the quantity differes from each product.For example:The product Box1 consists of 64 units of part X and 64 units of part YBox2 consists of 12 units of part XBox2 consists of 128 units of part X and 400 units of part Z.How do I design the database to make it easy to add a new product and enter information about the units?

Hi there I do not have found a solution on the community or the web to my problem I try to resolve using AT. I have a huge library of books. Instead of typing all books into a AT database (e.g. Book Catalog provided by AT) I would like to Scan the ISBN bar code (which is on each book) and populate my database with author, title, year etc. - basically all the record available on apps such as goodreads etc. After all, the barcode can be read easily, it should after reading “simply” populate the record with the relevant data. Does anybody have any idea to do this? I have read, that it may be possible using API - but I have never worked with this. If so - could anyone give me some initial information how this could be achieved? Any help is highly appreciated. Thanks

Hello Airtable Community,I am currently facing a challenge with importing data into Airtable and properly linking it to existing lookup fields. I have a set of customer names that I've exported from a FileMaker database into a CSV file, and I'm trying to import these names into my Airtable base. My goal is to link these imported names to a lookup field that references customer names in another table.Here's a brief overview of my setup:I have a table (let's call it "Customers") that contains a list of customer names.There's another table where I'm importing my data (let's call it "Orders").In the "Orders" table, I have a lookup field that should display information from the "Customers" table, based on the customer names.The issue I'm encountering is that the impo

Hello,After the customer submits a request form to the client for order fulfilment, if the client has a follow-up question for the customer - Is there a feasibility/workaround to submit a comment/question on the request so that it can be re-directed to the customer for further clarifications/information? Can somebody suggest a workaround? Thanks!

I'm looking to run a script when a record is created which would created a new form for that individual record. I need to do this because when clients will be using the forms, I can't have them be able to add data to other clients so by default I'm creating a form with the default values that can't be changed. Does anyone have a better solution to this problem or is there a way to do this?

I have a base that has all of our employees (~200) in a people tab. Every month our finance department sends me an updated Excel with everyone that months actuals in terms of employees. Given the number I would like to be able to CSV import this file and then be able to update the people, as well identify who is no longer on the list - and who is new to the list. Additionally, it would be helpful to be able to use this information in the extensions/interfaces to show charts on the over month-to-month headcount change.I think I will need to have some record indicator for each person that the records can align to but every idea I have had so far seems overly complicated.