Solved

Hey folks,I'm having a strange problem with updating records in my Airtable. I set up an automation where it checks if a record with a specific user ID exists. If it does, it updates the record, and if not, it creates a new one.I deleted all the records from the table. Now, even though the table is empty, the update is failing because the automation is finding two record IDs that don't exist anymore.Empty Table:Run automation :The update will fail as it refers to the previously deleted records' IDs. Is it a cache issue of some sort?Any ideas on how to fix this?Thanks!

Hi Airtable Community,I have a table with events. New events can be added via a form and various needs can be requested for the event using a multiple selection field.A record is generated in a second table for each need.I have currently created an automation for each selection option as I have not yet found a way to do this dynamically. However, as there are now around 30 different needs, I would like to make the automation dynamic. Any ideas for a solution? The problem is that the need has to be named correctly and I can't pull this information dynamically from the multi-selection field.Thank you and BestMirko 

I have 2 questions to ask:1st being this:I have 2 tables:1. Revelator Sheet Data2. Client InformationThe "Revelator Sheet Data" table holds the music assets of the clients belonging to our business. To map the assets to the clients (in the client information table) I will use the "payee_id" which is present in both "Revelator Sheet Data" and "Client Information" tables.But I can only link 2 tables with primary fields. The "Client Information" has "Client ID" while the "Revelator Sheet Data" has "Id" as the primary fields. So, when I linked the "Client Information" table to"Revelator Sheet Data" table using client_id, how do simultaneously match the payee_id?For example: Above is the Revelator Sheet Data table. I have linked the client information table using client_id. Now I want that if "Payee id" (in Revelator Sheet Data) and "Payee ID" (lookup field from client information) are similar, the client_id is mapped automatically ie I basically want to map client id based on pay

Hi Community. I'm new to Airtable automations so apologies for what may be an overly complex workflow - any suggestions to improve it are welcome. Goal: send an automated email when someone "invites a friend" on a website. Email will say "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site", etc. How I've set it up so far: Airtable table with fields Friend's name, Friends email, User's name, User's email Concatenate formula to combine the above fields into a message something like "Hi {friend's name}, your friend {user's name} {user's email} recommended you join this site"Automation to send an email using the text from the Concatenate formula Problem: there doesn't seem to be a way to format the text so when the email sends, it's just a long string of unformatted text. Does anyone know a better way to set this up? 

Hello - I am trying to get a total count field if student's have passed multiple tests. There are six fields representing each test. Within each multi select field the contents contain: Drop downs for fields:  Pass 4/5/24, Pass 4/17/24, Fail 4/5/24, Fail 4/17/24.  I want to use a multi-select tool so if/when they retake the test, I can note which date they passed or failed. Fields:Test 1 Test 2 Test 3 Test 4 Test 5 Test 6 I would like another column to say, if the fields contain pass, then count it as one. If a student passes 4 out of 6 of the tests, I would like the column to have the total = 4. I am stuck combining the multiple fields. Airtable provides the following equation to count for one multi select field: IF({YOUR MULTIPLE-SELECT FIELD NAME},LEN({YOUR MULTIPLE-SELECT FIELD NAME})-LEN(SUBSTITUTE({YOUR MULTIPLE-SELECT FIELD NAME},",",""))+1)Is there a way to create a formula that will count from multiple field

Hi, I'm new to automations on Airtable and am facing an unusual error:"Name is "foo", Invalid filter on Email (Invalid choice name or id: foo@bar.baz)"My "Find records" step has two conditions (OR), attempting to match on "Name" or "Email".Here you can see a successful test, when a match is found:It is also successful when no match is found, BUT when only "name" is used, and not both name and email, finding 0 results (expected behaviour).  BUT when adding the email condition bac, when there are no matches, it gives the error: This seems like a bug to me, can you advise? Thanks!!

I want to have a select field with a couple of options for clients that need a subscription. Like: "1 month subscription", "2 month subscription", ... . This would ideally convert the answer into a 31 day duration field that can then be used in a date dependency to calculate the end date for the subscription. Is this possible?I already figured out that i can convert it to duration using a formula field but then i can't use it in a date dependency...

