Ask the Community

I was trying to set up an automation that after 5 minutes of a scheduled date and time in a record email the person of the record but I can't find that option in the automation list.

Hi All! For the Gantt Chart view, does anyone know if there's a way to have airtable automatically adjust all dependent task start dates when the predecessor task is moved up (backward in time)?  I see that airtable automatically pushes out all dependent tasks automatically if a predecessor task is delayed (this is great!) but if a task duration is shortened or end date is moved back, all of the dependent tasks stay exactly where they are. Is there a setting or bit of automation I can add to enable automatic date adjustments in both directions?  This seems like a very basic feature for Gantt charts and doesn't quite make sense to have it only for updates in one direction but not the other! Jack

Hi,I want to have in one column the data from the remaining selected text, lookup and line items, fields which will be formatted in html. I managed to partially achieve the desired effect, by using the formula type But unfortunately data is not presented correctly. This is my formula. <li-code lang="markup"> "<table><thead><tr><td>Składnik</td><td>Zalecana dzienna porcja do spożycia: " & zdd_pl &"</td><td>*%ZDS</td></tr></thead><tbody>" & "</tbody><tfoot><tr><td colspan="&"3"&">*%ZDS - Zalecane dzienne spożycie. | † - Nie ustalono zalecanego dziennego spożycia.</td></tr></tfoot></table><h3>Składniki:</h3><p> " & wszystkie_skladniki_pl &"</p><h3>Alergeny:</h3><p><b><u>" & alergeny_pl & "</u></b></p><h3>Stosowanie:</h

I have 2 tables (Table 1 and Table 2) in a base (Base B). I have created 2 automations, the second one is not working.The records are created in Base A - Table 0 and synced to Base B - Table 1, so Table 1 is a synced table. The first automation works: When a record enters Table 1 (view X), a record is created in Table 2. The second automation doesn't work: when a record is updated in Table 1 (view X, all fields), update the record in Table 2The error is: The record does not exist. I wonder whether the problem is the fact that its a synced record. The record IDs in Tables 1 and 2 are exactly the same, but Table 0 shows a different one.Would anyone know how to fixt it? Thank you in advance. 

I have a formula field containing NOW() and nothing else. The field is showing the wrong time. Right now it's 3:02 a.m. in the desired time zone (Eastern Daylight Time), but the field shows 2:59 a.m. I've attached a screenshot showing the difference between the displayed time and my computer clock.Weirdly, when I first set it up but hadn't yet changed the time zone from GMT, it was 2:59 a.m. but the field showed 6:03 a.m.Is this a known bug? I need this field to calculate the difference between when an item is due and the current time (that is, how many days/hours until it's due), and the time does need to be accurate to the minute.

I highly suggest adding Multi-Trigger capabilities to Automations. This would enable users to require multiple Trigger rules to take place in order for an action to run. To optimize this functionality, users should have the option to run their automations in three ways: Only if ALL trigger rules are true If ANY trigger rules are true If custom formula is true (i.e.: IF TriggerA and Trigger B are true, OR IF Trigger A is true and Trigger B is false…)

We are currently using Airtable with WATI. We aim to streamline data collection, particularly about crop information and pricing. However, we are facing a specific challenge that we hope the community can help us address.We are creating an Airtable form where our team members can input data such as the type of crop and its corresponding price.Scenario: Imagine filling out the form, and they want to add information for more crops than the initial form offers fields for. Instead of having to predefine a specific number of fields for crops, we want users to be able to click a button or use a similar feature to dynamically add fields as they need them.Questions:Is it possible to dynamically add fields while filling out an Airtable form, or through a user-friendly feature like a button?If not, do you have any recommendations or workarounds for achieving this kind of dynamic field creation within Airta

I'm trying to score based on a percentage another field is calculating.If Profitability is greater than 0%, score 2.If Profitability is between -5% and 0%, score 1.If Profitability is less than -5%, score 0.I can get it to work for greater than 0% and for less than -5% but it won't score the percentages less than -5%. I've tried at least 4 variations on this and can't get it right. Does anyone know what I'm doing wrong?

I am using softr as my front end for airtable. I have about 200 users on softr, and I want each user to be able to see their overall "performance" metrics for themselves only on softr. I don't like the data visualization tools on softr as much as airtable. Is there a way to specialize the airtable embed interfaces so it filters the data to only be the email of the person logged in on softr?

Revenue = Quantity * Price7496.90 = 150 * 49.98Why is the number rounding up to 7497.00????Another Example: $205.80 = 25 * $8.23The value I get in my Revenue Cell is rounded down to $205.75.Here is the revenue formula vs. what it should be. The numbers are rounding weirdly.  

We are a publishing company and we publish individual pieces of content on multiple dates.  I have a different sheet that I'd like to have all of those dates be put together into 1 cell (see attached). Is there a way to do that so that if I fill in a date in the "Publish Date 1", "Publish Date 2", etc. cells, that it will automatically add them into the column on the far right that is referencing another sheet?  I did it manually in the attached screenshot just to show what I would like to happen. Thanks in advance!

