Ask the Community

We were looking for ways to expand Airtable access to internal teams without adding everyone as a paid collaborator.Shared views were too limited, and Interfaces still required collaborator access for anything interactive.So we built a front-end portal where team members can log in, view just their data, and update records if needed. No Airtable seat required.It’s now evolved into a tool called ClientlyBase — useful for internal dashboards, forms, and lightweight access across teams.Curious if anyone else here has dealt with this — how are you managing access for non-collaborators?

Basically, I want to import a Google Sheet into AirTable then I want to be able to edit fields in AirTable and those fields are automatically updated in the Google Sheet.Thanks for any help!

Hello everyone,Who can tell me the formula to get the attachment URL in the new https://v5.airtableusercontent.com/... format? The one below only returns the format https://dl.airtable... which no longer works. IF( AND( {Attachment}, FIND( ",", {Attachment} ) = 0 ), RIGHT( LEFT( {Attachment}, LEN( {Attachment} ) - 1 ), LEN( LEFT( {Attachment}, LEN( {Attachment} ) - 1 ) ) - SEARCH( "https://", {Attachment} ) + 1 ), IF( {Attachment}, RIGHT( LEFT( RIGHT( {Attachment}, FIND( ",", {Attachment} ) - 1 ), LEN( RIGHT( {Attachment}, FIND( ",", {Attachment} ) - 1 ) ) - 1 ), LEN( LEFT( RIGHT( {Attachment}, FIND( ",", {Attachment} ) - 1 ), LEN( RIGHT( {Attachment}, FIND( ",", {Attachment}

I’m trying to set up a “Get in Touch” button in Softr that opens a form (asking for name*, email*, phone number*, organisation, and message*). The form should create a new record in my Airtable “Get in Touch” table and automatically associate it with the specific person (from my Contacts table) that the button was clicked for.I’ve set up both the Contacts Table and a Get in Touch Table in Airtable, but I’m not sure how to pass the member’s information into the form so the submission links correctly. Should I be using a hidden field, a details page, or another Softr setup for this?

Hi All, I uploaded some 300 dpi food labels that print perfectly from the individual record. Clean and crisp. They measure 4.247"h x 4.027"w and I want them to print four-up on a letter-size page via PDF. We currently do this with our Access but are transitioning to Airtable. In Photoshop these show up as 1274px h x 1208px w. I tried setting both the record size and the field size (for the graphic) to these dimensions in Page Designer. Then, I selected Print Records in a Specific View to PDF. The labels were huge (one per letter-size page) and very pixelated. I looked at the AT record settings for an index card, which was in the ballpark while not exactly the same size as our labels. They, surprisingly, were only 327px x 545px. So I calculated the ratio of pixels to inches and applied that to get the dimensions for our labels of 447px w x 472px h and entered those dimensions to the record and graphic size. Print setting: Records in a Specif

Hello community,I’m a coordinator for events around Cleveland, Ohio and we track food truck vendors in Airtable. Each vendor needs to submit a TFSO permit (Temporary Food Service Operation), which is a standardized PDF. Right now we export each record from Airtable and manually fill out the permit PDF, which is repetitive and slow. I just discovered Instafill.ai, an AI PDF form-filling service. They have a case study about automating Michigan STFU permits, which sounds like exactly what we need.Has anyone used Airtable automations to send base data to similar services? Or used Zapier to automate filling PDF permits from Airtable records? Any tips or examples would be a huge help. I can share the blank permit PDF if that’s useful. Thanks!

