Solved

Im trying to set up a BOM (Bill Of Materials), but i have thousands ind different categories and subcategories. I though it could use the use the new dynamic filtering in the the link fields, but as there a many seperate sub categories depending on the material it ends up being quite messy.So I thought I maybe can rig something up in a script extention to have the user run through a bunch of questions to filter out all the irrelevant records to finally be asked to choose from a narrowed down list (as if the user would be choosing records from filtered view). Is this possible with the script extention?

let table = base.getTable("Orders"); let field = table.getField('Order Info'); let record = await input.recordAsync('Choose a record', table);I know that if I make this script, I can press the button and then select the record to run the automation.But what I wanted was to press the button and the script would already get the record without me choosing it.Is there any way of doing this?

I want to create a formula fields equal to now() with specific hours and minutes. My formula must return a date equals to today at 18:00. Exemple today is 05/06/2024 16:12 -> 05/06/2024 18:00Thanks

Hello everyone,I'm a beginner on Airtable, I don't really know where to post this message, so sorry in advance if it's in the wrong place, I have some ideas for resolution but it could be in automation, base design or then formulas, I chose to post in Other questions.I couldn't put a screen shot because the data is sensitive. 🙏I'd like to know how it's possible to keep the previous information that filled a field.Let me explain:We're doing a small CRM.So I use the Kanban view based on status and when a customer record hasn't been modified for 4 days, I've been asked to set up an automation so that the customer record goes into "Action Required" status.The aim would be to have an action to return the customer file to the previous status once the action has been carried out by the sales person.The problem is that we have 7 different statuses, so the previous status can be 6 different statuses.I thought of a button, but the rollback action (based on a record) doesn't seem to exist

HelloI've creating a function to act as a rudimentary web scraper to grab some meta data like the page title, description etc using the `fetch()` api. In an automation, this works perfectly as expected. But in a scripting extension, my `try...catch` throws an error message of "Failed to fetch".Are there some restrictions/limitations between automation scripts and extension scripts when it comes to using `fetch()` ?

Hi there,I'd like to set up an automated weekly email for pending leave applications, but only if there are actually pending leaves. When I tried using conditions linked to individual records, it sent multiple emails. And when I used scheduling as a trigger, it still sent an email even if there were no pending leaves. I have an interface with this summary, but can't seem to use it in the automation. Has anyone figured out a solution for this?

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?