Solved

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'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 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?

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?

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 for [Industry] which matches the value [Industry] from the [FeedPosts] table a record should be creat

Bonjour,J'ai dans ma base un champ de recherche qui me permet de récupérer les dates de différents enregistrements liés. Parmi toutes les dates remontées, je souhaite définir quelle est la plus petite (ou la plus grande) : comment faire ?Merci pour votre retour.Damien

I am creating my first form. I am trying to test it, so I open an incognito tab and use a different email address to try to fill out the form. It goes like thisEnter URL"You're almost there... Please enter your email address to fill out this form"I enter a different email address, not associated with my airtable account. Click "continue""Create your free account" -> prompts me to enter my "work email" and click continueANOTHER "Create your free account" page, this one prompts me to enter full name and a password. At this point I give up. There is a progress bar on the bottom that implies there are several steps to creating an account. I just need people to be able to fill out my form quickly.I need the ability to have respondents fill out a form without having to jump through all these hoops and create an airtable account. Am I doing something wrong? Or is this just how the forms work? And if this is how the forms work, is there a third party form I could use instead that won't requ

Hello! As I'm quite new on Airtable, I need some help on the general approach for the following task:I already have a table of products for my Webdesign Agency with prices per year and use this also to track by renewals.Structure like in this photo:Now, I want to have a table, where I can distribute the costs to my customer. I would need to assign products to customers and based on the numbers of customer assigned to a product, the cost per customer is calculated (Price of the product divided by the numbers of customers using this product = price per customer) and it should be displayed like in this Excel table I use currently:Honestly saying, I have no idea, if such a scenario could be done with Airtable or if I should use Excel instead...So my question: Is this possible and if yes, is there any tutorial available, where such a scenario is explained?Thanks in advance for your help!Cheers Peter

I've created an automation where when a checkbox is checked on a record in one table ("Assets") it creates a story/issue in JiraI have a second table ("Jira Sync") that is the real time sync to all the jira issues/stories.My desire is to automate the Link/lookup of the jira record id (Key) to be assigned back to the Assets table but this is the part i cannot untangle. I know there's a way to automate a vlookup between two tables so i could match on the "Summary" field which should be an exact match between the two tables but I'm not sure how to execute that - would the trigger be when a new record is created on the Jira Sync table?Further more, once the Jira Key is mapped back to the Assets table, can i create an automation where if i update any of those fields on the Assets table (trigger= when a record is updated) it will update the issue in jira. thereby creating a two way sync?thank you! 

I’m averaging 3 columns, all rollups. Note that I have this formula in them, so certain cells are blank: IF(ISERROR(AVERAGE(values))=0,AVERAGE(values),BLANK()) The 4th column, where I want to average THOSE columns, has NaN if all 3 columns are blank. Which makes sense - I just can’t figure out how to get that 4th column to BE blank if the result is NaN. The column currently has this formula: AVERAGE({Value 1},{Value 2},{Value 3}) I tried to essentially mimic what I’m doing in the other columns but nothing I’m trying seems to be valid. Thanks!

Hello,I am currently running into the base exceeding automation limit and am trying to come up with a way to solve for multiple automations we have created by using a formula field or look up field.Currently, we assign users to certain tasks and we have another field that displays their phone numbers (long text field).  I am trying to set up a formula where IF a user is selected, it would then lookup/display from another table that user's phone numbers that are list on table 2.Is this process possible with Airtable?

Currently I have one apartment per row and the tenants #1 name, tenant #2 name, tenant #1 email, tenant #2 email as column name with the tenants info on the row. This hard to export the data this way or to sync to a crm with zapier. what is the best way to organize the contacts/ tenants in general so that easier to export or sync via zapier to a third party crm like cloze.   

