Ask the Community

Hi - I have two fields, both text:Form Title (same for every record) Form URL (long-#$@$, customized URLs for prefilled forms; different for every record)Is there a way to make the title of the form clickable with the URL - possibly by creating a third formula field? Chat GPT tells me to do: HYPERLINK({Form URL}, {Form Title}). Alas, HYPERLINK doesn’t seem to be an actual function. Does anyone know? Thank  you!​​​​

I currently have a table where I compare student scores to the national mean score. For example, I have 40 students and need to calculate the difference between each student's score and the national mean.I would prefer to do this without repeating the national mean 40 times in a separate column. Is there a way to achieve this with a linked, locked reference?In Excel, using the $ symbol locks the reference cell in another table (allowing you to only input it once). I know Airtable doesn't offer that feature, but I'm sure there's a workaround or method. Could someone share it with me and help?Example of what I want to accomplish in Airtable using excel logic:[Table B1: Student Score]-[Table 2: $B$2]  1550 - 1555 1549 - 1555 1540 - 1555 1536 - 1555 Where 1555 is in Table 2: B2, listed only once

I was using an AirTable interface form on my mobile phone (Android) today. Typed up a bunch of notes and then hit “Save.”   - - - Well, I thought I hit save but it appears AirTable interpreted my finger swipe as a “Back” command. So the form just went back, though, to me it appeared to have saved properly. (obviously these notes were important to me)Needed to add more information to my important notes and behold…. data loss. It’s gone! Is there any work by AirTable to prevent data loss while using AirTable Interfaces? I know AI is a hot-new-database-add-on but you know what AI can’t do? MAGIC BACK THE DATA LOSS!There was no confirmation, no save while working, no method of getting back to the data, it was just gone!That is a profound violation of user trust, this ain’t Windows Notepad in 1995… oh, wait, even Windows Notepad in 1995 threw a prompt saying, “Would you like to save this?” before erasing everything you had typed up.Interfaces are a great addition to AirTable but ya gotta ge

BonjourJe débute sur airtable.Je souhaite faire un formulaire personnalisé. C’est à dire avec le nom - prénom et téléphone en en-tête. J’ai une table formulaire avec un lien vers une table contactJ’ai plusieurs questions :Peut on faire un formulaire avec le lookup de la table contact qui concatenate le nom et prénom  Sinon peut on reprendre les fenêtres nom et prénom et téléphone ? Pouvez m’indiquer si le principe de ma formule est correcte, en sachant que tous les champs viennent d’une autre table, qu’il s’agit de lookup : “https...form?prefill_{champ ex: nom du contact}=”&ENCODE_URL_COMPONENT{champ ex: nom du contact} & {champ ex: prénom du contact}=”ENCODE_URL_COMPONENT{champ ex: prénom du contact} & / & {champ ex: téléphone du contact}=”ENCODE_URL_COMPONENT(champ du télépone} Merci de votre aideViggie

Hi Team,I am currently using the Teams plan, and I noticed that the automation limit is capped at 50 total automations (including both enabled and disabled automations).Our use case requires additional automations beyond this limit, so I would like to know if there is any option to increase the automation quota. Is there an upgrade path, add-on, or alternative plan that supports a higher number of automations?I would appreciate any guidance on the available options.Looking forward to your response.Thank you.

hi all, i am sure this should be easy and i cannot get it to work i have a products table {product id} and {product name}a menu table which pulls the product name using the product idand an orders table which lookups the product name from the menu i am then trying to concatenate in orders the product_name and qty into one string {products}&" ("&qty&")"{products} here is a lookup field i’m expecting Bread(1)but instead get 2(1) 2 is the product id i’ve tried formula, arrays and rollup function thank you

I've created a calendar table synced to GCAL and wish to populate a calendar view with the events based on the Event Start and when Event Start is not available based on Event Created. I've struggled to achieve this (I welcome any other possible solutions) so I attempted to create a formula field with the following formula: “IF({Event Start}, {Event Start}, {Event Created})”.  As generated by the ai agent. Somehow that formula changes both Event Start and Event Created data. I've also tried the following formula: DATETIME_PARSE(IF({Event Start} = BLANK(), {Event Created}, {Event Start}))To the same effect. Screenshot attached to quell my possibly insufficient description. Questions.Why is the data changing when the formula is only requesting to display the data? Are my assumptions about the formula only asking to display data correct? Is my formula broken/insufficient? if so, what's the fix? Is there a simpler way to achieve my goal of populating a calendar view with the events based o

After two years in the AI wilderness, finally the technology is allowing me to do business again with real opportunities to help other entrepreneurs and earn money doing it.  I have learned a lot these past two years, building an app concept in the mental health care space, and now AI audit tools for small businesses.  This past week, I struggled with two AI assistants trying to set up my lead generation database from one of the tools that were ready for launch. The experience, and an interview on YouTube with CEO Howie Liu, led me back to Airtable as a CRM for my new venture. Historically, I used Airtable for marketing content planning. I saw the value of integrations, but I didn’t want to pay for it. Now, I am hearing so many good things about what people have built and the huge benefits at the free level, I decided to come back. A lot has changed here too in two years. So, I’m hoping someone in the community can help me with their immediate experience with integrations through Make

Hi I would like to translate this formula to function in an airtable workspace, please help me.=IF(G2="Yes", SUMIFS(F:F, A:A, ">="&NOW(), A:A, "<"&A2, D:D, "Yes"), "-")

This seems to be a grossly missing option for sorts.  I should be able to check a box to decide if I want blank fields to show at the top or bottom of a sorted column.  I know there is a workaround, but I shouldn’t have to create a workaround for a painfully missing feature.  How do I submit this as a feature request and get everyone to upvote it?

Why when I get just only 1 item in a search node with airtable and 1 item in update record the API calls is not only 2?

Hi all - I’m fairly new to Airtable and hitting a roadblock… I have a form where people submit a list of activities they’ve participated in over a period of time. To avoid burdening the user with repeat submissions, I’ve set up my form/table with Activity 1, Activity 2, Activity 3, Activity 4, etc for all the different fields. However, I’d like to create a clean view where the data in all of those fields wraps up into one list of activities, as different records (i.e., if John Doe submits details for Activity 1, Activity 2, and Activity 3 all in one record, how can I get a list where John Doe has 3 records, one for each activity?).I’m struggling with how to make this happen. I tried nesting the records but it only works for 3 and I have 10 activity fields in my form. Does anyone have experience writing a script for an automation for something like this? I’ve never written a script and have no idea where to even start, so any guidance would be helpful!

Yatendra 

Hey community! Long-time lurker, first-time builder posting here.Like many of you, I've been frustrated with Page Designer living in base extensions while all my users are interface-only. Every time someone in the community asked "can I use Page Designer in interfaces?" the answer was always not yet. So I decided to just build it myself.What I builtA full drag-and-drop page layout designer that lives directly inside an Interface page as a custom element. It looks and feels like Page Designer, but it's a first-class interface citizen.Here's what it supports so far:📄 Page size presets — A4, Letter, Business Card, custom dimensions 🖱️ Drag-and-drop canvas — absolute positioning, resize handles, rotation, layer ordering (front/back) 🔤 Static text elements with {Field Name} interpolation 🖼️ Static image elements (via URL) 📊 Any field from your table — text, numbers, dates, select fields, attachments 🔗 Linked record fields in Table mode — displays related records as a mini-grid, with c

I’m looking for experts to build an all in one inventory management system with CRM capabilities. Each item in our stock is unique. The system needs to work in multiple currencies and track purchases, sales, partnerships in items, stock value, consignment etc. UK based but open to international developers/experts too. 

I have an automation that aggregates all the line items for an invoice - see attached image… That works fine but I would like to have each item be on its own line. So somehow I need to be able to insert a break <br> presumably. Not willing to go to Make or Zapier for this. How can I do this?  

Hopefully a quick yes/no.I have several published datasets right now serving multiple bases all within one workspace.I’m about to split out our workspace into several for permissions control reasons. Will the dataset still be available to other workspaces (all under the same account), or is a dataset limited to just the one workspace it is created in?

Seeking an Airtable consultant with experience building product development, merchandising, or retail operations systems in apparel, home décor, gift, or consumer products. I am currently implementing Airtable for a nonprofit client and looking for hourly screen-share coaching while I build the base myself. Need guidance on product development calendars, cross-functional workflows, linked records, and database architecture. Seeking flexible, pay-as-you-go support rather than a large consulting package or minimum-hour commitment.Thank you! Rebekah 

Hi all,Anyone else having this issue today?  I’m not doing anything I haven’t several times before.  Not sure if the issue is with me or Airtable is having a challenge.  

I had Omni create a custom interface for me. It went through all the steps, and according to omni it is done. But my interface page is still not loading after an hr. I tried this twice with the same resultsl

It would be so helpful to be able to duplicate a group of page elements in an interface page. You can already duplicate interface page elements (i.e. numbers, charts, etc.), but you can’t duplicate an entire group of elements at once. As of now, you have to individually duplicate each element in the group then click ••• → “Move to...” then select the group you want to move it to.

Hi, how can I use script to prompt a user to confirm an action when a button is clicked on the interface? The Button is linked to a record picker on a Blank Layout.I tried adding this to my script:// Ask for confirmationlet confirmed = await input.buttonsAsync("Are you sure you want to perform this action?",[ {label: "Cancel", value: "cancel"}, {label: "Confirm", value: "confirm"} ]);if (confirmed !== "confirm") {output.text("Action canceled.");return;}But I am getting this error:Property 'buttonsAsync' does not exist on type '{ config(): { readonly recordID: string; }; }'.(2339)Here is my script:let table = base.getTable("Test Log");let view = table.getView("New");const recordID = input.config().recordID;let record = await view.selectRecordAsync(recordID);// Ask for confirmationlet confirmed = await input.buttonsAsync("Are you sure you want to perform this action?",[ {label: "Cancel", value: "cancel"}, {label: "Confirm", value: "confirm"} ]);if (confirmed !== "confirm") {output.text("

I know this functionality exists because it was something they were doing at my last job.I have  table that tracks applications and their status’ what I need is the method to turn that into a web form someone can to to our website to fill out so it populates into my table.How do I do this? 

I try to avoid  having to build and maintain our own RAG pipeline when uploading our PDF content. So, if we use AWS service like Bedrock Knowledge Base, can we use integrate Vector DB within AirTable? PDF in AWS S3↓Bedrock Knowledge Base↓AirTable Db Vectors

Why is it not possible to view all of the “Pages” in a base? On an interface view we can create and view all the main pages, but in order to create specific record detail layouts we need to drill down through any and all pages to get to the record detail layout we want to edit. Then we can save a copy and rename and edit, but it would be so much easier to be able to open a “Library” of pages and layouts related to our database so we can easily and quickly view, edit, and copy these.I have to write down and keep track of which page layout I have for different views so I don’t forget where it is and how to get to it.