Hi all ​@Mike_AutomaticN ​@ScottWorld ​@TheTimeSavingCoI am looking for advise when to use self linking vs a seperate table.I currently have a one-one relationship with buyer enquiries and seller quotes. However we now want to send the enquiries out to our selected suppliers to provide quotes to us before we approve them which sends the quote to customer with our markup. I was setting up the supplier quotes line items table but now with self linking tables is it best to just self link the line items table? Heres my desired setup for Multiple Supplier Quotes per Customer Enquiry. Customer Enquiry Customer submits one enquiry (master order table linked to line items). Each line item = required product + quantity. Supplier Quotes (Mu

Hello,I really need tour help for this trick 🙏 !I have a single-select field where there is no text, only different color to choose, displayed in interfaces as a colored-circle.Now I want to create an other field, with a formula using the “value” of this previous field.But impossible to test the otion’s rank, for instance.I cant insert any text in my option, but I really need to reuse this result… Does somebody could help me ? Thanks ! 

Hey everyone – I’ve been an Airtable user for the past year and overall my experience has been enjoyable!This could totally be my own naiveté from being new to database creation, but I’ve been quite confused over what seems to be a lack of accessible resources for Airtable user-created bases + templates for active users to share with each other.The Universe page, which appears to have been initially meant for that, seems to be almost entirely abandoned and in comparison, other popular platforms have these open-ended community sections with thousands of user-created bases and templates (the majority being free downloads). Any related questions, comments, or if you are able to clarify would be greatly appreciated… thank you! *Additional info: my project’s primary goal is a database collection of beauty brands + cosmetics products. 

Background: I have a feed that inserts data into an Airtable base using the API. Sometimes the feed inserts non-printing characters into one of the fields.Specifically, it inserts the UTF-8 Byte Order Mark (BOM), EF BB BF, in the middle of a string. The field it gets inserted into is a URL field.The BOM isn’t visible in Airtable, but when we try to use the link, we get 404 because of the %EF%BB%BF in the middle of the link.For example, the link as displayed in Airtable would be something like “https://community.airtable.com/topic/2341”, but what is actually stored is “https://community.airtable.com/topic/%EF%BB%BF2341” . Searching for %EF%BB%BF in Airtable using filters or automations gives no results.Question: How can I search for and remove the BOM from field values where it appears?

Hi, I'm getting an error message when trying to create another forms. I already have 50 forms but need more.Can't find the info.Thank you,

I’ve set up a base that tracks a specific team’s incoming trouble Tickets. The main Tickets table has a single-select field for Status, which can be ‘Submitted’, ‘Needs further details’, ‘Queued’, ‘In Progress’, or ‘Done’. I’m now working on reporting and management would like to know the full time it takes for ticket resolution, but also how long a ticket remains in each status before progressing.I can’t decide which of these approaches would be preferable: Have an automation create a new linked record in a Reporting table with a time stamp when a ticket is created, and then create an additional new linked record on the Reporting table for each subsequent Status update. Then I’d need to do a little more work to compile all of the records on the Reporting table that link to each Ticket (I’m assuming via a bunch of rollup fields). I’m hoping that stamp can also include the name of the Status that’s being recorded Have an automation create a new linked reco

All fields are operating as expected in the original base.  I have synced the table to another base and all fields operate successfully except for the date (rollup) field.  The date field is not syncing properly.  Below is how the rollup field is set-up in the original base.I have confirmed the date formatting in all bases are identical. Any ideas on why this might be happening? Thanks!  Rollup field in the original base (successful) Original Date Field  

Hi,I’m newbie so I really need help on changing or renaming the records of my table. As far as I know, you can name the records while creating a table, but whatif I already have a table, what should I do to changing the name of my records?  

I have a calendar viewI set it to show a checkbox field outsideBut it is seen as text, not as a V markAttached is an image  

Hello, setting up airtable for the first time.  We are a nonprofit looking to track our funds that support our grants.Currently we are using multiple worksheets in excel.I am trying to figure out where to start. I have imported the Fund names and Contact information(Funds).  The next tabs we have are for our investment returns and fees which contains our fund name, contributions, admin fees, investment returns, disbursement amounts and ending balance. We have a worksheet for each year.The common link is the fund name in Funds.  Should I create a table for each year and link it to the funds table by the fund name?  What would be the best way to view the Funds table and see the budget information for each year.Hoping this makes sense, any helps is appreciated.   

Good afternoon,I am using Make.com to pull information from Airtable, generate a letter/timesheet, save this to One Drive then I need to import it back to Airtable as an attachment. The Make.com syntax is fine (and has been checked by the Make.com support team), and when I run it, there is a fleeting icon of a file appearing in the attachment field on Airtable, but then it disappears and the attachment is not in Airtable. If I run this through Cloud Convert to create a PDF, it works, but there is a 10 second delay in creating then uploading the document, which then means further iterations fail. What I need is for the document to pull in as a PDF directly from One Drive to the attachment field in Airtable. Any help gratefully received. It works fine when I use Google Drive, but I’m trying to avoid this as the company would like me to keep it all on the Microsoft subscription.Thank you, Jane

Looking for a solution to display Airtable data in full RTL (Right-to-Left) layoutHi everyone,  I'm looking for a website or tool that can display Airtable data in a full RTL format — not just aligning the text to the right, but also reversing the column order, so the layout is fully suitable for RTL languages like Hebrew or Arabic.  Does anyone know of a platform or workaround that supports this kind of RTL presentation?  Thanks in advance!

Is there a supported way to update Script Extension code using an API? For example, have scripts stored in a GitHub repository, built using GitHub Actions, and then deployed to Airtable. Currently, my team have just been manually copying and pasting code they build locally onto Airtable, which leaves a pretty large hole for human error (even ignoring the tedium of such a task).I have a horrible workaround that I may use if necessary:/** * Fetches and executes the JavaScript file at the provided `path`. * This can be thought of like: * * ```js * await import(path); * ``` * * Except this bypasses CORS and directly injects the remote code. * Wildly unsafe. * * @param {string} path */async function fetchAndRun(path) { const response = await fetch(path); const text = await response.text(); eval(text);}cons

I have a base and different tables. I am working on scenario in Make.com. the logic is watch records ( rsvp table), get a record from ( rsvp table), get a record from presentation Topic, search records( Summit speaker), update Summit Speakers, zoho email, search records( affiliate interest) and then update affiliate interest. When I use id it gives me 200 but no field updated it is clear but when I map data from watch records and get a record (rsvp) to update affiliate interest I get an error 422 it says can not fine such collum. But all collums are there, cache was cleaned, reconnecting was done, tried upsert module. Nothing helps I think problem somewhere in Airtable but where? Will be glad to hear any suggestions? Thanks for help.

I am using the new form builder and want to filter the values of a dropdown field, Product, based on the value of another field, Designer, on the same form.Although I found the "filter records by a condition" option, I cannot see a way to use the Designer field's value as the condition for the filter. Any help appreciated.

I have a form that someone may fill out multiple times using the same email address. I want to use that email address to update the original record created with the new information (if it is new). Can someone guide me through the automation to do this?

Hello. I’m getting started on a database that should hold an asset registry for properties. I need some help if someone can help me navigate through this. I can start by telling you what database I need, how I want the equipment listed out and ways to automate fields. Please let me know, serious inquires only. 

I’ve set up a marketing base and part of what I’m using it for is creating UTM parameters. There are a few fields that are inputted via form, like campaign name and start date. Each of those has a secondary field in the base where the data from the first is made lowercase, special characters and spaces are removed, etc. Then those reformatted fields are all concatenated together into one field called ‘Calculated UTMs’. As is standard with UTMs, several of those different sections are separated by underscores.I’ve set up an automated email to send these generated UTMs to someone on our GA team, and I’m pulling in the ‘Calculated UTMs’ field, but it’s displaying the final UTMs incorrectly - instead of showing with the underscores, it’s removing them and using them as indicators of where to make the text italicized. The field is also shown in an interface, and the underscores are correct there. I’ve tried using asterisks and backslashes around that field name in

Hi there. I have a table "business partners" with records of type "supplier" and "brand" which are linked between each other. a record of type "supplier" can be linked to multiple records of type "brand" but a brand can only be linked to one supplier. i always want the links to be two way. i.e. if i add the record "Gmail" to the table and link it to the existing record (of the same table) called "Google", i want airtable to automatically identify that there is a missing backlink (ie. record Gmail has "Google" in its "link" field, but record "Google" does not have anything in its link field) and link the record "Google" to "Gmail" automatically. i have an automation that can trigger based on view conditions correctly. i want the automation to trigger, then "find" the linked record (i.e. Google) by ID and then copy whatever existing links are in the "link" field and add "Gmail" to that. However automations refuses to find a record in a table based on the values of a "link"