Solved

Is it possible to select records in scripting with specific conditions? If I wanted to get all the records that have a field value of green, how would I write that query? I don’t want to just get all the records; I want specific records with more than 100 results.

Hi, I am trying to automate an update of the “Date of Last Interaction” field in multiple linked companies (records) in my ‘Companies’ table with information from the “Date of Interaction” field in my ‘Interactions’ table when an interaction (a record) is added into ‘Interactions’. I was able to successfully update "Date of Last Interaction with the day the record is created/edited following this forum post. However, I want to update this with information pulled from the “Date of Interaction” field in my ‘Interactions’ table instead. I have attached some pictures and the code I used. let config = input.config let records = input.config().triggerRecords let table = base.getTable("Companies"); for (let record of records) { await table.updateRecordAsync(record, { "Date of Last Interaction": new Date(), }) }

Hi there community members I’m still new to airtable scripting and really need your help in solving the timeout problem on one of my scripts. I’m getting a script exceeded execution time on the following code. What can I do or how can I change the script to prevent it from happening console.log(“Start Ditribution script”); let inputConfig = input.config(); let leadRecordId = inputConfig.recordID; let tableLeads = base.getTable(“LGA Leads”); let query = await tableLeads.selectRecordsAsync({ fields: tableLeads.fields }); let leadRecord = query.getRecord(leadRecordId); console.log(leadRecord.getCellValue(“Lead Key”)); I see the 1st console.log, but not the 2nd, so I assume it must be happening when I’m opening the table. The table has a lot of records.

Hi Airtable Community! I am a new user on Airtable and I am struggling to split incoming data, that contains multiple data points contained in a single cell, into multiple rows. Example Below: Current format: | Household | Household Member First Name | Household Member Surname | HHM Age | | HH1 | John, Jane | Smith, Doe | 18, 19 | Desired format: | Household | Household Member First Name | Household Member Surname | HHM Age | | HH1 | John | Smith | 18 | | HH1 | Jane | Doe | 19 | Any ideas on how to achieve this? Thanks :slightly_smiling_face: Ryan.

How to automatically obtain the daily exchange rate and add the corresponding record in the specified table.

example URL = Sign in - Airtable example API = keyMYCOOLKEY This is what I have and what I am working with. The system that I have set up connects to the above URL and gets HTML back… Don’t know if that is correct, but the end goal is to retrieve JSON data for data import. The issue is that when I use the URL, it displays the HTML page but says it needs a login. At no time does it require my API key. A PHP curl test reveals : "Found. Redirecting to /login?continue=%2FappiKlBfTyvFfarTu%2FtbliOpnbcxQauIudo%2Fviw7uPlqwOjhTydwt%3Fblocks%3Dhide&redirectSource=liveapp" When I use a bogus app/tbl/viw, then it returns an HTML that says the page cannot be found. To summarize, the URL seems to be working that I have although it needs a login in order to return a HTML with the correct JSON data. How can I approach this, so that the correct data is returned while also using the API key? What I have done I tried using https://api.airtable/app… with curl and passing Bearer and the API key. This

Hi, i created a table for Purchase Orders (POs), and a sub/child-table for the Order Lines (OLs). Example: PO-1 OL-1 OL-2 PO-2 OL-1 OL-2 Etc What formulas or workaround do you recommend me to get a column at the OL table with the Order Line Number automatically starting again from 1 each time that the first line of a PO is created? Thanks in advance!

Hello. I am having some trouble with automations for email reminders. I am using the formula below to create the condition that will be used in the automation. When entering the start date and time, I can’t seem to enter this information quickly enough without either a) the date appearing as a partial of the real date (eg “9/1” instead of “9/16”) and thus triggering an email immediately, or b) the auto-populated time for the date (the current time) appearing and thus triggering an email. I can tell this is happening because the start time field appears in the email header as “9/1/2022” instead of “9/16/2022” for example. Is there any way to get the system to give you a few seconds to enter things before jumping the gun? Thanks! IF({Start date}, VALUE(DATETIME_FORMAT(SET_TIMEZONE(NOW(), “America/New_York”), “YYMMDDHHmm”)) >= VALUE(DATETIME_FORMAT(SET_TIMEZONE(DATEADD({Start date}, -30, “minutes”), “America/New_York”), “YYMMDDHHmm”)))

Hi there, I posted a topic earlier. When I edited it right after, the Akismet moved it into spam. Is there someone here that can please move it?

How do I get my projects (which is a primary field), to be linked to my tasks records? For some reason when I link two tables, they do not appear on the table to be linked. Here is the project tab, with the projects being the primary field Here is the Tasks field where the project field should be linked to I add the linked “tasks” field from the Tasks table And the linked field from the Projects table does not show up in the Tasks Table

I have a a base that has a set IDs (600+ unique IDs). I need to update their status’s weekly but the report to update has over 9000+ IDs. I only want to update my 600 without adding any other records to it. Is that possible with the CSV import extension?

