Solved

Hi there, I’m using this script by @Justin_Barrett to batch duplicate some records: This is what it looks like:: let table = base.getTable("TaskLog"); let query = await table.selectRecordsAsync() let checked = query.records.filter(record => {return record.getCellValue("Copy") === true}) // Make new records based on those that were checked let newRecords = [] for (let record of checked) { let newRecord = {fields: {}} for (let field of table.fields) { // @ts-ignore if (field.isComputed || field.name === "Copy") continue let value = record.getCellValue(field.name) if (value === record.name) value += "" newRecord.fields[field.name] = value } newRecords.push(newRecord) } while (newRecords.length > 0) { await table.createRecordsAsync(newRecords.slice(0, 50)) newRecords = newRecords.slice(50) } My question is: How should I edit this script so that after the new duplicate records are create

I’m reposting this request because my original was closed 15 days after a single reply by a Mac user who suggested a solution that is Mac specific (thanks for the suggestion, though) that didn’t translate to Windows because as speculated, it maps to the Switch Applications hot key combination (). So let’s try this again and hope that some with Windows experience replies within 15 days. I’m on Chrome (latest) on Windows 10 (21H1). I cannot find a key combination that will move the cursor out of a Long Text field. The usual suspects including Esc, “Tab” in various combinations with Alt, Shift and Ctrl don’t do it! I hate having to take my hands off the keyboard to use the mouse just to move to the next cell and then try to find the “home row” on my keyboard accurately with barely perceptible index finger markers. Thanks in advance, /Gerard

I’m looping over some records and want to increment ‘i’ ONLY if both conditions below are met: let i = 0; for (let record of taskRecords.records) { if(id.includes(record.getCellValue('ID Lookup')) && record.getCellValue('Stage').includes(stage)) { i++; } } console.log(i); My problem is the second condition. The cell value of the field ‘Stage’ is “This is just some dummy text | this is a string” and it’s searching for “this is a string” (this is called ‘stage’ and is a string from a previous step in an automation). i remains 0 in this case. Can anyone explain why includes doesn’t work on the second condition? Thanks!

