Other Questions

Two similar linked records link the BOOKINGS/LICENCES and the COSTS tables with the REPORTS table. I create a new record on the junction REPORT table (primary field = ReportID), and I manually choose to bring which licenses from the BOOKINGS/LICENCES table and which costs from the COSTS table will be included in this particular report from linked record on each tables.  Then I created a linked record both on the BOOKINGS/LICENCES table and on the COSTS tables that automatically pulls into those tables the reportID number (primary field) and an associated lookup field, so I can know directly from the BOOKINGS/LICENCES table, in which report a particular license is included. Same from the COSTS table.  I replicated the same logic and created the same relations through linked records on both tables. It works perfectly on the COSTS table. For a reason I cannot understand and after several attempts it simply does not work on the BOOKINGS/TABLE . Neither the information about the record numb

I have it connected to a table with the months in it and they are supposed to click which month they want.  Now, it’s doing this? 

As the title states, I need to know how to make comments made on an image viewable in a shared view. I don’t need the ability for people to comment, I just need the comments that I made visible to them! Seems silly that I can share all the other information on an airtable, but I can’t easily share comments that break down what an image shows to more clearly convey the information being shared...

Hello guys, this error always comes up when I'm trying to add data using a pop up form on an interface level: Worker responded with {errorCode} for {path}, {action}, {modelClassName} (Please see the First Image)Also when I'm trying to add data manually on the backend, an error message also pops up (please see second image). Both of this are occurring on the same table. I'm the author/owner of the base.What do I do? Thanks in advance!

I've looked at a few posts that deal with updating an existing record based on a form submission, but haven't found anything that addresses my particular need.I have a base to keep track of volunteers. It includes general contact info, which groups they are a part of, how they came to the organization, etc. I want to also use this base to keep track of which events they RSVP to. They RSVP to events via airtable form. I want to be able to update their existing record to add the event to the "Events" column (multi-select field).I've found ways to do this that involve the person filling out the form looking up their record (e.g., https://community.airtable.com/t5/show-tell/updating-an-existing-record-via-airtable-form/td-p/132681). But my volunteer list needs to remain private—I can't have it so that anyone filling out the form can see the names of other volunteers. Instead, I want to have users fill out their email address each time they RSVP, and then use that as a unique ID to loo

2 interface questions: Is there a way to discard unpublished changes? I was trying to add something to a current interface, but it isn’t laying out how I want it to… so I want to revert back to how it was. But it won’t even format itself back to how I originally had it… So I’d like to discard these changes and put it back how it was automatically. This leads me to my next question. Can the elements on the interface only go into these pre-determined ‘boxes’ that are popping up. Sometimes it won’t allow me to resize things the way I want them because it doesn’t seem to ‘fit the mold’. Does anyone else have this problem? I hope those make sense!

I have a bunch of columns/fields that use the same list of single-select values. I have changed the colors of the selectable values in one of the columns and I want to apply the same change (colors) to all the other columns with the same range of values. How can I do this short of manually edit the colors on all the other columns?

Problem:When adding a linked record in Airtable, the search is currently limited to the Primary Field of the linked table. In many cases, however, the Primary Field is a technical ID or a customer number, which is neither intuitive nor easy to remember for users.Example:We have a customer table with fields like Customer Number, Company Name, and Address. When linking a customer to a product table, we can only search by the Customer Number (Primary Field). This is inconvenient because we would often prefer to search or filter by Company Name or Address to quickly find the correct customer.Current Workarounds: It’s possible to create a formula field that combines multiple fields (e.g., Customer Number + Company Name). However, this combined field would need to become the Primary Field, which is often not allowed or desirable, as the Primary Field must not be changed (e.g., in synced tables or when data is externally managed). Another potential idea would be to use Lookup Fields, whic

I have a field in TableA called “ProductSKU” which is a primary field that concatenates some data from other fields in TableA. The formual is: LEFT(Description,10) &"-" &FinishCode &"-" &Model I have a field in TableB called “SelectKit” that is a link to “ProductSKU”. I have a third field in TableB that concatenates data from the “SelecKit” field. The formula is: LEFT({SelectKit},5) Now, that we’ve established that. I have found that SelectKit is arbitrarily entering a single quotation mark as in " just before the text that is being pulled from “SelectKit”. This only happens in one case. I’ve checked all the fields from every other table and there is NO quotation mark entered in a field. I’ve checked the formulas and they all appear correct anbd otherwise working, except for one entry. Why is this question mark being entered??

