Solved

Hi dear friends.I would appreciate your help regarding time differences.The clock should be +2 as you can see in the picture but for some reason when I do the formula it takes me back 2 hours and I couldn't figure out how to use the timezone formula.I would appreciate your help on how to write the formula correctly so that it works.Thank you! 

I thought I was being clever but my formula did not work. Cells are blank. Why?SWITCH(  {Decimal},  "0.75",  "3/4",  "0.50",  "1/2")

Hey friendsI have a column of customer full names.I would like to separate this column into 2 separate columns - one for first names and the other for last names.I used the following formula (screenshot attached) to separate the first and last names, but there is a problem:If someone entered only their first name without a last name, the column remains empty and I don't understand why.I would be very happy for your help in this matter!Thank you 

I am new here, so please forgive me if I ask a question that might have been asked before.I keep track of my software subscriptions with Airtable, some are monthly based and some are yearly. Therefore, I created a single selection field with two options (monthly, yearly) and a date field that shows when the subscriptions are due. Now I would like to automatically update the due date after it has passed under the condition of monthly or yearly. I had something in mind like: IF ({subscription} = "yearly", NOW(), DATEADD( *1, 'year')({subscription} = "monthly", NOW(), DATEADD( *1, 'month')I guess it's terribly wrong, since it never worked 😭 

My record has a field that's named  'Automation history' which is where i want my scripts to keep a log whenever it does some changes, i keep this to identify errors etc. But the issue is that it get's replaced, is there any way to .push that value there instead of overwrite? All the other code i want to keep as is.This is my code:  let createOpportunity = await tableOpportunities.createRecordAsync({    'Opportunity Name': orgName,    'Organization number': orgNumber,    'Company Type': orgType,    'Foretaksregistret': orgRegisterDate,    'Kommune': orgKommune,    'Postnummer': orgPostNummer,    'Automation history': "Record created at " + yyyy + '-' + mm + '-' + dd + " ,&nbsp

In the new Community app, is it not possible for authors of posts to edit their posts after they're published? Added 1 minute later: Hmm. I just now looked at the Comments Options and I found an Edit Post command. But that command isn't there for a post I published just a short while ago? What's the difference? Do I get just 120 seconds to edit it or something like that? 

For some reason I can't insert the fields from the Find Records step as a token in the email body. Am I missing something obvious or is this a bug? I tested the Find Records step and it successfully returns records and shows me the related fields

Hi All,I have a Calendar table within a base that we use to assign calendar events to Airtable users. We also share the calendar link with everyone so the calendar will populate on their iPhone calendar and such.  Because of this, we want to show what event is assigned to which user in the calendar event ID (labeled "Event" in the screenshot below).  We currently do this with a concatenate formula but it will show each users full name, which makes the Event ID very long.  Current Event formula is as follows and works fine: CONCATENATE(IF({Tentative?}=1,"(t) ",""),Project, " ",{Service Call}," ", RMA," ",Title, " ", {User (Assigned To)})In short, I can not find a way in which to swap out each users name for their initials in the form of custom text (not just taking the first and last initial from the users name since two users have the same initials "JR").  I am looking for some sort of formula to insert into my existing {User (Assigned To)} spot in the for

Hi. I,m trying to filter records using filter formula based on record_id. The field is not exists in the table, and we don't want to create formula field to have record ids explicitly. Is there a way to compose query formula to filter data by their record_Ids like this:AND(OR(SEARCH(",recctaxd2aq9fvtfj,", "," & SUBSTITUTE(LOWER(ARRAYJOIN({record_id}) & ","), ", ", ","))))Thanks in advance.

Can someone help me out.  I'm want Airtable to return the "Column name" after he compares 4 adjacent cells in the same row. I expected to be something like...if(@A>@B AND(@A>@C) AND(@A>@D), "A")if(@B>@A AND(@B>@C) AND(@B>@D), "B")if(@C>@A AND(@C>@B) AND(@C>@D), "C")if(@D>@A AND(@D>@B) AND(@D>@C), "A") Thanks in advance!

Hey guysI have a brain drain problem with how I should set up a dynamic date formula, I have 2 tables in a base, one for odd weeks and one for even weeks. They both just contain 5 records, one for each workday. I have separate fields where the current date is shown, current weekday, current week number and if the current week is odd or even (it shows 0 for even and 1 for even). Now to the tricky part.I want to show in a field in the even table (week 50), lets say today Wednesday the 14th of dec. I want todays date to be visible in that field, on Tuesday the 13th should be visible and on tomorrow the 15th and so on. And I also want if the dates in the odd table shows next weeks date, and then when it becomes an odd week the even table updates the dates to the week after the odd. Any of you geniuses have a solution in mind?

If I embed a view on a website and leave the "Show view controls" enabled, then a visitor adjusts a filter or sort criteria in their browser, does that impact other viewers? Or are the view controls unique to that visitor for that browser session?Essentially, I want to know if one person changing a setting impacts the base itself, or just that visitor's experience.

Hello everyone,I am very new to scripting, so hoping I can get some support here.In short, I am trying to use the "Find Records" automation action to get a list of records, and then pass that list onto the script to delete them. Below is what I have but am getting "TypeError: Invalid arguments passed to table.deleteRecordAsync(recordOrRecordId): • recordOrRecordId → recordOrRecordId should be a Record, not undefined or recordOrRecordId should be a string, not undefined"I believe this is because the list is being passed to the script as a string, not a record, but am not certain that is the issue or how to rectify. Code is below, thanks in advance!let table = base.getTable('Milestones'); let inputConfig = input.config(); let recordsToDelete = inputConfig.RecordList; console.log(recordsToDelete); for (let deleteRecord of recordsToDelete) { await table.deleteRecordAsync(deleteRecord.id); output.text(`Deleted record for ${deleteRecord.name}`) }

Hello everyone, To begin with, sorry for my writing, I'm French and I'm not used to English yet.I'm looking to change the status of a column with a simple action, like a button or a formula but I don't know how to go about it.As you can see in the photo.I am eager to see your advice to carry out this action, thank you all!

Good morning everyone, I can’t seem to figure out the correct syntax for updating a Linked Field within a record. My test base is simple, two tables, a name field in each, and a linked record between the two. Table First Table Second Example of my simple script below. It’s odd that in the Airtable GUI users may paste text straight into the “Second” link and it creates the items in the Second table. But scripting requires the object/array to be formatted - which I’d appreciate a hand on. :pray:t2: let table = base.getTable("First"); let query = await table.selectRecordsAsync({fields: []}); let recordId = query.records[0].id; //Updating the Name works as expected await table.updateRecordAsync(recordId, { "Name": "Example Record", }) const data = ["Item 1", "Item 2"]; //Needing a hand to stamp "Name" items into the Linked Record. await table.updateRecordAsync(recordId, { "Second" : data }) output.text("Updated a record!");

When I changed the formula for a field, I got an dependencies notification saying that the change would affect a base that I "do not have access to," which was created by an "Unknown User."I'm the owner of this Pro account. There are only two other seats on it. How can there be an inaccessible base and an unknown user? Over time I've removed users who have left our office, and deleted some of the bases they created. Could this be what this notification refers to? I went ahead and saved the change, so I can't screenshot the notification.

Hi airtable communicty 🙂Here is a small challenge I face.I created an inventory for an auto shop. How to show the last price added for the product? Example: Product AA - we bought for $10Latter with $30And after a couple of weeks price decreased to $20 Now I can make only average or max. Here is a screenshot how I made MAX value added for this product.I found a formula like LAST_MODIFIED_TIME() But I don't know how to use, to display last price of product addedThank you  

Hello, I’m reading documentation here on the rate limits for the Blocks API and I’d like some clarity around these two statements: Batch methods ( updateRecordsAsync , createRecordsAsync , deleteRecordsAsync ) may only update/create/delete up to 50 records in one call. Additionally, writes are rate-limited (maximum of 15 writes per second). Your app will crash if this limit is exceeded. Two questions: What is a “write”? Does calling a batch method count as 1 write? Assuming that a batch method counts as a single write, does this mean that it’s possible to update 750 records a second (15 batch methods a second * 50 records per full batch) via the Blocks API Many thanks

Hello,I have an automation based on a button click that creates a number of records in a separate base based on what is selected in a multi select field. The automation itself works well, but I am having an issue with people accidently clicking the button multiple times and creating duplicate records. They do need the functionality to run the automation if the multi select field changes, though.My thought was I could use the now() function in a field to essentially create a "Button last clicked" field, use a formula to compare that to the last time the multi select field was modified, and then use that formula's output as a conditional check for an action within the button automation.The issue I am having with this approach is around the now() function, the field only seems to update every 10-60 minutes. So within those 10-60 minutes, the check doesn't work and the button can be clicked multiple times.Is there a better approach to this? A way to work around the now() function providing

I filtered a column in my grid view spreadsheet and all the data went missing. The first time it happened I was able to undo and got it back. The second time, however, I was not able to undo.I know the data is still there because it shows when I click on the Kanban and Gallery Views.Does anyone know what could be going on?

Hi, I'm trying to do an inner join (find elements in common between 2 columns).How can I do that here?I saw the functions Concatenate and Arrayjoin, but I didn't find anything about Inner join, maybe I'm looking in the wrong place. Is it possible to do it? Thank you😊 

Hello all, I am trying to figure out if it is possible to a column in Table1 show matching names from Table2 based on those names falling into a date range specified on Table 1. I'll try to explain further:Table 2 will have the data:Entity | Start Date | End DateAnd Table 1 will have 4 columns:Person  |  Start Date  | End Date | Matching Entity from Table2For example, where Person 1 on Table 1 has a date range that overlaps with more than 1 Entity from Table 2, the "Matching Entity" column on Table 1 will list all Entities whose date ranges overlap with Person 1 (E.g. - "Entity1, Entity3, Entity 6")Does anyone know if there is some way of accomplishing this with Airtable? 

My end goal is to calculate the Flesch–Kincaid readability of a given text field ("Copy (Required)"). In order to do that, I need to determine how many syllables are in that text.Syllabification is somewhat of a subjective thing, but the approach that I've chosen is to use a series of nested REGEX_REPLACE functions inside a formula field based on this approach from Guilherme D. Garcia. The resulting formula looks like this: REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( REGEX_REPLACE( {Copy (Required)}, "([aeiou])", "\\1-" ), "-$", "" ), "-([bcdfghjklmnpqrstvxz]$)", "\\1" ), "-(n|r|st)(t|n|d|f)", "\\1-\\2" ), "([aeiou])-s([tpnml])", "\\1s-\\2" )  I know that Airtable’s REGEX functions are implemented using the RE2 regular expression library but I can't seem to get the syntax correct for the "replacement" string. For refe

Hi, I want to send emails to my customers using the Gmail automation and I was wondering if I can somehow change the direction of the text to RTL (the mails are in Hebrew)

I have a zap that pushes 3 cells with comma-separated values, the first one being the part or service names, for example [trip, labour] the second cell is the quantities [1, 3.5] and the third one the prices [60, 120] to our invoices table.How can I extract that information and create a record in another table (line items) every time  a new record is added to the Invoices table.