Ask the Community

Hello, I have a base tab with all of my company’s stakeholders and builded an interface for people to create a new contact. What is the best way to prevent people from creating a new contact through the interface and the associated form if this email already is in base ? Thanks a lot for your help

I’m having an issue with two-way syncs in Airtable.I have a Source-A table in a Base 1, which is synced to Base 2. In Base 2, the Target-A table is linked to a B table.The problem arises when I want to remove duplicates in Source-A: I have no way of seeing whether one of the duplicates is linked to a record in B in Base 2. If I merge duplicates and delete the one that is linked to a record in B, the connection between Target-A and B is lost.How can I prevent this loss of links?I tried using the Dedupe extension on the Target-A table, but I got an error saying I don’t have the necessary permissions.I understand that if Source-A is synced to multiple bases, removing duplicates can be problematic because additional data entered in Target tables isn’t reflected in Source-A.Is there a better way to handle this situation? 

Hello everyone,I'm looking to optimize my prospect tracking in Airtable and need your help to solve an interface issue.My current structureA Prospects table containing all my prospect information, including a "Commentaire de Suivi" (Follow-up Comments) field that rolls up notes taken during previous interactions. An Interactions table linked to prospects via a "Prospect" field (linked record).My needWhen I create a new interaction via Interface Designer, I want to be able to see the summary of previous interactions (the "Commentaire de Suivi" field from the Prospects table) while I'm entering my new interaction (so as to have the previous follow-up notes of my prospect meanwhile I take the notes of the current call for ex.).The problemI can't configure my interface to display both:Input fields for my new interaction (Interactions table) History of previous interactions (rollup field from the Prospects table)I'm using the free version of Airtable and the Interface Designer. I either end

Hey all, this is my first post, so I hope I do this right! I have created an automation that, when a field box is ticked, a series of Find Records run. Each Find Record action gathers a list of records (people) that meet certain conditions. This is followed by an Update Record, that adds the linked records to a single field. The Update Record step looks like this: Find Record 1 record ID, Find Record 2 record ID, Find Record 3 record ID. This works perfectly unless one of the Find Records comes back empty, in which case the whole automation fails. Two the Find Records often come back empty, so this is a problem. I’ve played around with conditional actions, which is messy but it kind of works until a conditional action has an empty Find Record, where the automation stops and doesn’t move down to the next condition(s). Can anyone think of a workaround? Thanks in advance!

I’m not even sure the correct terminology so having difficulty looking it up.  I am creating a form with timeslots.  I need people to fill out the form and select a timeslot, but once someone has selected one, that timeslot shouldn’t be able to be selected by someone else.  Is this even possible?

(I suspect this has been answered before, but I’m having a hard time figuring out how to search for it. Apologies in advance.)I have a table that includes several hundred rental product models. This table is called ‘Fixtures’.I have a table for individual projects called ‘Projects’.For each given Project, I will want to link a Client (I know how to do that) and then I want to create a document where I can list an allocation of equipment needs for the project that pulls in data from Fixtures.The final output needs to be a multi-page printable document that looks something like this…--ProjectClient(Qty) (Fixture B) (Qty) (Fixture Q)(Qty) (Fixture AN)… --So this is roughly equivalent to creating a sales estimate, but ideally pulls in data from the Fixtures table to then populate additional related info.If anyone could point me to a relevant sample base or offer any insight, I would appreciate it.

I see several posts that are similar to my question, but I haven't been able to find the actual solution yet.  I have a database of all our locations, and at any given time we have about 40 pending locations. I'd like to send an automated email to the listed manager each month asking for an update until the status is changed from pending to open.  Some managers have multiple pending locations at one time so I'd like to only send one email per manager rather than multiple if there are several pending in their area. There's probably a few ways to do this, but for now I have a rollup column on a different table that breaks down by district all the pending locations.Any thoughts?

How do you accomplish that Airtable shows as the example?  I want a picture on one side, then next it it several vertical fields, but they only go horizontally or below the picture.  

Current Issue:By default, Airtable automations trigger every time a defined condition is met, such as when a field is updated. However, in cases where changes happen in quick succession, the automation may run multiple times unnecessarily. This leads to inefficiencies and potential inconsistencies in workflow execution. Objective:I want to configure an Airtable automation that runs only after a certain period of time has passed since the last change, rather than triggering immediately with every update. This delay would allow for multiple consecutive changes to "settle" before the automation executes, preventing unnecessary or redundant triggers. 

I have a date field that I am wanting to use to send a slack notification when it is updated and/or changed, however while doing planning I am amending that date field multiple times to settle on the final agreed date - is there a way in which that slack notification can only be triggered once the date is settled and planning has been completed? 