I like to know what others are doing to have better organization of managing their users against workspaces, bases, and interfaces, specifically within their organization. I have built a number of apps amongst different departments. We have not decided to turn on enterprise hub yet for our enterprise account but we do have SSO. However, I think using groups would be useful as a growing community of users is developing. I’m a little clunky with using groups and will need to a lot of clean up. Structurally this is how I’m laying it out:Workspace per department Product owners of the Base have creator access only at the Base NOT at the Workspace level (Reasons - within the department could have multiple products not meant for other team members thus at the Workspace level gives too much control) Groups - Product owners are Group ManagersMy logic in what I’m thinking to do:At the Base level manage access for creators only Instead of inviting people directly to the base or interface per a pe

Hello! I realize this might sound confusing! Select item in one field, have it filter the second field based on that selection so I can choose from a filtered selection, and then auto-populate the third field based on the second selection I make. Here is a quick Loom so you can see what I mean! Loom Loom | Send a video. Not a thousand words. Get your message across with instantly shareable videos for work. Capture your screen, record your front-facing camera, and narrate it all at once, then instantly share with a simple link. I have a column with OEM Make, those OEM Makes have specific packages but those packages all include different things, but some OEMs have the same package names even though they include different things. I want them to be able to choose the OEM from the OEM field, then the package field with the packages they can choose from only has the packages that match that OEM. Then the 3rd field is auto-populated with

I’ve made a print view using the blocks. I’ve set the page direction to Landscape. But every time I’m printing i manually have to switch to Landscape in the print prompt - is there away around this? Secondly my printer constantly prints an empty page. Tried to move content away from the edges and play around with the margins but no matter what, my printer prints my view followed by a blank page. Does anyone have any idea how to get rid of the empty page?

After reading this topic about tracking an airtable iFrame, I looked deeper into if its possible to track interactions within an iframe through scripting. I read a few articles, but this one explained most clearly that it’s not possible: Note: To reiterate, you need developer access to the iframe in question . This means the source website’s code, not the iframe HTML on your website. 80% of the cases I see where people are struggling with tracking iframes are simply not possible. Without access to the iframe in question, you cannot install any tracking code. Since I don’t have access to the source for the embedded form, I can’t do tracking. My organization is relying heavily on airtable, especially for volunteer signup forms. We’d like to know how our forms are doing in terms of converting potential volunteers, but right now we’re blind because Airtable doesn’t integrate with Google Analytics. Another tool we use, Donorbox, also relies on embedded iframes, but has an option to input

Hello everyone!Thank you for taking the time to read my post.I’m new to Airtable, and absolutely loving it so far!I’ve already built a database, created forms, and now I’m exploring interfaces. My goal is to give different establishments we work with access to some of their own data, so they can add, update, or delete it as needed. I’m currently trying to achieve this within Airtable itself, without using third-party tools.I noticed that when sharing an interface, there’s an option to restrict access based on specific email domains, which is great, since most of the businesses we work with have unique email domains.I tested this using a random email I created for the test, and a few unexpected things happened: I received $10 (which I wasn’t expecting). I got an email saying I would be charged (also not something I intended). When I logged in using the test email, it didn’t allow access to the shared interface. Instead, I saw a pop-up saying I don’t  need to request access, it was a

Hi Dear community  I'm facing a small challenge with my apps on the mobile phone In my laptop I can add ingredients to create a recipe but unfortunately doesn't work on my phone.Is there any modifications has been done recently or I have to change my settings  Thanks ☺️ 

Hello,Did Airtable change how they duplicate bases recently? It seems that when duplicating a base, it uses the same table ID and View ID from the original base. This broke my API that updates/inserts table metadata to my database by table ID as well the API that fetches table metadata by table ID. Disclaimer: The bases here are all just test bases so there is no real information stored in there.Before, when duplicating base, the table ID was also changed as seen in the screenshot below. These bases was duplicated around May last year.This is the original base This is the duplicated base (please note that the base ID, table ID, and view IDs are different from the original)Now, when I duplicate a base, it changes the app ID but doesn't change the table ID and view ID anymore as evidenced in the screenshot below. These bases have been duplicated at the same date of this post's writing.Original baseDuplicated base (only the app ID was changed)I'm well aware that the solution wou

