Ask the Community

Good afternoon! Tell me how to display the number of records from other tables in one table and then add them up

Sorry if something similar has been posted already - I'm hoping to figure out an automation where when a record on one lable is labled (via checked checkbox) as a primary contact, that record links to the "primary contact" linked record field on a different table. In a perfect world, this could coincide with an automation where if the primary contact changes (a record is unchecked), that record is unlinked, and replaced with the new record.Or - is this possible to do with conditional formatting at all? I can provide screenshots if that would be helpful!Thanks all!

My button works great, and I'm fairly good with automations, but I can't find a solution. I'm guessing the best way is a script, but I always have to find the script code I need online and I can't find anything related. Can anyone point me in the right direction? Thank you.

I am trying to do a formula where I have a row with numbers (=calculation field/column) and depending on the number a certain text value (Tier 0 / Tier 1 / Tier 2 / Tier 3) should be the result in my formula fieldTier 0 : 500,000 - UnlimitedTier 1: 100,000 - 500,000Tier 2: 40,000 - 100,000Tier 3: 500 - 40,000I tried several approaches but none of them worked, I always get an error message.IF( {Calculation} < 40000, "Tier 3", IF( {Calculation} < 100000, "Tier 2", IF( {Calculation} < 500000, "Tier 1" , IF( {Calculation} < 100000000, "Tier 0"))))ORIF({Calculation} < 40000, “Tier 3”, IF({Calculation} < 100000, “Tier 2”, IF({Calculation} < 500000, “Tier 1”, “Tier 0”)))ORIF({Calculation} < 40

Hello guys, I need some help in editing the below code to integrate open ai api with airtable directly without any 3rd party tools. is there any way that we can make the script automatically run all records of a column instead of manually selecting each column every time.  const { table, promptField, outputField, openaiApiKey, maxTokensStr, } = input.config({ title: "Connector to OpenAI API - Using text-davinci-003", description: "", items: [ input.config.table("table", { label: "Table", description: "Where your fields are" }), input.config.field("promptField", { parentTable: "table", label: "Prompt Field", description: "Text you want a response to" }), input.config.field("outputField", { parentTable: "table",

Hi, i have a formula field named "Jenis Parts Regex" where its value is "15.9mm Karet stabil FR RH/LH ES1|05".I want to extract anything that matches "end_of_name" field, in this case "ES1|05", and the result shall be in "regex replace" field.But what i got there is "15.9mm Karet stabil FR RH/LH |". Why am i getting "|" ?Here is my formula in "regex replace" field:REGEX_REPLACE({Jenis Parts Regex},end_of_name,"")Please helpThanks 

Hi there!I am trying to create a formula that looks at an entry (single select) and if that entry is = A, B or C say "Blabla" and if it says anything else say "Haha".I have hence tried to nest OR() into IF() as followed:IF(entry=OR("A", "B","C"), "Blabla", "Haha")I am not shown any error but the formula result is wrong (It says "Haha" when it should say "Blabla').Any thoughts?

Hi All, I have a base and there I have information about customers.Each customer has associated different tables with information like contacts, references/products, payments, invoices, order history, samples, etc.I want to know if  I can make a dashboard (with interfaces) that integrates the information of all the tables related to a customer, and I can see everything mentioned in a single view panel.Thanks, J

I have a base that tracks when a staff member turns in a survey for a free sample product they were given. They should not get new samples without turning in the original surveys. Tables include:StaffSamplesSurveysThis might seem silly, but I'm struggling to automate when a user completes a survey how to track that they are again eligible for new samples. For what it's worth, A staff member may have several samples in their queue, which is OK, but we'd like to reconcile at least once a month. Open to approaching this in new ways. 

This is for exports from a donor database. I have two columns Credit & Debit. Credit is for the donation amount and Debit is for the CC processing fee amount. Debit is a calculated column based on a formula. Each "Donation" (Record) has both credit and debits but I would like to have a separate record for each of them.I.e. 1 Record for John has his donation amount as well as the other misc. columns and 1 Record for his CC fee.I only know the term in PowerBi of unpivoting columns to achieve this. Is there a way to do this in Airtable?

Hey guys, super new to airtable and JS, still trying to figure out how i can embed my script in this first post of mine.I wrote a script that finds the largest number in a field, increments it by one and does some other formatting stuff (add a 'Q-' +(last two digits of the current year)+(current quote #))) then puts it in that same field for the record that triggered the automation. It sorts all records in Ref Max No(formula field to extrapolate a number from our quotes. The formula is as follows:IF({Ref No}, VALUE(RIGHT({Ref No}, 3)), 0)  e.g. Q-23089 turns into 89For some reason it keeps finding the largest number as 572 even though th

I have created a form view where users can input certain data points. These data points are then used in my Airtable base to calculate an output (based on a formula field). What I would like to do is to display this output (result of the calculation) to users, after they submit their input through the form. Can somebody recommend a way to do this? I have explored some of the apps and automations, but I cannot really find any way to achieve this.

I am trying to build an automation or formula for this scenario:Student #1 has been enrolled in school from the dates 7/1/2018-6/30/2023. I have a field in this table (Students table) for Enrollment date (7/1/2018) and graduation date (6/30/2023). I need the field " School Years" to populate with the respective school years this student was in school for. Ex: SY 2018-2019, 2019-2020, 2020-2021, 2021-2022, 2022-2023 - this is a multiselect field. This will be unique for every student, as their enrollment and graduation dates are varying...I have build a table named School Years and have the start and end date for each school year as a record. I would love this to be automated so that every time we have a new student and their graduation date changes, it will update what school years they were here for.This seemed so easy to do in my head and I have tried every way to get this to work, but I cannot see

Hey all - I'm running a formula column with a lot of IFs in there. Only 1 out of the 6 possible responses returns a text field, the rest are date fields.The dates come out in a very ugly way, this is how it looks: 2023-07-12T23:06:37.000ZIt basically makes it impossible for me to use / property view.After some playing around with it, I've understood that the issue here is with the fact that one of the values returned is a text field.However, the way I have the formula and the intended use. Unfortunately, I can't do anything else but have a text in one of the IF's (since it's the if true, not false, that I could just leave empty).I've tried using the time parse formula like this: DATETIME_PARSE(the if formula), but the result is an error.How do I make this work?

Hi I want to extract a portion of a text from a google drive share link.The format of the drive link is like this:https://drive.google.com/file/d/1IklI1OAW8XLtTKDfwW75BNcve8z8xQ57/view I want to extract the text after "d/" and will end at before "/view". So the intended result should be "1IklI1OAW8XLtTKDfwW75BNcve8z8xQ57 "Any ideas how?Thanks a lot!

Hi guys!Im trying to create an automation that changes a single select field from one option to another. I have a record of a tour which has a start date. I would like to change the field of "Week" to "Last Week" if the start date is before today but not before 1 week ago. It is my understanding that I first have to 'Find Records' before, and then use those records in the Record ID field of the configuration, but it still isnt working! Can anyone help me understand what the issue is? Thank you

Hi,I have two tables:The first one is to manage people who fill in forms and then I want to send them an email with the appropriate PDF training. When they fill in forms they get different "roles" such as Prospect ticket as you can see. It is linked to my second table with the columns programmes and pdf.My second table (programmes) contains the pdf files I want to send themWhat i would like to do is that when on my first table they are for example prospect ticket, they get THE programmes and the pdf associated with the program using an automation. So for example: For Prospect ticket I want ticket and the pdf associated (as it is in the picture), prospect boost get boost and the pdf....I have been trying for a long time this afternoon

I am trying to create a reasonably simple base that stores HR statistics such as monthly, quarterly, and yearly numbers and trends.    For example, I would like to store the number of employees by location, office, DOL status, etc., and then formulate the change in numbers each month, quarter, and year.   What is the best way to set this up?  I tried a base where I added two years of data in one table, but I couldn't manipulate the data to get the statistics I wanted.   Any suggestions are appreciated!  I looked through Airtable's templates but couldn't find what I wanted.

I want to create a script that will automatically open links inside of a specified field, search for an element inside of the links ex. another url, and perform an action based on the existence of the element or lack thereof. I want the script to be activated every time that field has another link added to it as I have an automation continuously adding more data to the table and I want the script to keep up. If anybody has any tips on how to create this script it would be greatly appreciated. I got a script from eden ai but I don't know how to code and don't really understand it. Here it is import jsonimport requests# Function to search for specific elements within the links in the Airtable databasedef text_search(api_key, texts, query):headers = {"Authorization": f"Bearer {api_key}"}url = "https://api.edenai.run/v2/text/search"payload = {"providers": "

Hello, I currently have two separate Airtable accounts that I would like to keep separate. However, when I logged into account #1 today, I noticed that I could see the base from Account #2.Could someone kindly explain why this occurred and provide guidance on how I can avoid this situation in the future? Thank you very much.

Hi,I have the following challenge where I would ask for your support:I have a table that contains account transactionsI have a (growing) set of "rules", according to which I could assign a specific type to each transaction.My main question is how to define these rules in airtable and how to check if they apply and according to the result to set the type for each transaction.To give an example - see screenshot of such a transaction:My rules typically must consists of a "contains" -matching within the column "TAC-Source" and a "contains" -matching within the column "TAC-Description".In the case shown in the screenshot, the rule to apply would be "If TAC-Source contains "EG Schottenfeldgasse" and if TAC-Description contains "0704"" then set column Ruleset_MAtch_Type to Value "A"Defining these

I’m new to the airtable community and wasnt sure how to reply to an original post that has been closed. But I found a solution to this #ERROR! when using ENCODE_URL_COMPONENT() on lookup? post. You can use ENCODE_URL_COMPONENT({lookupFieldThatYouAreTryingToEncode}&""). This adding (&"") solution is a lot neater than adding another already encoded field to the parent table.

The Airtable product team track record continues to baffle...I suddenly got the new record details layout experience, and although a bit surprised after having no mention of it in the What's New July 2023 edition that went out barely a week earlier, I was initially excited. The redesign is clearly inline with the record detail view on mobile devices (hinting at mobile interfaces coming soon??)...That is until I realized that it completely broke the ability to change edit permissions on linked record fields where the records are one-way synced from another base. As in, if you had fields that were set to editable before this update, they are stuck on being editable, and if you have non-editable ones or try to add new ones, they are stuck on being non-editable.If you hover over the "Allow users to link/unlink existing records" switch you see this message: "Users can't link/unlink existing records because this table is synced from

Hi, I have created a Typeform survey and a Airtable to record all the answer. However, if a user using a same email. It will create a second record with same email. How can I have AirTable filter by email and update records accordingly? Is this achievable? Please look at 1st Survey table. Airtable

Hello! I am currently trying to extract information from an inconsistent string of text and having a tough time.Ideally, I would be able to drop the MONTH and DATE from the String of text and KEEP the all the text along with just theYEAR. The trouble is, both the intro text (represented as X's) and the dates are not consistent lengths. EXAMPLES OF TEXT:  DESIRED OUTPUT: XXXXX.RTW.Men.7.5.2023XXXXX.RTW.Men.2023XXX.RTW.Women.12.10.2022XXX.RTW.Women.2022XXXX.RTW.11.6.2022XXXX.RTW.2022