Solved

Hi folks,I'm have a dataset of events in Airtable with each event as a row, and each row has a different number of sessions that can make up the complete event. This means I have 8 end date & time columns to capture the finish time of each session. I need a column that will dynamically show the end date & time of the whole event, regardless of the number of sessions so that I can use this in various calendar/timeline views in Airtable.I've attempted to pull them all into an IF statement, like this:IF({Session 8 end time},DATETIME_FORMAT({Session 8 end time},'DD/MM/YY h:mm A'),IF({Session 7 end time},DATETIME_FORMAT({Session 7 end time},'DD/MM/YY h:mm A'),IF({Session 6 end time},DATETIME_FORMAT({Session 6 end time},'DD/MM/YY h:mm A'),IF({Session 5 end time},DATETIME_FORMAT({Session 5 end time},'DD/MM/YY h:mm A'),IF({

Hello (second attempt to get an answer about this)I am not able to see the form data immediately appear in the table once a form is submitted. I am our AT admin and have never experienced this before. Instead, what happens is the form data appears the next day, or several hours later. Obviously this impacts our workflow.Insights/Troubleshooting-- This is a native form, made with AT-- I have changed no settings and no one else has either.-- I can confirm that the form I am using points to the appropriate base.-- I have cleared the computers cache and also tried from a different machine.-- I have not changed any settings that would force the form data to appear in the base on a schedule, but that is what it feels like it is doing... suddenly!?IssueForm data is not populating into the appropriate base until several hours later. This is a big problem for our workflow. 

Hi, I am creating a CO2 emission calculator on airtable and i can't seem to get my formula right.The formula in question is:({Émission véhicule en Kg single} + {Émission véhicule en Kg total} + {Émission repas en Kg}) / 1000 The formula either calculate using one destination ({Émission véhicule en Kg single}) or from multiple destinations ({Émission véhicule en Kg total}) In every case either {Émission véhicule en Kg single} or {Émission véhicule en Kg total} will be empty which result in the formula being:(NaN + {Émission véhicule en Kg total} + {Émission repas en Kg}) / 1000or({Émission véhicule en Kg single} + NaN + {Émission repas en Kg}) / 1000 The formula for {Émission véhicule en Kg&n

Hi there,I want to have a column which displays two bits of data. Those are a cumulative $ amount and below that a cumulative % amount. I have these two lookup fields separately however need to combine them into one field column. Any help would be greatly appreciated,Bart

Airtable Friends! I have a linked field that is pulling records from our vendor database, which lives in a separate workspace. This database contains a master list of vendors, which admins update when a new vendor enters the game. In our main working base that contains the linked field, daily users can then add vendors to a specific record if they are part of that job. I need to check off that the vendor has been onboarded in a field next to the linked field which contains the vendors name. So I’m wondering if it’s possible to: -when a user adds a vendor name to our linked field, could it populate a multi-select field with the vendors name as an option? even better, a checkbox field.

Hello,I'm a new to the AirTable API and trying to automate adding records with data from another API.  I have this function: async function updateCrewRecords(data: CrewDetailsType[]) { const crewBase = new Airtable({ apiKey: AT_API_KEY }).base('appxxx') const table = cewBase('tblxxx') const records = data.map((crew) => ({ fields: { CrewID: crew.CrewID, CompanyID: crew.CompanyID, IsActive: crew.IsActive, Position: crew.Position, }, })) try { // const response = await table.create(records, { typecast: true }) const response = await table.update(records, { typecast: true, performUpsert: true, fieldsToMergeOn: ['CrewID'], }) } catch (e: any) { const errorMsg = `updateCrewRecords(): ${e.message}` console.log(e.statusCode, errorMsg) // throw error(e.statusCode, e.message) } } The commented out table.create(records) works as expected, but the upsert doesn't.  The error I'm getting is:422 updateCrewRecords()

Hello all,We have a fleet of vehicles. The people still fill in the data on a sheet of paper. I'm trying to digitize this a bit and I'm using the interface function (Forms).The person in charge would like to have a function that ensures that people cannot enter incorrect kilometers since they have to split up their kilometers driven.Do you know if something like this would be possible? Unfortunately, I have not been able to make it work.Thank you very much.    

According to https://support.airtable.com/docs/airtable-sync-integration-zendesk, automatic syncing happens around every 5 mins. But from my experience, it is around 10 mins. Is there anything to do to decrease it to 5 mins? 

Hello, Quick question. I have a field that calculates no. of days before start of a workshop. This is the formula I'm using- DATETIME_DIFF({Start Date/Time}, NOW(),'days'). I now want to create a field that calculates number of days 'after' a workshop. I want to use this for an automation. So for eg: if days after training completion =7, send email. What formula can I use here? I tried using a dateadd formula but I'm getting it wrong. Thank you 🙂

I'm trying to improve the content calendar we are using. I have a Content Field, which is the full post that we're going to copy and paste into Facebook. I'd like to have a column that will pull just the first line of the post using a formula. Any ideas on how to do this? For example, here is a post that would be in the content field:🌟 Fun-filled Learning at Ditebogo Daycare in Video Informal Settlement! These awesome educators are all about hands-on learning experiences for their kiddos. Recently, they organized a super-fun day filled with science experiments, face painting, and, wait for it... ice cream! 🍦🎨🔬Speaking of science, do you remember playing with Oobleck as a child? It's that magical goo that can be both a liquid and a solid depending on how you touch it. Now, here's the best part - Ditebogo Daycare isn't all about keeping the kids clean and tidy all the time. Nope, they believe in letting kids be kids and learn through experience! &#128

Hello community, I would like to add a record ID to the end of a URL using a formula field. It would look like this:https://www.movementplus.app/course-overview?recordId=Record-Id-Goes-HereCan anyone please help me achieve this?Thanks in advance!

I'm running an API POST script and I'm trying to utilize the id that is returned in the response.This is the key piece of the script. var postOptions = { method: 'POST', headers: myHeaders, body: formdata, redirect: 'follow' }; let response = await remoteFetchAsync("https://xyz.com/...", postOptions) .then(response => response.text()) .then(result => console.log(result)) .catch(error => console.log('error', error));I get this response. I'd like to then reference that id returned.CONSOLE.LOG "{"id":29644,"progress":0,"current_line":null,"status":"created","created_at":"2023-09-12T09:30:39-07:00","started_at":null,"ended_at":null,"file_url":null}"I've tried this, but I get an undefined error.console.log(response.result.id) 

Hi 🙂I have a formula field "TASK" that checks if there is value in fields or not.  It looks like this;IF({Fuel L}=BLANK(),CONCATENATE("• Add fuel tank", '\n')) Now, I want to have another multiple-select "CLEAR" field that clears the TASK value if the corresponding value is included in multiple select fields. For example {Fuel L} is blank, but in the CLEAR field "Fuel L" is selected. This setting should not show   "• Add fuel tank" in TASK field. I tried with FIND(), but I should use something as not FIND()... I would appreciate help to accomplish this. Thank you,Pjero

 I have a series of records that include a Start Date field that I want to incorporate into a larger CONCATENATE formula.  However, some of the records do not yet have a date and the Start Date field is blank so my formula is returning an #ERROR.  I have tried adding an IF=BLANK statement to the formula (see example below) but that doesn't seem to be working either. IF({Start Date}=BLANK(),(DATETIME_FORMAT({Start Date},'ddd, MMM, DD') any suggestions on what to try next?

I need a formula to check if there is exact matching for multiple select field when values can have comma. Here is a sample multiple select I can have:abca,bI need to check if users selection is exactly 'c' and 'a,b'. All solutions I found (like using FIND) are not working with comma.

Hi All,I'm having an issue figuring out how to best format a formula for my situation. This is probably very simple but I need a hand. Here are my fields:"Total" - Currency field with numeric value"Total Copy" - Formula Field "Is Income?" - Single Select fieldBasically, I need Total Copy to take & convert Total's value to a negative or positive number based on Is Income.I have this so far to grab from Total and make it a negative: IF({Is Income?} = BLANK(), {Total} *-1, "") But now I need it to also recognize if Is Income is not empty so it can copy from Total and deliver a positive value instead of staying blank in that case. Any help is appreciated 😊

What is the formula to get the Time in hours and mins from a Date/time field?? My date/time field is called “Start”.

I am trying to send an email after a form is submitted, and include clickable links within that email.Say I have field called SITE, if I use the syntax[CLICK HERE] [SITE] where SITE is the embedded field name for the automation it just send an email with"[CLICK HERE] [https://123.com]" Instead of CLICK HEREI tried following the the advice in https://support.airtable.com/docs/using-markdown-in-airtable but whatever combination of brackets I use, I cannot get the links displayed correctly - What am I missing please? 

How can I do a word count of a record? I have a table to organize what I write divided by scenes and I want to count the words in every scene. Thanks in advance.

I created a new token and tried to use it to replace my API key in a Zapier app connection for Airtable. Thought I was doing the right thing in preparation for the deprecation in 2024. It didn't work. Zapier doesn't seem to recognise the token and wouldn't accept it.Likewise tried to use tokens in direct connections with other subscriber apps. They didn't accept them either.I'm missing something fundamental here right? Grateful for any help.

Hi allI hope I can explain my question clearly enough. I have three tables - Job List, Candidate List, ApplicationsFrom Job List, I want to select a job and create a new Application record which will inherit the selected job title into the job title field on the Application record. This would also be a parent-child relationship.Can anyone tell me if this is possible to do?

I'm writing a script to create records from an API call. One of the fields is a single select option. At the start of the script, I want to use the input option for the user to pick an option from the single select, which will be used for all the records. I don't see any option to pick from a single-select list. Is this possible?https://airtable.com/developers/scripting/api/input 

Hi all, I’m a novice at airtable and some of the lingo is even over my head, so please bear with me. I’m a small business owner. We use Airtable to track our projects, sales pipeline, contacts, tasks etc. I am trying to create a custom grid view of my projects by quarter so I can see our projections. I would like to hide other info to be able to see a focused view. I have a column which is projected close date - I thought I could filter by this field, but it’s too limiting. Could anyone help here? Appreciate the support!

Heyo!I'm stratching my head as to how exactly format a formula down to first .00 numbers for an email automation.Inspite what I've attempted it continues to display all 13 numbers for "M1" calcuation. Screenshots attached.

Hi and thanks in advance for the help!I have multiple IF statements that I would like to include in one Formula field. Essentially what I want is the output to be in one formula column with the output being:Result from IF STATEMENT#1(line break)Result from IF STATEMENT #2IF STATEMENT #1IF(  {Requestor job level} = "Individual Contributor","🍅 Individual Contributor",  IF(  {Requestor job level} = "Performance Leader (Manager)","🍋 Performance Leader",  IF(  {Requestor job level} = "Strategic Leader (AVP+)","🥑 Strategic Leader"  ))) IF STATEMENT #2IF(  {Type of event} = "Keynote","🍅 Keynote",  IF(  {Type of event} = "Live Interview","🍅 Live Interview",  IF(  {Type&