Hi!I have an automation that runs through a few steps when a new record enters a form submission view (pictured below). I use the 'Find records' function to search a distinct set of contacts against email address -- if successful, the records are updated with new values. If unsuccessful, a new contact record is created. A few supplemental records are created as well.  The Find Records function is specifically looking for the Record ID to move into the update functions. In tests -- including test runs of the live automation -- everything works fine. It locates the Record ID, updates it in the next step, and everything is great. However, when I activate the automation and it runs live, it fails at the Record Create (or update) stage every time. And the error message is identical every time: It tell me is cannot locate a field with the name or ID fldcy0mx2HXa5Taae. It does not have this problem in testing (and will run completely through all of the steps

Hi all - has anyone been able to bring a base back UNDER limit after going over? I’ve deleted over 10k records and emptied the trash without luck. So basically - we hit 50k records… got the “over limit” message. I went in and cleaned up some stuff - still “over limit”.

I tried posting this question yesterday but now I can't find the post so it looks like it didn't actually get created so I'm trying again.I've been tasked with creating an interface to our AirTable data using an API developed by Brightvine (Brightvine Data Link).  I can get back all the data using the API interface but I need to be able to pass in the last date the process ran on our end and get only those rows created since the last run date/time.  The BVDL gives me a place to enter URL parameters and I've tried using the "filterByFormula" option but I keep getting an invalid formula error.  The BVDL gives me access to the last run date/time in a couple of different formats when creating a parameter.Any suggestions will be greatly appreciated.Thanks,Ray Porter 

Hello, Our records number has exceeded the 1200 limit however we then deleted several hundred records but the records number doesn’t appear to have reduced and the account is still warning we are over the limit. Can anyone shed more light on this or ideally how to resolve it? We deleted the records and then emptied the trash but it hasn’t changed. Many thanks in advance

Hi,We're working on moving automation mail (Gmail) content from the automations themselves to a separate table, where other than admins can maintain text.In the mail content there may be markdown URLs with clickable "friendly names", e.g. [Book here](https://www.calendly.com). I copied the whole text from the automation to "Long text" fields with rich formatting enabled. This approach doesn't however produce markdown URLs, instead they print out the raw markdown syntax ('[Book here](https://www.calendly.com)').Remembering that using CONCATENATE formulas for URLs works in achieving the "friendly names" I tried chopping up the mail content, and using a summarising CONCATENATE field as input for the automation instead of a Long text field. This works, producing "friendly name" clickable URLs.However, we have URLs in various places in the content, so chopping these up becomes really tedious, if not impossible. A workaround is to have body content first with text telling the reader somethin

Hi all, I’ve been reading through a ton of different conversations about Airtable and recipe managers. and have found some amazing info on here. I’m currently a little blocked so maybe someone has more info on the following topic. Overall, I’m trying to create a database that has recipes where I can understand both the cost per recipe and the macronutrient breakdown for each recipe. Where I’m getting stuck is breaking down the nutritional values because some ingredients are in cups and others in tbsp. I’m trying to convert measures to grams but am having trouble connecting the conversion info to the recipe info. Generally my table is structured as follows: I have the following tabs within my doc Meals - it’s the meal planning tab Recipes - this is an overview of the recipes that feed into the meals tab Recipe Ingredients - this is where the recipes (in the recipe tab) get composed of all their ingredients Ingredients - this is a master list of different ingredients that cascade up

Hi allI've been working on SAP Integration Suite for connecting to airtable and perform CRUD operations. I've created a integration flow for PATCH request in my suite and wanted to test it through POSTMAN by hitting the endpoint of PATCH iflow. The issue here is that even though i'm sending my json payload in the format of airtable PATCH request postman is throwing 500 error.My table in airtableNote that EmpID is also Single Line Text hereBelow are my configurations of the integration flow i've created to perform a PATCH operation through POSTMAN.Json payload i'm sending through postman to suite{            "id": "rec6jjMo9lBFpfI62",            "fields": {                "Location": "India",                "EmpID": "4",                "Name": "Tester",                "D

I'm using a simple formula to calculate the due date difference between today and the project due date:WORKDAY_DIFF(TODAY(), {Due Date})-1Which works for anything due today and in the future, but does not calculate properly for past due things. If today is 11/19, something due 11/18 should be Past Due by -1, but it shows -3. Given that it works for current/future dates, what am I missing here for the past dates?   

Hi,In our CRM we have several different situations, where reminder mails should start going out to contacts. Many of these are chained so that if the contact doesn't respond (e.g. sign up again after an event they cancelled), there will be reminders 1, 2 and 3 with some days time in between.Originally I created these as separate automations, it was simple and easy to overview. The triggers were "When records match conditions", like this (simplified):Reminder 1 - When record match conditions: "status = cancelled"Reminder 2 - When record match conditions: "status = cancelled" + "when cancelled = is numbers of days ago 2"Reminder 3 - When record match conditions: "status = cancelled" + "when cancelled = is numbers of days ago 5"But having several of these situations split up into separate automations eat up a lot of the automations quota, so I tried to integrate reminders 1-3 into one automation. So I used just one trigger "When record match conditions: "status = cancelled"" to catch all

Hi all,I want to prioritise datasets in Airtable. For that I've created checkbox fields and a drop down field.I now want to create a formular field and add there a weighted text drop down menu by giving each text option a number. For the checkbox fields it's clear: If it's checked, then value1, if not, then value2:IF(logical, value1, value2) + IF(logical, value1, value2) +  But how can I add the weighted values from the drop down menu in the formular?For example IF option1, then 3, IF option2, then 2, IF option3, then 1, otherwise 0)IF(logical=1, 1, 0) + IF(logical=1, 3, IF({logical=2, 2)) In detail, this is the formular which is not working:IF({easy to implement?}=1, 3, IF({easy to implement?}=2, 2, IF({easy to implement?}=3, 1))), 0)nor doesIF({easy to implement?}=under 2h, 3, IF({easy to implement?}=up to 8h, 2, IF({easy to implement?}=a day, 1)

Hello I started exploring using Airtable native AI fields; I would like LLM to read and process an attachment documentin PDF but the relevant field {Attachment} seems not to be available in the prompt design. Is it possible in some ways or do I need to resort to using OpenAI APIs and scripting? Regards and Thanks !

Is there a sequential order when a new record is created through a Form view? Can you define/control the order?