Solved

Hello great community. wonder if there is an option where we can get a custom email ID for a record for example (recordxyz11234@airtable.com) and when we communicate with this email id, all history will be logged in the record history as chat or notes This exact feature is in clickup, any recommendations how to do that native or via automation tool? thank you!

I’m working on a table where I have different currencies (in separate columns) and need to convert them all to one currency. I have a column marking the currency used and so the conditional if statement uses this to have a different calculation for each statement. However, for some reason, the formula doesn’t work but it does not return an error, it simply returns a blank Cell, so I have no idea what I’m doing wrong. Please HELP. IF({Currency} = “MXN”, {Amount in MXN}/{FX}, IF({Currency} = “EUR”, {Amount in EUR}*{FX}, IF({Currency} = “USD”,{Amount in USD}))) I know about the Currency converter app, but due to the Terms and conditions/privacy settings, I can’t use it.

Hello all. I’m trying to append the value of a specific field to the end of a URL that’s opened by clicking on a button field. For example, I have a field called ‘Deal ID’ and it has different values for each record. Example - Deal ID = 123456 URL = www.google.com/ What is the URL formula for if I wanted to append this ‘Deal ID’ on to the same URL for each record. I tried “www.google.com/{Deal ID}” but it didn’t work. Thanks Dan

Its probably a simple formula…but here goes… I have a record in airtable that looks like this: The A, B, C represent the responses to survey What I want to do is COUNT the number of each letter - so for example A = 3 B = 1 C = 2 E = 1 I have got as far as: IF({Col1}=‘A’,1,0) and that returns the 1 (in this example) What does the formula look like to check in Col2 - Col7 contains ‘A’ and then give me the total of 3? I hope that explains what I am trying to do clearly :grimacing: :nerd_face: Thanks in advance.

Consulta: Si tengo un campo donde ingreso la fecha de nacimiento de una persona, cómo debo formular otro campo para que me devuelva la edad de esa persona y que se actualice automáticamente cada vez que consulte la tabla. Gracias a todos!

This is killing me. It’s literally the last speedbump in my first Airtable script: I have this command: await email.updateRecordAsync(dateArray[i][0],{‘ActualFieldName’ : linkID}); It works! But THIS… await email.updateRecordAsync(dateArray[i][0],{fieldVar : linkID}); DOESN’T WORK. Even with the single-quotes gone, the system is still parsing my defined and assigned fieldVar as the string “fieldVar”. It’s maddening. Any ideas?

Hi community, I need your help. There is something i don’t understand with the formula bellow : IF( SEARCH("Jungle", {Order Line Items}), "Jungle", IF( SEARCH("Baby Plantes", {Order Line Items}), "Baby plante", IF( SEARCH("Pets Friendly", {Order Line Items}), "Pet's Friendly" ) ) ) I want to write a 4th condition but it never work. What is the importance of the space between the condition and the “)” ? How can i built easly this type of formula ? Thank’s a lot, Matthieu

Hi community, I need your help. I have a concatened formula who find 2 result on 2 colums + text I just want to add this condition : if you have 1 or 2 result missing, display a bank field. This is the formula : CONCATENATE("Diamètre : “,{Diamètre},” cm / ",“Hauteur : “,Hauteur,” cm”) The 2 column : “Diamètre” and “Hauteur” Thank’s for your help Matthieu

Hello! I’d like to have a set of single select options that indicate a follow-up timeframe. Example: 2 weeks, 1 month, 2 months… I’d then like to have an automation generate what that date would be, where the automation would take the record created date + that amount of time (2 wks, 1 month, etc.) The date generated by the automation would drive a view that looks for any follow-up dates within a week’s time span. I know how to create the view, I’m just hoping that it’s possible to create the automation to update the follow date field based on the option chosen within the single select field. Is this at all possible? Thanks in advance!

Thanks in advance, attached DB schema and issue.

Hello, We are trying to use an API key generated by myself (the owner) and it works fine to read data, but not when we try to write data (It says ‘You are not authorized to perform this operation’). The same code used to work previously with different API keys. Any help would be much appreciated. Thank you. Catherine

Let’s say I have a table with few rows - each one has a uniq ID Can a button cell have a script that will identify the ID in which he was called? for example - this is my table: id. Button 1 Click 2 Click when I click on the button on the first row - I can see what is also the id of this row.

I have 3 columns that have data, and for any given record, only 1 of those columns will have data. I’d like a 4th column to populate the data that’s in whichever of the 3 columns has data. Examples: Column A = Blank, Column B = Blank, Column C = ABC, then Column D = ABC Column A = XYZ, Column B = Blank, Column C = Blank, then Column D = XYZ Column A = Blank, Column B = MNO, Column C = Blank, then Column D = MNO I cannot for the life of me figure out an IF/AND or a nested IF statement(s) that will make this work. Is this at all possible? Here’s a snipit of my table where I’d like Interaction ID to handle what Column D in my previous explanation would have. I appreciate any insight. Thank you!

