Ask the Community

I'm trying to create a solution for managing events and event attendance.I have 3 tables: Contacts, Events, Attendance.In the Contacts table, an Event is manually linked via a linked field (the Contact can have multiple Events in here, sometimes added in quick succession). Once this link is set, I have an automation that runs to create a record in the Attendance table (fields: Contact link, Event link). This table must have one record per Contact per Event. The Contact link is set in the automation for this new record but how do I update the Event link (considering the Contact can have multiple). The part I'm struggling with is how can I link the Attendance table to the correct Event.Any advice is much appreciated.Thanks.

Hello Airtable community!I inherited a pretty robust Airtable system from a predecessor and have been working to revamp it, but my formula skills are not as good as the person who came before me, and I've been struggling to get IF AND statements to work. The logic seems sound, but they keep returning empty cells.One of the ones I'm struggling with concerns a formula that should return 1 of 2 options if a cell has a specific entry. I can get a single IF statement to return the correct result, but as soon as I try to include an AND, it fails. Here's what I have so far:In my table, the formula field is 'Ship From' with the two options being 'Direct from Printer' or 'X Distributor'. I want the formula to return 'Direct from Printer' if another field - 'Role' - is one of 3 options: Marketing/Sales, Licensor, or Editor in Chief. All other Roles should return 'X Distributor.'So I put in: IF(AND

Hello everyone,I need a little help about how to preview an email before send it. I explain myself, I need people who uses my interface to be able to preview their email  before send it.What I have now is when an entry is create by an automation  I have a script who send it (Outlook) but don't allow to preview the mail.I came up with an idea is to create a formula with "mailto" who allows to have an interaction with outlook with that I create a bouton and when people click on the bouton is create a preview of their mail directly on outlook with the information they put in a formulaire when the creation of an entry.But I have two problems : - "Mailto to" not allow html so I create a macro in Outlook to put my text into html format- Limitation of numbers of characters by 2000 so i can only use Firefox for browserSo I don't have any idea to find something more optimized because I have an html format kinda

Hello everyone, I have the following problem: I have an Airtable automation that informs the assignee of a project when some fields change. Now we often have the case that there is no assignee yet but someone edits one of these fields. Then the automation fails and I receive a notification by email every time that the automation has failed. Can I change this somehow?Unfortunately, triggers cannot be cobined, for example: If field A changes and assignee is not empty. best regardsMirko

hi everyone!I am using automations to send a message on slack when certain conditions are met. In the body of the message, I want to show the conditions that were used to create the listed results... but cannot figure this out.I have a "Find Records" block setup, with the condition to find 5 records that match a certain multiselect field (in my screenshot, "O Positive").  This works fine.When I go to configure the message block,  I can add different dynamic data by clicking the +, however, there is no way to select the condition. I want it to say "O Positive" in my message body (chosen dynamically from the Find Records block), but I only see the option to list the results here, which puts this in my message 5x, since it's showing this field for each of my 5 records. Instead, I want to simply show the condition I selected in the Find Records block 1x... so the message lets us know the conditions that created the resulting message.

I have set up a view and I’d like to be updated whenever there is an update to that view in Airtable. That means, when someone does @me in a record, I’d like to be notified in slack. Unfortunately, the slack integration does not seem to trigger any notification when there is a comment added to a record. What gives?

I have created a marketplace using Softr and Airtable.I am trying to figure out two issues:1. I have lots of records and want to create a field for signup, with the URL pointing to the sign-up in in Softr. Is there a way to input the URL into one row of a record and then copy that into every sign-up record?2. Going forward whenever I create a record, I would like that the sign-up field will be automatically populated with the URL. How do I do that?Ideally, I would like to have the Signup in the Softr record (card) directly point to the appropriate URL but it seems it will allow me to map only through Airtable. 😞Thanks a lot in advance.

Hi there! I am trying to remove NaN values from a formula field where both positive and negative values exist. This is in an effort to clean up two extensions: One chart indicating the number of each value's occurrence and one number where I am trying to get the average of the values, but with NaNs included I receive an infinity. Here is my current formula:DATETIME_DIFF({Due Date},{Date Completed},'days')+IF({Date Completed},{Due Date} = "NaN", BLANK())Thank you in advance!

Do I need to use the portals add-on if I just want clients to see their interface as read-only (but with password access)?

Hi,I'm trying to create a table to track income and the records feed from different tables using automations which are assigned a deal type as they're created. If they're type A the commission is 15% of the payment amount, if they're type B the commission is 10% of the payment amount and if they're type C then the commission field needs to return 0. I don't know if it makes a difference, but the payment amount field is a formula. I've tried SWITCH({Type of deal},"A", {Payment amount} * 0.15,"B", {Payment amount} * 0.10,"C", 0) But I just keep getting ERROR in the results. 

Greetings! Wondering if any of you have come across something similar.How do I make two filter components in an Airtable interface work together? I have a simple list view with two filters at the top, but I want to improve how clients select options. I tried linking the filters, but they don’t cascade. The only workaround I can think of is defining the relationships in another table and using linked records. Any other suggestions?

Good day.The idea is this.  Someone fills out a form, to request a certificate/license and by the end, they are automatically assigned a certificate #.I have two tables, one "Recipient" where the form exists, and another table that will have uploaded certificate numbers provided by someone else.I have the two tables linked so that when that record is generated by the form, it will automatically pull from the second table, the certificate table, a certificate number.  As each form is received, a certificate number is applied, not generated, as they are 'hard' coded in the second table :). Does that make sense?

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

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 idea

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 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.