Hello  I would like your help regarding the  privileges of the following  api key  : curl -s  -H "Authorization: Bearer p****" "https://api.airtable.com/v0/meta/bases"{"bases":[{"id":"app***”,"name":"Produ***","permissionLevel":"create"}]} My question what exactly permissionLevel":"create"  means ?  and is the difference with read-only ? Is there any security concert if for the above key if it is public ?  Thanks in advanceG. 

I have 100 people in my database, I want to send an email to each (email is in record) and in the email have a  button (webhook or form) that updates another field in their record. Example: Do you support the project? Button or form could either just have "Yes" (with no click being implied "No") or a form 

Hi 😊I need help with the form…🙄I have a table "Absences" created in Airtable, where employees can report paid vacation using the form. I also have a column "Remaining paid vacation days" created in Airtable using a formula, in which the employer can see what the balance of the employee's paid vacation is.I would like to add a field to the form that will be displayed while filling out the form (If the employee selects their name from the employees in the form and selects Vacation type-Paid vacation, a pre-filled field showing the data from the table: How many days of paid vacation the employee has left will appear).Thank you for your help! 😁

Hello all,I have multiple tables each with multiple single-select fields that I have created via the Airtable API.352 separate fields across 40-something tables. When creating the tables and columns I am able to define the selection options for each column and everything works smoothy.However I can not set a default option for these columns when creating them through the API. It is far too many columns for it to be reasonable to manually set each column default in the UI, as it is I already have to do some manual operations to create a formula field in each of these tables after creation due to limitations in the API capabilities.Does anybody know of a way to set default values in my field en mass?The majority of the fields hold the same selection options and would have the same default option set.I would even accept nuking the fields and/or tables and recreating them if my creation call can be altered to set the default but I was not able to accomplish this. I appreciate any assistanc

Hey all,I’m getting the dreaded “received invalid inputs” but it’s not specific.I have a form that someone fills out to get a “certificate” number in another table.There’s a specific view for the Non-Assigned certificates. There are two tables, one that stores the form’s data, and another that has a listing of certificate numbers and such. Now I’d set it up as such: Then the Find Records settings:  Not sure what else to do???   

Hi there, I’d like to create an automation that, when triggered manually, appends all records that match certain conditions to a Google Sheet (that I then apply built-in formulas to in the sheet). My first attempt was to choose the trigger “When record matches conditions” but that only seems to fire for when a new or updated record matches conditions, not for when an existing one does. How might I set up the conditions and action and then for a trigger be able to just click a button like “run” or turn it on? Is there another way to do this?

Hi, I am fairly new to Airtable, so I am trying to learn how to do things more efficiently. I have a question about formulas.Is there a way to select a field based on an input without using the SWITCH() function? I’m thinking something like a FIELD_SELECTOR() (← this a made up function as far as I know, but maybe something like it exists?), where I input the text display_name of a field, and output the value for that field. Or is this something where I need to start learning how to integrate python, and airtable built-in functions are not powerful enough?Example:I am making a database with taxonomic information (ie. latin names of living things). I have all the taxonomic ranks from Phylum to Species as separate fields. I have a field called taxonomic_rank that indicates the lowest taxonomic rank in the row. I want to make a function to create a display name that outputs “taxonomy_name taxonomic_rank”. So functionally, A row that says Arthropoda in Phylum and nothing in the lower ranks

Is there a way to add default values to forms where when clicking into the field, the default values disappear?As in, I would like to input an example of the information I’m looking for, and then when the user clicks into the field, they type as if there was nothing there.

Hello!I created a Project Template base that has various phases and steps with our design process. This base will be duplicated and renamed as new projects come in.I also created a separate Project Dashboard base, to be used to get a birds eye view of all the active projects going on at once.In the Project Template base there’s a table with a name, assignee, and project status fields. This grid view is synced to the Project Dashboard.Once I duplicate the project template base and rename it to the new project, is there a way to pull in the new name of the base into the name field?I didn’t see anywhere in the functions to pull in the base name. I was able to generate the base name using the script extension +  output.text(`${base.name}`);, but I don’t see a way of bringing that information into the name field.Thank you for your help!

Hi Airtable Community,I'm building an Airtable-like application using React.js, Redux, Node.js, and MySQL. In my app, all records (raw data) are sent to the frontend, and I need to handle filtering, sorting, and grouping entirely on the client-side, without making API calls.I want to ensure efficient data handling and real-time UI updates while maintaining good performance, especially for large datasets.Some Considerations:How does Airtable handle large datasets on the frontend efficiently? Should I use IndexedDB, Web Workers, or in-memory filtering for better performance? How can I implement real-time UI updates when filtering/sorting large data in React.js? Are there any caching mechanisms (e.g., Apollo Client, Local Storage) that help optimize filtering/sorting? Any experience with virtualization (e.g., React Virtualized) for large lists to improve rendering speed? Would Redux be a good option for managing local state filtering and sorting?If you have any references, articles, or do

What permission levels (Owner, Creator, Editor, Commenter, Read only) to an Airtable workspace can someone without an Airtable account have?

Hi Airtable Friends,I need help. Since I couldn’t squeeze all the Product fields I needed to see at-a-glance into the Record View template, I laid them out onto a Blank Canvas. But when I add the List element, it doesn’t display a list of products as would have been the case with the Record View template. Instead, it only allows me to choose from one of the Link to Record fields. If I change the source to “Products”, I see the list of products—but it’s not at all connected to the record view fields. Really hoping some of you  geniuses out there have ideas! Thanks in advance!  

Hi, I want to be able to copy the result in one field into another single-line text file so that I can look it up. The first field is multi-select. All I want to do is convert it into a single-line text field. I need this to look up the text from another table. I need to do this because the first field is already a lookup in this table from yet another, and I need to be able to link some of the details from a third table altogether. I hope this is making sense. I don’t know how else to explain it. Thanks S

Checking on if there is an update on this, as most posts about it are many years old. Can the airtable branding be removed from an embedded calendar?It seems none of the alternatives that I’m aware of can customize the visible days the way airtable can. Softr can do a week view (7 days with the weekend, or 5 days no weekend. Miniextensions can only do the whole month. Neither softr nor miniextensions can do the colorcoding.  Is there a workaround for this yet?