Ask the Community

I have set up a slack message to kick off a workflow that requires manual input.  The slack message has multiple buttons that once clicked check the appropriate field in the Airtable.  The problem is that once one of those buttons are clicked, all of them disappear in the slack message.   How do I make it so that once one button is clicked the "Updated in Airtable" message only shows for that button; allowing for the other buttons to be clicked?

Hi there,I'm looking for a formula to automatically calculate the Venue and Producer split of the Budget and Budget Committed as per the "Deal." However, at present, the "Deal" field is a text entry, and I wondered what the best way to achieve this is? Many thanks,Tom

Hi There, I know I should already know this but I always get nervous when dates are involved. I want to be able to highlight either a field or a row when a task in the row passes the deadline. I don't need to know any other information like how many days over it is, I just want it to be highlighted to bring attention to it. I have a [Date Due] column and a [Status] column. The idea is that the status column would be set to "On Time" or "Overdue" to allow filteringCan anyone tell me what formula I can use to trigger the change in the status column?Thank you for your time. S

I’ve been using Airtable for a while now, and while it’s a fantastic tool for organizing data and streamlining workflows, I’ve been contemplating how I can enhance my note-taking system using Airtable formulas. My idea revolves around integrating a simple online notepad feature within Airtable to streamline my workflow without overcomplicating things.Airtable’s versatility and customizability make it perfect for managing complex data sets, but I feel like an integrated online notepad could improve the way I interact with my notes directly inside Airtable. I’m thinking of using a set of formulas to create a simple, text-based interface where I can store short snippets of information, thoughts, or even checklists. This would eliminate the need to flip between different apps or browsers to jot down quick thoughts, making the entire process smoother.An online notepad typically refers to a digital tool or platform that allows users to write, edit, and save notes directly within a web browse

Hello,I'm using Airtable Automations and want to create an IF condition based on the Outlook event creator. However, this section is locked, and I see a message saying "No valid nested option."How can I unlock it?

Hi, I am a complete beginner with Airtable. I am managing a pool of freelance artist and thouhgt that Airtable could be very useful. I would like to have a form for new artist to submit their skills and skill level for each skill, which then automatically populates in my Artist' list. I know how to create a form and collect various basic information, including skills. But, I don't know how I can let artist choose a skill level for each skill they have. Lets say the artist choose "Photohop, and Premiere". I would like for them to be able to choose their proficiency for each software or skill.I could simply create 3 versions of each skill and assign Expert, Mid, and Beginner. but that doesn't sound efficient, and I thought Airtable is about efficiency.So if  you look at my screenshot, what I would think I would need, is a  non-static field (look-up) that assigns a value inside the Artists card .Is this doable?

I'm a pretty novice Airtable user, and I'm currently on the free level.I have created a contact management table. My main table is labeled Contact Log. It then has 15 other tables that I use, such as notes, email address, phone number, pending action (multiple-select field), follow-up needed (check box selection), etc.Is it possible to create a new table, perhaps called "Follow Up," that shows only the data from my Contact Log table where Follow Up Needed " is checked?I know I can filter and sort my initial table. But would ideally like a whole new table with that data.I also have a few other tables id like to create based on criteria being met. But I'm sure I can duplicate the process after seeing it how it's done the first time.Thanks

Hey there,Thank you for your time helping me !So i'm a mushroom farmer. I cultivate different batchs simultaneously. Each time I harvest one, I create a record for it, with the date of harvest, the batch harvested and the weight harvested. There is a tab dedicated to it.I also have another tab which contains more infos about each batch, and also a sum rollup of the harvests of each batch.My main metric to know if a batch is good is the yield, I compare the total weight of the batch to the amount harvested. For example, I harvested 10 times a batch, the total is 300kg of fresh mushrooms on a batch of 1000kg of mushroom substrate, hence 30% yield.But I'd like more complex infos, for instance I'd like to know on which specific date of harvest I crossed the 10% yield mark, the 20% ... So i could know for each batch after how many days I crossed the 10%/20% markI've tried some combos of rollup and formulas but nothing works so much, any ideas ? 

Hello,I'm making a custom page for users to link a game session (record) to a player's game session field.I have two record pickers. One for the Player, and one for the Game Session. For the player selected in the Player Record Picker, I want to be able to assign their Game Session field the value from the Game Session Record Picker. I have added an update button and created a set action, but it's not a dynamic field. I cannot use the value from the Game Session Record Picker.How can I achieve this?