I’m hoping someone can help me with a simple formula. I currently have a formula that counts the months between a start date and today’s date and displays it in months as whole numbers (ie, 2 months, 5 months, etc). The issue with just a whole number for months is that at 3 months and 29 days, it will show “3 months”, and at 3 months and 1 day, it will also show as “3 months”. A more accurate figure would be helpful. I also need the figure displayed in months, so the display in just weeks (ie, 9 weeks) or just days (ie, 52 days) wouldn’t be helpful in this case. I’m hoping there is a way to make it display in months with one decimal place (ie, 2.3 months, 5.7 months). I’d also settle for something similar such as “2 months 14 days” or even “3 months / 2 weeks”. I’ve tried using the formatting function within the settings and set it to “decimal” with a precision of “1.0” but it still just shows it as the whole number for the month with a “.0” at the end. For example, 3 months and 2 week

When I try deleting a record, it says “Unable to delete record. This table is configured so nobody can delete records”. Might it be something an administrator set? I duplicated the base and its still not allowing me to delete. Any suggestions?

Hey clever people, I got following single line txt fields in my table: {Prefix}, {First Name}, {Last Name}, {Suffix}. I already use a formula to concenate this data: CONCATENATE({Prefix}," “,{First Name},” “,{Last Name},” ",{Suffix}) … this works fine. My problem/question, is it possible to make a formula that will put between {Last Name} and {Suffix} a comma if {Suffix} is not empty/null, instead of the space like above. If I replace the space with a comma it will obviously be everywhere, what I don´t want. For example: Prefix (Dr.), First Name (John), Last Name (Miller), Suffix (M.Sc.) - Formula Result: Dr. John Miller, MSc. Prefix (Dr.), First Name (Leroy), Last Name (Thompson), Suffix (null) - Formula Result: Dr. Leroy Thompson I hope you understand what I mean :grinning_face_with_big_eyes:

Hi, we have a new collaborator that can’t add or edit any airtabels in the workspace. He has creator and editor permissions. Very frustrating, how do we fix it? We’ve tried logging in and out, as well as adding and removing him as a creator. Thank you!

I have set up a simple automation where the trigger is an email being put into a particular folder on my Outlook email system. This then triggers the creation of a task, taking some of the information from the email. It runs perfectly when you test it, so I then made it live and put 5 emails into this folder. Only 2 have come across as tasks - I simply can not work out why the others haven’t (I left it overnight, so assuming it isn’t a timing issue). Any help / pointers on this would be much appreciated.

I have a form with a cover image and logo. Up until today the images displayed properly, however now they appear as broken image. Additionally I have a small table with a few images in it and they are now also appearing as broken images. Is anyone else experiencing the same issue? I see some older posts where this was resolved but it seems to be happening again, at least to me. Re-uploading images has not helped either, it just ends up with the same result.

Hi, I want to create a formula field that will add a “$” to those number that doesn’t have that. I tried using different codes but I still haven’t achieved it, can you help me? Thank you!

Hi. I need to have a calendar overview showing two fields - a delivery date field and a publishing date field. What i am trying to figure out is, how am i able to delete the delivery date field entry, so whenever the date is the exact date of delivery i am trying to delete the delivery date field entry, so in my calendar the delivery date is not shown anymore - but the publishing date is still visible. Thanks in advance Martin

Hi everyone ! I am so sorry if my question has already been answered on this forum but I just spent my entire day trying to find a solution… I need to add some wordpress featured images on my Airtable database. To do so, I choose the Attachment field type and tried to add the url. Airtable is doing a great job downloading files, but it takes a kind of screenshot of the website whereas I only need the featured image (just a .png or .jpg file !). For example, if I take this url (https://lexpedia.fr/droit-administratif/arret-blanco-8-fevrier-1873/) and insert it in the Attachment type field, I will need to get the little girl image on a .png format. Don’t hesitate to tell me if I’m not clear ! Thanks by advance !

Hi! I have a slight problem that I don’t know how to solve: I’m working on some lists that need to be divided into different records. In this particular case, the lists that I was given contain the field “name” or “full name” but I need to divide that information into “name”, “middle name”, and “last name”. So, for example, if I have in one record the name “Amanda N. Pollard”, I need to divide that into Given name: Amanda Middle name: N. Last name: Pollard The extra complexity comes when not all people within the Company have middle names or when some employees have more than 1 last name. For example: “Jay Martínez Romero” which in this case would look like: Given name: Jay Last names: Martínez Romero Has anybody done this before? Thanks in advance!

Hi, I amm having a strange issue with MID(X,1,5) returning more than 5 characters and LEFT(XX,10) returning more than 10 :slightly_smiling_face: Is this a known issue ? Any clue to make it work ? See attached screens Valérian LEBERT digi-studio digi-studio Digitalisez votre entreprise avec digi-studio

I have 2 date fields and would like to calculate the midpoint between the two (as a date). I have tried a few the NGS bit not had any success. Any ideas?

Hello world I’m working on a budget base which requires a linked field to pull in cost data. It currently means manually searching for a linked record 20 times for each choir rehearsal (there are 10 venue costs, and 10 staff costs per choir)… And we have 19 different choirs to do this for (almost 400 manual ‘clicks’). I’m either being stupid and missing something obvious, OR it requires some form of scripting (in which I am clueless) or automation to make this happen automatically. Could anyone shed some light? Here’s a short video showing what I currently have to do. And here’s a link to an abbreviated version of the base. Any help would be hugely appreciated! Many thanks Curtis

Hello I use Integromate to use airtable data to send emails. When a form is filled, Make sends emails to the matching records from airtable. I use the following formula: {Vendor Country}=“Vendor country” If the form filler is also in my records. Make sends emails to the form filler. How can I exclude the form filler email from the emails to be sent?