Ask the Community

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. 

In AirTable, I have 3 Bases; ● One base that includes a table with all student records ● One base that includes testimonials ● One base that includes a record of all questions submitted when we do a Q&A How can we merge all these bases into one base and ensure that everything is linked?

Hi there.I am trying to create a voting system in airtable. Basically, I am hosting an awards show kind of thing (think oscars kinda structure) where people are nominated for awards, and judges vote on the nominees. There are 2 rounds: round 1, each judge in each award catagory individually rates each nominee by a set of 5 criteria; round 2, all the judges from every award get together and vote which of the top 3 from each award should win the award. I am currently finishing up round 1, and am running into a few issues. The issue that I would like to address here is about a "Power Point" or "Je Ne Sais Quoi" point that each judge is able to give 1 nominee per award (its basically there so that if a judge thinks one nominee deserves an extra point they can give it to them). The issue is that as my base is set up right now, a judge can add this Power Point to multiple nominees. Ideally I would like to make it so that if a judge decides to add the power point to anot

I have a base that is designed to be refreshed with data from a CSV file periodically. It has about 140 fields right now and I need to add approximately 50 more. I would like to be able to do this using the CSV Import app, but I can’t find a way to have it load data into existing fields AND add new columns to the base at the same time. I have field descriptions entered for most of the existing fields, which is a big reason why I don’t want to just start over with a new import to create the new fields. If I could get and set field descriptions via API, that would be another route to my goal, but I haven’t found any evidence that’s possible. Am I stuck adding the new fields one by one or is there another way? Thank you for any light you can shed.

Hi, I want to know if:1) Are there are any extensions that would help me with the ability to see the 'saved' information on the lengthy forms started by my customers but not submitted yet?2) Can one customer start multiple forms and save and come back to complete the form at a later time? Example: Adding multiple employees information one at a time by filling up a form for each employee.Thanks! 

I see that lookup fields now have an option to limit the data shown, but it seems very limited to only showing you the data associated with first or last record linked?Is there any way to limit to unique selections only but retain the color labels? We use color on single select to indicate different things like status and priority. So while i can use a Rollup Array Unique, that loses all color and becomes a comma separated list. And no, i do not want to make a special automation to then copy said results to a new field showing the results, as this is excessive and not 100% reliable when there is automation errors or server errors, etc.Would love if Rollup field could retain color on the unique array, OR lookup fields to offer more flexibility to show the unique selections.

I have an image field used in my timeline that i would like to refine. Currently the timeline label can show the first image as the cover image - perfect.Then the popup window when you click on a record should show the "hero" style view of that image lookup field, but instead is currently showing each image separately making you scroll far to see all the fields/images in the little popup window. Then you expand the record details to see the sidepanel, and the images show correctly as a Hero style viewer. - perfect. Any way to fix the popup window to have option to use the Hero viewer?

I'm trying to use this feature of passing the name of the user logged in to the record when a new record is created and it is just not working and for the life of me can not figure out why, clearly I'm missing something. 

How to create a checkbox inside a field Send Email. Need steps.

We have a use case that involves getting goal level data into GBQ so we can blend those with campaign data to build monitoring dashboards. Has anyone successfully gotten their data into GBQ and if so via which connector/ingestion service did you use? We have work arounds that involved exporting to a google sheet and then into GBQ but just wanted to check if there was a less round about method. Thanks!

Our team ran into what seems to be a pretty annoying bug with the timeline view.After a while if you keep on scrolling up/down, eventually the sidebar where it shows how things are grouped by completely disappears. To me this feels like a bug where whatever is suppose to trigger redrawing it hasn't been fired. To fix it you have to scroll again to force it to redraw, though sometimes it also still disappears. Another way to force it to redraw is to resize the splitter.I managed to replicate it in a new Base with a very simple table (see attached gif). Although it doesn't look so bad in this example, in our actual Base this can be incredibly frustrating as it's happening frequently enough, hurting Airtable's ux. 

I have an automation set up that sends an email (through gmail) based off a row.I want to send this with an attachment where the attachment is the same for all users or it is provided as a lookup field based off a value.i.e Option 1: Send all users the same attachmentOption 2: Depending on the value of a field send one of 3 attachments However it seems that with the gmail automation we can only send attachments from an attachment field in the row. So I can't just choose the attachment or point it to a lookup field.Are there any workarounds for this? I've considered Zapier/SendGrid as alternatives but would prefer not to.