To any formula ninjas, A column has multiple keywords/values. I need to add a pre-fix before each of the values. From: column: Colour values: White, Black, Blue To: add the prefix “Colour_” to each one of the values in the colour values: Colour_White, Colour_Black, Colour_Blue I created another column with the prefix Colour_, and then a basic concat, but the result is (of course): Colour_White, Black, Blue I don’t know how to add the prefix to each of the values individually, and if concat is the right formula. Detail: not all columns will have a value, so need to consider an empty cell. If anyone has a good idea… much appreciate it ! Christie

Hi,I find myself needing to change at least single select values, and would like to know if there's a way to do that without breaking automations and interfaces?I e.g. have names of event types that I need to change, for example from "Discovery" to "Discovery call" or status kind of values like "Ready" to "Ready for invoicing". Any of these are used in interfaces and automations as discriminating variables to either activate automations or filter what is shown.When attempting to edit one, I get a warning of dependencies, but I can't understand whether the update would actually break the listed dependencies.Thankful for any help how to do this safely. I have a ton of changes to make....Rgds,Björn

Hi I have a file name / string of texte.g. 'ThisIsTheFileName'I would like to insert a space before each capital letter. Is there a formula to do this?Thanks 

I have a script that I'm having difficulties with. The script is part of an automation block which is triggered by a new record being added to a table called Projects. This record in the projects field has some info about it, (how many episodes, series number, etc) but crucially, has a multi-select field. The automation is supposed to look at the trigger record, which has a field for how many 'episode' records it should create, and then makes the episode records and links them back to the project. It is supposed to also copy the multi-select entries that are in the triggering record and make them the same in the newly created 'episode' records. But it seems to be failing at that, and I'm getting an error: Error: Field "fldYr1BVOeRj2DLLz" cannot accept the provided value. at main on line 43 Can anyone see from the script what might be the issue. The field mentioned above is the 'Elements to create' field in the episodes table. Here's the script: let inputConf

Hello there! What's the best way to enable AI for our workspaces? Our organization admin has requested activation through the in-app prompts and contacted Sales directly, but it's been over two weeks without a response. I manage everything for Airtable in our org and I'd initiate this myself and push more, but my org admin can't make me an admin because it appears that Airtable can't make an admin out of a user that has an email from a different domain. If there's an account executive associated with our account, I'd be grateful for an introduction to help guide us through this. 🙂  Thanks!

Hi! Thanks for any help.Not sure what is causing this. I set up an automation to send an email when a field is updated to a certain value.The email is sent but the data from the specified fields are not included and there is an error. Here is the email:-----Subject: New Potential LCR:  - $ - #ERROR!This was just added as a planned LCR expenditure.Estimated Amount: $ Estimated Date: #ERROR!Vendor: Vehicle:-----So there should be data pulled from the fields for each of items. I also don't know why there is an error.The data in the actual table records is there and seems OK. Here is what it looks like:So the data exists, but it's not included, and the estimated date is generating an error. Otherwise the email is being sent.Thanks for any help! 

Hi there— Grateful for your help in figuring this out.I have a single select dropdown field in one cell. If a user selects an option in that dropdown field, I'd like the cell next to it to replace the text based on whatever is selected. So in the screenshot, if someone selects "Brown" in the dropdown, I'd like the cell to the right to show just the text "Color Theme D". Is there some kind of IF statement or formula I can use in that new cell? Thanks!!

Is there any possible way to run Data Fetcher from the Interface?I have created a Button following this info https://help.datafetcher.com/advanced-options/run-request-from-button-field but this resides in the data which is not ideal. I want to be able to fetch the data on demand with the click of a button from the interface without ever opening the data. Is this possible

Hi, this is a Voiceflow specific question, but I was hoping someone might have some ideas.I'm making an API call from Voiceflow using a multiple filterbyFormula to exclude words. This is what it looks like:https://api.airtable.com/v0/appname/tablename?fields%5B%5D=Title&fields%5B%5D=Link&filterByFormula=AND(FIND(%22Long%22,%20%7BHair%20(Style,Color)%7D)%20%3E%200,%20FIND(%22Very%22,%20%7BHair%20(Style,Color)%7D)%20%3D%200 )The above works without issue. The problem is that my filterbyFormula changes often and needs to be contained within a variable so my actual call from Voiceflow looks like this:https://api.airtable.com/v0/appname/tablename?fields%5B%5D=Title&fields%5B%5D=Link&filterByFormula=AND({filter1 })This is working fine when I'm looking for a Match, i.e when {filter1} = FIND("Long", {Hair (Style,Color)})>0But if try for No match, i.e. when {filter1} = FIND("Very", {Hair (Style,Color)})=0, I get the INVALID_FILTER_BY_FORMULA error. So the problem se