Hi there, I am trying to use an automation with the following setup : Trigger : When a record is created (in Table 1) Action 1 : Find record (in Table 2), where Name = Field 1 from Trigger Action 2 : Update record (in Table 1), with Record ID = Airtable Record ID from Trigger In this action 2, I am trying to update several fields using field values from Action 1. However, I noticed that the automation is only working when ALL fields from Action 1 used in Action 2 are not empty. If at least one of these fields is empty, the automation will fail with the following error message : Failed to construct the value for “Fields”. I suspect that the Find Record action only bring fields with non empty data and ignore the others. Is it the expected behaviour ? Any workaround that doesn’t involve creating a formula field for each field that I am trying to get the value from in Ac

i have gotten the same error message several times in a row: Microsoft reported an error while processing this action:Microsoft may be experiencing issues with their API Any ideas on how to resolve this?

It is impossible to communicate with the support team because requests can not be sent. Even though your API does not work, and I do not have any channel to communicate with   

I’m using your API to upload attachments.While simple requests work fine, when I try to send real files, the API responds with a 404 error. This makes it difficult to debug the issue.

Hey everyone,I aim to enhance my CRM by achieving the following:Establish a connection between my Gmail account and an Airtable for contacts. I'd like every new contact's email to automatically create a record in Airtable or Google Sheet/Excel, facilitating manual loading into my Airtable.Currently, I have two tables - one for personal contacts and one for companies. While the tables are linked, an issue arises when multiple contacts from the same company result in the company appearing multiple times in the Company Table. How can I modify this so that the company name acts as a banner, allowing me to click and view all associated contacts?Thanks, everyone.

Hola a todos! Estoy buscando contactarme con gente que tenga buenos conocimientos de airtable. Estoy trabajando en una base y mis skills no son suficientes. seria genial poder juntarme interactuar con gente de Córdoba para sacar el proyecto adelante. gracias 

como hago para que se sume si un registro aparece en otra tabla???

I am trying to emulate MS Excel’s “^” function in Airtable. I have tried the POWER function and it doesn’t seem to work. Optimally, I am calculating Customer Lifetime Value. Any clues about how to effectively do this?

Hi I have two fields ie a created time field and a formula field for the time field. I have an issue with time displayed in the formula field. It seems to convert the time I don't know why,, here is the formula: IF( {Posting Date} > NOW(), "Posted: Timestamp is in the future", "Posted " & IF( DATETIME_DIFF(NOW(), {Posting Date}, 'seconds') < 60, DATETIME_DIFF(NOW(), {Posting Date}, 'seconds') & " seconds ago", IF( DATETIME_DIFF(NOW(), {Posting Date}, 'minutes') < 60, DATETIME_DIFF(NOW(), {Posting Date}, 'minutes') & IF(DATETIME_DIFF(NOW(), {Posting Date}, 'minutes') = 1, " minute ago", " minutes ago"), IF( DATETIME_DIFF(NOW(), {Posting Date}, 'hours') < 24, DATETIME_DIFF(NOW(), {Posting Date}, 'hours') & IF(DATETIME_DIFF(NOW(), {Posting Date}, 'hours') = 1, " hour ago", " hours ago"), IF( DATETIME_DIFF(NOW(), {Posting Date}, 'days') = 1, "Yesterday at " & DATETIME_FORMAT({Posting Date}, 'h:mm A'), IF( DATETIME_DIFF(NOW(), {Posting Date}, 'days')

Hello airtable enthusiasts,I was wondering if anyone here has tried documenting airtable automations. I have a bunch of automations that use airtable blocks and sometimes even use the airtable scripts. I want to do a step by step documentation of what the the script does in a separate file for future reference. Is it possible using airtable? Alternatively does airtable AI help with it? If not, are there any other tools that help with the documentation process? Thanks 

I joined a team that's been using Airtable for a few years and noticed there's a view that was created by someone who's now retired. Is there a way to tell who's using a view so we can determine if it's okay to delete it?

I am trying to build a more comprehensive product-tree type base where I can accurately keep track of Projects, Assemblies, Parts, attachments, and revisions. I want to have a parent-child relationship in that same order as well, but I don't strictly need to assign this attribute. The goal is to have some sequence number for an assembly or part, where the first few strings are based on their parent fields. I've found a sufficient workaround for the hierarchy by just linking tables and limiting to one field per record. Now I'm stuck because I can't limit my count or sum formulas to only be above the current record like I would in excel. For example, I have AssemblyA, AssemblyB, and AssemblyC.If assemblies A and B already have 5 parts each, when I create the first part for AssemblyC it should be in the format [Proj#]-[AssyC]-001. With autonumber the sequence would have jumped directly to 11 by now, even though this is the first part for AssyC. Has anyone found a way to i

Hello Airtable community,I'm trying to build a light personal content management tool, and I would really value your help. I've tried to explain the situation and questions as clear as possible below, and appreciate your help. Please let me know if you'll need a clarification.SituationThe database consists of (among others) the following tables:Industries: each record is an industry such as [IT] and [HR]User: each record is a user with basic user info, and also fields like [language] and a linked field [industry] (from table [Industries])FeedPosts: each record is a content item from a rss feed, with fields such as [title] [text] [image]  and a linked field [industry] (from table Industries)Content: this is the table where I need help for: see belowChallengeMy challenge for the records in the table [Content]:Multiple records should be created: for each user with the same value fo

I am building a product using softr and airtable. On Softr, I have a list item that has a button which will capture the name of the user who clicked on the button. I want to capture the names of the users who click the button, all in one cell of the airtable against the item record. I have set the column type as multi select. I am unable to get it one as the cell is overwriting or deleting the existing data in that cell. is it possible to show multiple tokens in one cell against the respective record only.