When I click into a record from a gantt view the fields are in a certain order. I want to change the order and have been told to go to the original grid view in the table and change the order there. Only problem is that view was deleted a long time ago and I now have dozens of new grid views. changing the order in them doesn't seem to impact the grid view. Any tips or advice? Airtable support haven't been able to help.

I have a calendar view and would like to send emails to the persons in one of the record’s fields. That is, if the value in the ‘Clerk’ field is Peter, I’d like to send an email to Peter. Additionally, I’d like to send emails 2 weeks prior to the event, 1 week prior to the event and then 2 days prior to the event. Is this possible?

I'm new to Airtable formulas, so I would appreciate your input.I created a formula that I absolutely KNOW was working. But suddenly the field where the calculation was says #ERROR! now although it said 100% before. I can't figure out what has changed because I didn't change the fields used in the formula.I would appreciate your help.The field name is Sold v Booked %The formula is:IF({# of Winners Booked},IF({Number of Winners/GCs Sold},{# of Winners Booked}/{Number of Winners/GCs Sold})) The # of Winners Booked field is a Lookup field from another table. The Number of Winners/GCs Sold field is a Number field. I wasn't sure if the above formula would work because the # of Winners Booked field had 1, 1 in it as it's looking up multiple records.  So I was thrilled when the Sold v Booked % field showed "100%" which was correct since it was 2 that sold and 2 that booked..&

I would like to have a database that I could track winning lottery numbers. Should I have a column for each of the numbers? I want to be able to run a summary on the amount of times a particular number is used in a winning combination.

hello everyone, is there any way to filter the return using a GET call, I need it to return only the information of a column, which I call ID, I need my API return to show only the information corresponding to an ID, I can do that?

Hey there heavy-lifiting Airtable power users (i.e. full time consultants, developers and similar)!I recently engaged in different discussions with fellow consultants on what factors affect base performance (e.g. speed) the most, trying to come up with a robust conclusion and hopefully a list of factors ordered by magnitude of impact (not the list below which is just me putting some of the factors out there to kick-off the discussion). •Number of Records: Probably super big impact?•Number of Fields: Does having more fields significantly slow down the base? How much vs other factors?•Number of Views: How much do multiple views -even if not opened- affect performance? vs other factos?•Complex Formulas: Are complex or nested formulas a major culprit, especially if they reference many fields?•Formulas on Rollups: Do rollup formulas or those within linked records introduce additional delays?•Extensions: Do various extensions influence base responsiveness? Even if not used?•Interfa

Hi,Does anyone have an idea on how to embed a stock chart into airtable that depends on the record chosen?  I have an example of an iframe:<iframe referrerpolicy="origin" width="100%" height="470" style="background: #FFFFFF;padding: 10px; border: none; border-radius: 5px; box-shadow:0 2px 4px 0 rgba(0,0,0,.2)" src="https://jika.io/embed/area-chart?symbol=AAPL&selection=one_year&closeKey=close&boxShadow=true&graphColor=1652f0&textColor=161c2d&backgroundColor=FFFFFF&fontFamily=Nunito"></iframe>The symbol of the stock (eg symbol=AAPL ) I have in a coloum/record; so I would need the option to pass the symbol to the iframe to change the content displayed (stock item) depending on the chosen record. Then the iframe shall be embedded in the interface. Any ideas/help appreciated. Thank you!!

I've seen record templates for adding physical location addresses. Where can I find this so I can add to a from scratch table? How should the address be structured to allow bulk uploading?

Hello,as explained in the title:I have a table "User" I have a single select field named "Color" 3 value possible: Red, Blue, Green Using make.com, I want to add dynamically a 4th option "yellow" So that the new possible value for this field would be: Red, Blue, Green, or YellowI am planning on doing it via Make.com using the API module and a PATCH but i wanted to check if it was possible to do it from an airtable perspective?thanks