Hi! I am using airtable to keep track of several types of info connected to individual clients. However, sometimes I need partners/spouses' names to be in the same column. Is there a way to write a formula that only runs when certain conditions are met?For example, as seen in the picture below, my current formula for IN PROGRESS: Client and Spouse column is {First Name (from Spouse/Partner)} & ' and ' & ({Full Name}) I would like that formula to run IF there is a spouse, and I would like the IN PROGRESS: Client and Spouse column to only populate info from the Full Name column if there is no spouse/partner.I tried writing IF statements, but I couldn't figure out.Thank you!

Hi everyone! I have an Airtable base for a virtual event my team is planning for Learning at Work Week. The base includes the following:An "Activities" table with all of the activities that learners can complete, each worth a certain point value. The people who have the most points at the end of the week win a prize! A form (linked here) where learners input their email address (their identifier) and can multi-select (via a lookup from the Activities table) the different activities they did during the week. The form can be submitted throughout the week as various activities are completed, or at the end of the week once all activities are done - it's the users' choice! A "Form Responses" table to store all form responses.A "Participants" table that is automated to create a record that links the users' email address to their form response(s) as they're submitted.Within the "Participants" table, I have a lookup field that lists all of the activities that that user logg

I hope I put this question in the correct area.I am developing a base to use for a contracting business, and I have a column for Distance Driven to job (to calculate fuel used in a different column)when I create the job for the client, it auto inputs the job address into a column, is there a way to have it auto calculate the distance to drive (by inputting my business address as always being the starting address, and the job address being the ending address?)Currently when I am creating the job for the client in the base, I have to open Google maps in a separate page, and input my business address and job address by hand, and manually transfer the number of miles into the base.There has to be a better way, right?

Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} names (Example: John)Column 3: {Total Volume} quantity (Example: 10)What I want to get from this formula is = John - 10What I'm getting from this formula is = “John“ - 10Is this because I am linking to another table? It does not happen with every value from the {Client} column! 

Hi… I’m looking for a scripting solution that lets me auto-populate a field with a parent and child relationship. Eg - Column 1 has the children Column 2 has the parent of the child I’m wondering if I can write a script that can populate a new column with the tree hierarchy like this - wco:WC Interface → wco:Area → wco:Block → wco:Image Card → wco:Hero Image Card I have looked at a solution posted by joao_melo which works. But i’m wondering if this is doable in a script?

Hi all,This seems pretty basic but I can't get it to work after a day of researching and patching together example code I've found. I have no Javascript experience.I simply want to run a script that entirely clears the contents of a column. Here's what I have:  let subsTable = base.getTable('Sub Assemblies'); let clearQuery = await subsTable.selectRecordsAsync({ fields: [] }); function myObj(rec){return {'id':rec.id,'fields':{'BOM CREATE':""}}}; let updates=clearQuery.records.map(myObj); console.log('updates: ',updates[0].fields) while (updates.length > 0) { await subsTable.updateRecordsAsync(updates.slice(0, 50)); updates = updates.slice(50); }  The error I'm getting is: j: Error: Failed schema validation: <root> must be an arrayline: 2nd from last Any help appreciated!

Hi!I am testing airtable to see if we can use it to accomplish our needs and have hit a snag with this Project Profiles interface. I created a spreadsheet that feeds the interface, each row is a "project" but I need to display associated data at the bottom of the interface in table format.There is a way to do this by linking to a separate table, but I don't see a way to set the tables as an intuitive 'child' to the given project so that the process is more automated. 

 Hello airtable community, I have this following formula but dateadd does not display the operation in the result thank you for your feedbackFranck IF({Date début package} != '', {Date début package},IF({Date début expl 23} != '', {Date début expl 23},DATEADD({Date début package},{Nombre jours d'Activité},'days'))) 

I'm trying to figure out the best way integrate my Airtable base with Sages brightpearl.Will this be possible using a script extension?Or should I use Make?Has anyone done this before and what will you recommend?