Hi, (TL;DR "it triggered on all new records, no matter if conditions are met, when they include formula field) I have following issue: table1 (near 1500 records) has button field “Confirm match”. when a key pressed, the record partly copied to table2 (by my script, ~500 records), linked to it’s “parent” in table1 table2 contains formula field “Control”, relying on some data including lookup from linked record in table1, result is “OK” or “_error” “_error” records supposed to be removed, from time to time. I can’t filter at this step, because sometimes “OK” record in table2 may become “_error” after table1 update. it’s usual process, and it worked as expected. Now I decided to automate cleanup for table2 and setup new automation “When record matches condition”, second step is Remove record, where Control contains “error” (by way, I was surprised that Remove action is not available, i did that by scripting) The problem is that trigger works on records, which supposed to be “OK”, while my

I am using the switch formula to have Airtable populate a numerical value into a cell based upon the input chosen from a multiple select option. Prior to this I was typing the amounts in and it was working properly. Now I have set up the switch to populate the cell and it works and puts the correct number into the cell that the formula was pulling data from, But now I receive an error message in the end cells. Why is this? The cell the formula was pulling from previous has the same numerical values showing in the cells, it is just being generated by the switch formula instead of me inputting it into the cell. Thank you for any guidance.

Hey folks, I’m trying to calculate the number of days someone has worked in a job. I’m familiar with the DATETIME_DIFF() function, which works great when you have a Start Date and an End Date, but what if you don’t have an end date? In other words, imagine that someone is currently in their position, therefore the field registering their end date is empty. The theoretical solution I came up with is creating another field with the formula TODAY(), and then, if the field for end date is empty, use the field for today to calculate the difference between today and the start date, and calculate the time that the person has worked. I’m having trouble with the syntax! Any thoughts be greatly appreciated.

I have slowly been developing a custom app that interfaces with several external APIs that supply additional data to airtable entries. I started out with the utility as an automation script - here I was able to use remoteFetchAsync() to avoid any CORS issues with my fetch calls. However, since moving to the custom app and React, I am having to go through the proxy at https://cors-anywhere.herokuapp.com/ to run my API calls (and avoid the CORS preflight errors). The issue is the proxy is only for development - I would like to either duplicate what it does myself or find a similar service that does the same thing. I am relatively new to JS and web development, so I am looking for a well documented solution that would be easy to implement in a few hours. Does anyone have any hints on where to look? Since Airtable has the server fetch functionality built in for scripts, is it also possible to use it in custom apps?

Hi there! I’m trying to do a fairly simple formula but it has quite a lot of conditions. I’m a beginner and not sure where I’m going wrong, could someone help? The board is a basic project overview. I’m trying to set a column to display “on track” or “overdue” depending on what the due date and status of the item is. My current formula is written like so: IF( AND(IS_BEFORE(Due,TODAY(), IF( OR( Status = “In Progress”, Status = “With Client”, Status = “Not yet started”, ), “Overdue!”, “On track” ))) Any help would be greatly appreciated! Meri

Hello! I’m trying to create an automation on Zapier or Airtable: Table 1 View 1 : All my Candidate Onboarded Table 2 View 3 : Job description Published I’d like to create an automation when a job description is published (table 2), send an email to the candidate who matches with “Expertise 1” or “Expertise 2” or “Expertise 3” of the Job description (table 2) is the same as “Expertise 1”(main expertise) or “Expertise 2” or “Expertise 3” of the candidate (table 1). Thanks

This is probably really simple - can someone please help with a formula… What I am trying to achieve: remove space after comma in a string Example of existing string: Kim Jones, Ted Jones, Fred Jones, Sam Jones What I am after is a formula to convert the above to: Kim Jones,Ted Jones,Fred Jones,Sam Jones I have up to 11 names in my string - any advice is greatly appreciated.

Hello, I’m trying to create a formula that returns a workday date after 4 days are added. How do I adjust the field that is feeding the data, and the formula itself to always return a date that is on a weekday? It returns an “#ERROR” every time I try one of the formulas below. DATEADD({Process Vetting Start Date},4,‘days’)) DATEADD(WORKDAY({Process Vetting Start Date},4,‘days’)) WORKDAY(DATEADD({Process Vetting Start Date},4,‘days’)) Thanks in advance

Hi. I would appreciate help with the following: I have the fields Country (required field), Region and Title. I need to concatenate these fields in different ways depending on which fields are filled. -If just Region is filled then Region, Country -If just Title is filled then Country- ‘Title’ -If both Region and Title are filled then Region, Country- ‘Title’ -If neither are filled then Country Thank you in advance for any help. Katy

Hi everyone, I have one “Status” column with different status; I want for each status to be linked to another status, slightly different in another column called “Client Status”. To do so, I wanted to use a Switch formula: for a status A, there will be a status A’ linked, as shown in image attached. I wrote this formula: SWITCH({Statut} ,“ :mailbox: Contact entrant - à traiter”,“ :white_check_mark: En attente de validation”,“ :arrows_counterclockwise: Offre en cours de traitement”,“ :1234: Offre validée → n° d’acquisition à créer (CAP18)”,“ :truck: Collecte à effectuer”,“ :date: Offre validée → collecte à planifier”,“ :truck: Collecte à effectuer”,“ :truck: Collecte planifiée → à effectuer”,“ :truck: Collecte à effectuer”,“ :computer: Collecte effectuée → prestations à faire”,“ :computer: Prestations en cours de réalisation”,“ :email: Prestations effectuées → livrables à envoyer”,“ :computer: Prestations en cours de réalisation”,“ :ok: Livrables envoyés → vérifier montan

I was wondering if it’s possible to add multiple filters in the Airtable API URL - I have figured out the way for one filter, but I am struggling to apply multiple filters. Here’s the URL I made, which has a single filter applied : api.airtable.com/v0/<BASE_ID>/<TABLE_NAME>?api_key=<API_KEY>&filterByFormula={City}="MUMBAI" The above URL works perfectly, but if I try to add another filter (using &), it shows errors. I am looking for a way to add these 3 filters : {City} = “MUMBAI” (field type = single line text) {Age} > 25 (field type = number) {Calculation} = “Ok” (field type = formula, result would be either “Ok” or “NA”) What is the recommended/correct way to add multiple filters? Your guidance would be very appreciated. Thanks!

I’m having trouble getting DATETIME_FORMAT to work, and I can’t figure out what I’m missing. My date field is in local time. I wanted to get week numbers from the date, which I have working fine, but it is seeing dates in UTC I think, and DATETIME_FORMAT did not work. Formula: DATETIME_FORMAT(SET_TIMEZONE(Date,'America/Los Angeles'),'MM/DD/YYYY') Referencing the red box you can see two entries with incorrect format. I’m a little stumped.

Hello- I’d like to create a formula that allows me to track expiration dates status (three possibilities): Due soon, but not within four weeks (blank value in table); Due within four weeks (“Yes”); Past due (“Late”) I’ve been able to create this with the first two status items, but not the third (“Late”). Here’s what I have: IF( AND( DATETIME_DIFF({Expiration}, NOW(), “days”) < 28, DATETIME_DIFF({Expiration}, NOW(), “days”) > 0 ), “Yes” ) Thanks!

This is not a question more so a time saving work around for anyone else that faced this issue. Scenario: We have a column of emails in the format of ‘firstname.lastname@domain.com’ We needed to break this down to their full name in one column but the standard UPPER and LOWER case formulas left the data looking ugly and wasnt great for merging into emails. Alas, this ugly AF formula is what I could piece together from various wild google chases. Enjoy I hope it helps you. REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX

Hi All - This will be my first post. I would like for our category row ‘Summary’ cell to sum the output of our number of work days driven by the following formula IF({Start Date} = BLANK(), “0”, WORKDAY_DIFF({Start Date}, {Finish Date})) The formula currently is working to output the numeric value of the number or work days, but AirTable ‘Summary’ does not recognize it as numeric and thus does offer the option to sum the results into the Summary cell.

Hey :slightly_smiling_face: I would like to save sensitive information in AirTable. Do you know a way to encrypt columns? Thank you, Frank

Hey there, I would love a bit of help with an issue I have been struggling with: I have large data set containing keywords / descriptive tags to describe/classify the designs on our webshop juniqe.com, they are stored on a table called Image Keywords in my base, whereas the designs they are related to are on a table called DESIGNS I wrote the script below to merge the duplicate entries in the keyword table, since these records hold much information other than the linked record to DESIGNS. I’d like to believe that the script does the following cycle through all the records and compare the current records main field to the others, using the field Name (EN) as comparison value (the keywords english translation) If a duplicate has been found, combine the linked records of both the instances the script has found, and write them back to the first instance Clear the linked record field of the second instance (the comparison record) and mark that record with a checkbox field called DUPE to in

Hi, I have a team with multiple departments. I want all my departments to be able to edit and update Contacts from their respective bases. Is there a way to do this? Thank you.

Hi everyone! I’m setting up an automation for my team that will send an e-mail for our stakeholders based on a trigger. Right now we already have a few similar automations running, in which the action is the airtable native “Send E-mail”, and it sends an e-mail based off our team’s outlook inbox. Now I’ve noticed that airtable also has an integration with outlook that allows for an action “Send E-mail”. So I’ve been wondering: what’s the difference between sending an e-mail with airtable “send e-mail” and Outlook’s integration (considering that I’ll always use an outlook inbox)? Thanks!

Hello, first of all, the Airtable API documentation is great. That said, closely following the example code, i’m trying to understand how I might do something functional with the retrieve method. Here is the example I am given from the API docs for my table ‘Users’ base('Users').select({ // Selecting the first 3 records in Grid view: maxRecords: 3, view: "Grid view" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record) { console.log('Retrieved', record.get('ID')); }); // To fetch the next page of records, call `fetchNextPage`. // If there are more records, `page` will get called again. // If there are no more records, `done` will get called. fetchNextPage(); }, function done(err) { if (err) { console.error(err); return; } }); What i’d like to do is wrap this example up in a function and return an array of all records. But I don’t see

Hi, I have landline and mobile numbers in my data base. If one of them is missing, i want to show the other, if both are missing, i want to keep it blank, and if both are full i want to concantenate them. This is my formula syntax but its not working. Can you please help correct it? IF( AND( {Mobile Phone 1} = BLANK(), Landline = BLANK() ), “Both Blank”, IF( AND( {Mobile Phone 1} = BLANK(), Landline = NOT(BLANK()) ), “Landline”, IF( AND( {Mobile Phone 1} = NOT(BLANK()), Landline = BLANK() ), “Mobile”, “Both” ) ) )

Hello, I’m trying to create a formula field that will return a value of “Overdue” or “In Progress” based on the values of 2 other fields: Writer Due Date and Status. Here’s what I’m trying to achieve: IF the Status is any of the following: In Progress, Awaiting Information (Outreach 1), Awaiting Information (Outreach 2), Awaiting Information (Outreach 3), AND the Writer Due Date is BEFORE the provided deadline, then the field returns “In Progress”. IF the Status is any of the following: In Progress, Awaiting Information (Outreach 1), Awaiting Information (Outreach 2), Awaiting Information (Outreach 3), AND the Writer Due Date is AFTER the provided deadline, then the field returns “Overdue”. How would I write this as a formula? Thanks in advance