HiThe Find Records action has a bug.I have an automation when a new record is created, use the 'Find Records' action to find a record in another table and link them together. Very straightforward and works.However if the new record created has empty fields for the conditions of the lookup, it returns ALL the records in the other table when it shouldn't return any records since an empty field does not equal to a non empty field.In the screenshots you can see that the record selected to test automation has an empty email and phone number field.But the Find Records actions returned all the records in the lookup table.This is a bug and not the first time it has been raised as mentioned in this community post:https://community.airtable.com/t5/automations/when-source-is-blank-automation-links-all-records-from-another/td-p/176602?utm_source=chatgpt.comBut the solution in that post doesn't work in my instance as I need to use the conditional actions for another process.This seems like a simple

–– Post with many screenshots –– Hi guys, I have a problem with an automation that contains a 'Sort List' module which sorts records depending on a date.    The record values the module is unable to compare come from a {Start Date} field. This formula field outputs the value coming from one of those three fields: {CALC LinkedIn Conversation Start Date}, or {CALC Email Start Date}, or {RAW Miscellaneous Start Date}. As you can see, the values in the {Start Date} field are not formatted the same way depending on their source field – some values come from a date field, some from lookup fields. This had me hypothesize that the values coming from the two lookup fields must not have a date data type, but must be arrays.    But three things seem to contradict my hypothesis:1. the two lookup fields have date formatting in their settings2. when I applied the DATETIME_FORMAT function to those records values in a test field, I got no error3. when I sor

hi everybody,I have an airtable actionable message in slack working... it gives me 2 buttons, which then correctly update a slack record.  However, after I click a button in Slack, it always changes to then say "Processing..."   This never changes... leaving our users unsure if the action actually ran (it did).I have tried with a new table in airtable. Not sure what else to try... Has this happened to anyone else?  Any ideas on how to solve/troubleshoot?? Thank you

Hi everyone!Im using automations to send updates of records (a list of 5 at a time) to a slack channel... I have the data I want to showing up correctly, but I'm wondering if there is any way to customize the style/spacing of the output of the "List of Records" in the message block?For example, I want field names to be bolded, to have the field and data on the same line (instead of next line), and make a different separator than "-----------------------".The "List of Records" content option in the Messages block has no options to customize that I can see (screenshot)... Maybe there is another solution though?  Wanted to ask!!

I’ve become pretty proficient in Airtable over the last year and have used it for countless purposes. However, this one is stumping me a bit. Within the same table, I want to link record A to record B, and have that link show up in two separate columns indicating the relationship. Example… I’m creating a base to track cattle for a farming business. One table will have “inventory” to track all of the cattle; previously and currently held. Some cattle will produce offspring and I would like to track this in the same table by using linked records. I would like one column to indicate the parents and a separate column to indicate children/offspring. Here is a basic example: Obviously, the table would track much more information than this, but the link is where I’m having trouble. By adding “parent” to one column, I want the linked record to show a cross-link under the offspring to show the relationship. I’ve been able to do this by creating a 2nd table that links “family ties” and

Hello,I am a beginner and would like to use Airtable both as a database (clients, prospects, accounting) and as a CRM to schedule calls, SMS, and emails, similar to HubSpot, Zendesk, or PipeDrive. If Airtable allowed these actions directly from the database, it would closely resemble a CRM, but I’m not sure if this is natively possible.Since its interface already looks like a CRM, why doesn’t Airtable include built-in features for call reminders, SMS, or automated/one-click emails? If this isn’t available, is there a specific reason?From my research, it seems possible to achieve this using integrations with Make and external APIs, but a native solution would be much simpler.Here are the solutions I’m considering:Airtable / Make / Twilio or Messagebird: call reminders and SMS sending.Airtable / Make / Gmail / ChatGPT: automated email generation and sending (with manual validation) + email archiving.Airtable / Make / MailChimp or Klaviyo: email marketing campaigns.Looking forward to your

I have been playing around with @Justin_Barrett’s excellent script “Parent Child tree hierarchy” (Parent Child tree hierarchy). The output of this is a text field with any separator you like, for example: World > UK > London > Hammersmith > Elspeth Avenue > Joe’s Cafe World > France > Paris > La Defence > BNP Paribas World > USA > New York > Manhattan > Central Park Question - is there any way to extract the #3 item (or the #2 or #4 for that matter) from these text strings? In this case, to pick out “London”, “Paris” or “New York”. I assume this should involve counting 2 instances of the separator (“>”), and then selecting the text from there up to the next separator.