Solved

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.

Hi Everyone, I’m trying to set up a Project management Tool for our CPA firm. Do we have any other CPA firms in this community who use Airtable to manage their workflow? what template or format do you use? Also can anyone give me a customer service phone number for Airtable. I can’t find it online. Thanks

I have a lookup field called “Jobs” that returns fields from a linked record. In my case these are job descriptions. It shows them as a comma separated list, e.g. “CEO, director, manager…”. I would like to convert the commas into line-breaks with a formula. But SUBSTITUTE(Jobs,", “,”\n") returns an #ERROR! What am I doing wrong?

Hey AirTable Community Me again, I am currently using Zapier and WATI. I have a base of all my Leads, sometimes, Leads are created twice intentionally. When a record is created in AirTable, I want Zapier to notice. Then Zapier will tell WATI to create a Contact based on the details. Then Zapier will also tell WATI to send a template message to the person. The above is easy enough. The problem lies thereafter, since I can have Leads with the same Phone number, I don’t really want WATI to create two of the same contact and send the same message twice. So my idea is that after a record is created in AirTable, I want AirTable to look for another Lead that has the exact same phone number, but not the same Lead Unique ID. If the result is TRUE, then do nothing. If the result is FALSE, then proceed with the rest of the steps. I am slightly limited to Zapier as a tool for now since the WATI integration with Integromat/make is a little “wonky” and unintelligent (or maybe I am wonky and unintell

Hello Everyone, I am having a methodology issue.I am working on a personal price tracking project, in my case, it is computer parts.  But I believe this could translate to almost anything. I have multiple tables, one for each component type (CPUs, RAM, Motherboards, etc).  These tables display the characteristics of the product. There is an additional table that is called Updates, the updates table links to each of the component type tables, and tracks, price, link to vendor and date the entry was added. What I'm trying to achieve, is on the components tables, I'd like to show the most recent price for each component.   I've read a few examples that people have said about sorting by having a Rollup of the date:max(values)  However, I'm not able to discern how I will retrieve the price if I did that.   Can anyone orient me toward solving this problem?  Many thanks

Right now I have a multiple select field as follows: The script I’m trying to run has already identified the record IDs of all records with “Split Invoice” as a status. What I’m trying to do now is to remove that split invoice status and leave the rest (For example Estimated, Invoiced, those can all stay). What’s the best way to do this? All I can think of is to create an array of all statuses except for “Split Invoice” but I’m not sure how to write the syntax for that either. Code below: let table = base.getTable("Items"); let queryResult = await table.selectRecordsAsync(); var rec_IDs = [] var rec_names = [] for (let record of queryResult.records) { try { for (let status of record.getCellValue("Status")) { if (status.name === "Split Invoice") { rec_IDs.push(record.id); rec_names.push(record.name); } } } catch(e) { { continue; } } } // Script operations go here // As a fin

I have a board where I track ice cream names and the flavours they come in. Names are self generated where are flavours are common names such as vanilla or chocolate and so on.I want to use the npm airtable code here:https://www.npmjs.com/package/airtableand what I want to achieve is if a new flavour is added to the list of flavours, I want to also add this new flavour to the list of options available on the Airtable multiple select field. I am trying to mimic the code here:https://airtable.com/developers/scripting/api/field#update-options-asyncconst table = base.getTable("Tasks"); const selectField = table.getField("Priority"); await selectField.updateOptionsAsync({ choices: [...field.options.choices, {name: "Urgent"}], });However using the npm package it seems these functions are not available.I also tried using Curl as below:curl --request PATCH \ --url https://api.airtable.com/v0/meta/bases/{baseId}/tables/{tableId}/fields/{fieldId} \ --header 'Authorization: Bearer {myToke

New to Airtable here and trialling to see if I can work out a solution for my department.I have two bases, one that tracks People and the other that tracks Activities. Within Activities are fields for 'Participants', 'Facilitators' and 'Guests'. Multiple people can be added to each field.I am trying to create an interface that shows a count of how many people there were across all activities in the participant's column. However, I can only seem to get it to count how many activities there were to have any participants, which is a different number.I can see the next trap would also be that, if I was able to get it to count items within a column, it would count them regardless if they were original or not. This is desirable sometimes but it would be good to only count unique entries across multiple activities because often the same people attend multiple activities. How do I effectively say "count unique entries within the participants' column for all activities"?

We use a long text, rich format, field for explanation purposes however even with the height set at Extra Tall a lot of text is still out of view. Is there a way to increase the height for certain rows or a way to inform users letting them know to expand the record to read more? Not all fields require the expanded height and we really want to avoid spreading the fields so far, as it becomes harder to read all other fields.

I am trying to use Airtable as a resource to build concert programs for a music organization. I have one table (called Compositions) that contains what will be a very large list of compositions, and each composition may have anywhere from 0 to 6 movements. The movements are currently input as text fields. I have another table called Program Builder where I will be selecting from those compositions and the movements contained therein.I have successfully linked the Program Builder table to look up compositions from the Compositions table. However, for any given program that I'm building I would like to be able to select specific movements of that composition, but not necessarily select all of them.For example, I have the composition Cello Suite No. 3 in C Major, BWV 1009 which has six movements: I. PreludeII. AllemandeIII. CouranteIV. SarabandeV. Bourrée I / IIVI. GigueSo for example, when I'm using my Program Builder, I can select Cello Suite No. 3 in C Major, BWV 10