I put in a ticket but haven’t gotten a response, was just wondering if anyone knows why I might have lost access from n8n, i’ve tested both oauth and personal access tokens, ensured the permissions are all granted, tried new n8n airtable nodes, tested old and new credentials, and added money to my airtable subscription since it started while I was on the free plan. Every airtable connection regardless of which type of authorization yields:403, { "error": { "type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND", "message": "Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct." } } Node version2.1 (Latest)n8n version1.95.3 (Cloud)Anyone have a theory I might test to get access again? 

Busco una comunidad de usuarios en idioma español. Alguna información al respecto, estaré muy agradecido. Saludos.

Hi everyone!Two of my collaborators are using Airtable on their tablets, and when they try to open certain pages (like interfaces or synced views), they get the message:“This page is not supported on mobile.”Or“Incorrect Permissions” The strange part is: I can open the same exact pages on my phone (mobile browser and Airtable app) without issues. Their permissions haven’t changed, and they’ve had access before. We tried checking their login, app version, and even attempted opening in a browser instead of the app, but the problem persists.Has anyone experienced this before? Could this be device-specific, or related to screen size/resolution? Any ideas or workarounds would be appreciated!Thanks in advance 🙏

I feel like this might be a Fillout issue but thought I would check here to see if anyone can identify if I'm doing something wrong.  I have a base connected to a form in Fillout.  When I pull up the form and click “integrate” at the top, it shows a connection to the correct table. When I click back on...Edit at the top, Go to the page that contains a field linking to a subform Click the field the subform is attached to,   Open settings on the right Click Edit Record creation form to pull up the form,...it says connected at the top, but when I click the integrate tab on the sub form and look at my connections, I continue to get the following message.  I've updated my API Key in Fillout, updated my PAT Token in Airtable, cleared my cache, confirmed my mapping is correct, I don't have any automations that might cause the problem,  and tried a different browser.   I was connected to a different base and it was working properly.  Short of recreating the entire form, I'm stuck.  any suggest

Is there any way to remove the "Download CSV" option from member databases?I wanted to keep the data only in the cloud and not have the option to extract the data this way.

Hello, I'm stuck and need your help.I created a 6-page contract using the Airtable Page Designer extension.The problem is twofold: I succeeded in the first step but not the second.Basically, the Page Designer extension only allows you to edit a single page. I found a way to extend the page height by multiplying it by 6. Except that Airtable doesn't allow you to insert page breaks, and I'm exporting a very long PDF file that I can't split. And no matter how hard I search, I haven't found an acceptable solution for printing this contract correctly.Do you have any solutions or advice?Thanks!

AirTable is not allowing me to upload my CSV file. I click on the + sign, select “CSV file” under “Add from other sources”. I drag in my CSV file under the “Local Files” section and click “Upload 1 file”. It seems to work, I select “Create a new table” under the “Import your file” dropdown. It shows me a beautifully created base with all the column's I’d like.  However when I click “Import” I get an error sign saying “Can’t import CSV file” with the statement “Invalid data” underneath. Does anyone know what might be going on / how I can fix this. The only option airtable gives me is to click a button saying “Okay” and I’m back to the start. 

Is there a way to export the structure of a table to csv, JSON, etc.? Specifically, I’m looking for a way to export information about a table, not the data itself. Some method that will give me an output like field 2 is long text, field 3 is lookup, field 4 is date, field 5 is single select, etc.

Anybody has tips on how to do that? I have a long text field (cca. 1000-2000 characters including spaces). Beside that another field showing keywords, usually not more than 10-15 keywords. These keywords are typed in through Google API and edited by me manually. These can be keywords (or better say key phrases) are separated by comma. These are the words (phrases) I want to make sure I have them in my long text field in sufficient number of times. I am looking for a way to calculate the keyword density, that is how often do the keywords (the words in the keyword field) appear in the long text field. I do not need to see individual count, sufficient is to have summary count - number of times any keyword appears in the long text. The density count will give me a percentage = number of total keywords(phrases) / total words in the long text I looked at this suggestion here but it seems to me Airtable database would explode if I start generating a tag (which seems to me is essentially a