Hello everyone, I am creating a script that will ask the user for a project name and a hand-over date, and then the script will generate a number of records with subsequent dates (to create a Gantt chart, essentially). I want this done through the script because the intervals between the dates is always going to be the same. I am however struggling to find how to add say 5 days to the date I just collected from the user. I can’t seem to find an easy way to do it when creating a new record. Here is my current code… output.markdown('Welcome to the Add-New-Project routine'); let projectName = await input.textAsync('What is the name of the new project?'); let handOverDate = new Date(); if (await input.buttonsAsync("Hand-over date", ["Today", "Custom"]) === "Custom") {let newDate = await input.textAsync("Enter a date: M/D[/YYYY] (Current year implied if not included)") let year = newDate.slice(-5, -4) === "/" ? "" : "/" + handOverDate.getFullYear().toString() handOverDate = new Date(`${ne

Hello. I have two tables - Orders and Shipments. Orders are pre populated using an integration with Hubspot. Shipments are created manually using a ‘Create Shipment’ form on the Shipments table. I want to assign Shipments to Orders by clicking on a button in the record of the ‘Order’ named something like ‘Add Shipment’. This should then open a URL for the ‘Create Shipment’ form on the Shipments table. Ideally here though I want to pre fill the Order Number of the record that I clicked the button on. I have created a linked record field in the Shipments table which links to the Orders table. I have then appended the following to the URL for the button: “prefill_Order Number={RECORD_ID}” The linked record displays and I can choose the order number manually but it doesn’t pre fill. Can you let me know where I’m going wrong if possible? Thanks! Dan

Most of my attachments are no more displayed. The files name are still there but are replaced by a picture icon. The files are there too (I can download them from Airtable). Same things happen if I add new attachments : the files are imported, but are replaced by an icon. I have a presentation to a customer in a few hours…

I am trying to concatenate two columns, a percentage (based on a formula) in one column and its associated product in the other column. When I concatenate, the percent is converted to a decimal. I know to multiply this result by 100 and add ‘%’ to get the result I want. And it works for most values, but some of the decimals turn out like this: 15.920000000000002%. How do I get all resulting decimals to show as XX.XX%?

I have several tasks where a date field is filled for whatever date that task is completed. I tried to build a formula where if no date field is blank, it sets the date to TODAY() so that I can know when everything is done. It seems like this formula keeps re-updating to whatever today is everyday. If all the tasks were done Tuesday, it still keeps changing to whatever today is in that IF(***, TODAY(), BLANK()) statement. Am I doing something to cause the table to think these values are changing or do I need to use an automation trigger to accomplish this?

Hello, I’m trying to create a formula to return a value of “early deadline” if a field I have named {Application Date} contains a date less than or equal to 12/15/21. I’d also like to return a value of “Regular Deadline” if the date in the Application Date field is after 12/15/21. This is a variation of the the formulas I’ve tried: IF ({Application Deadline} <= (12/15/21),“Early Deadline” I’m wondering if I need to add anything to qualify the 12/15/21 date. The date functions I’m finding look like they compare dates in two fields on the table, where my issue is that I only have one date on the table and am comparing it to another date that is not on the table. When I try to save my formula I get an invalid formula error. Thanks in advance!!

I created a “sandbox” base to develop this script to create a new hypertext field from a text field and a URL field: When I got it working in the test base, I copied the code into my live base. The field names were different there, so I edited the script accordingly. I ran it and it worked. This script doesn’t run automatically, so after I entered new records, I ran it again to populate the empty hypertext field in the new records. Now the script doesn’t work properly. It calls the text and the URL into the destination field, but it doesn’t format them as hypertext. Here’s the result: I checked that the destination field was long text with rich formatting enabled. The code still works in the sandbox base, so I tried copying it back into the live base (and changed the field names again in the script). Will not work, even if I create a brand new destination field for the hypertext. What could be wrong in my live base that’s keeping the URL from embedding when I’m using the same code

Hi people, Dose anyone know how to make the correct date (I need year/mm/dd and time) in my table when my form get submitted? I tried the formula DATETIME_FORMAT(NOW(),'YYYY-MM-DD') also I tried CREATED_TIME() but the date and time shows up incorrect.

Hi all! I’m working on a script that grabs two fields from a table as query parameters in a API GET request, gets the resulting JSON data, and updates the records in the same table for those corresponding queries. I have my for loop running fine when I limit it to 50 records (notice the IF statement) and aware of the 50 record limitation by Airtable. How do I go about refining my script so that it grabs the remaining records? I’ve been banging my head against a wall on how to do this since Friday. Here’s the script I have so far: //Set table for Stage Data let testTable = base.getTable("Test Table"); let stages = await testTable.selectRecordsAsync(); let recordsData = []; //Testing for loop for (let record of stages.records) { let url = `https://apiwebsite?filter[account][customId]=${record.getCellValue("Query Param")}&filter[stage][id]=${record.getCellValue("Query Param")}` if (recordsData.length < 50) { let data = await fetch(url, { method

I have two records that I am trying to combine into one record. Each record is uniquely linked to a number of other records. What I’d like to do is copy the data from one record and paste it into the other record, without replacing what’s already in the second record.

Hello, I have already asked a similar question with no success. I will try to explain a bit better what I am trying to achieve here. I am building a website where users can send offers/bids for items on Webflow. I connected Zapier and Airtable to achieve this flow. Everything is ok, the only problem is if someone sends a bid that is lower than the highest bid it will show as the highest. I managed to see the record I want to be synced to Webflow on my airtable if I multi filter by “bid” (highest first) and “date” (latest first). The problem is that when I run Zapier, it will transfer all the data from airtable and not only the top one. Here a screenshot to help you understand: ImgBB Frame-53 Image Frame-53 hosted in ImgBB Also, the bids sent are for connected to multiple records on another table, so I would need to select only the top bid for different records. My question is: How do I select only the highest number and the lates

Hi all - We’re wanting to setup a new Button field in our Base that when clicked, takes the user to a Shared Airtable View URL that is pre-filtered for the row of data that was selected when our button was clicked. For example, in Table 1, we have a list of Projects. In Table 2, we have tasks or deliverables, linked to each project. We’d like a button in the Projects Table (table 1) to take the user to the Tasks Table (table 2) when clicked, and pre-filter the Tasks Table by the Project ID where the button was clicked. I was playing with a mixture of existing support articles from Airtable on buttons and shared URL filters but wasn’t having any success. Any assistance on this (or insight into if it’s even possible) would be much appreciated. Thanks in advance. Jordan