Solved

I have two lookup fields that are an array inside my table. One shows the number of products (30, 30, 30, etc.) and the other show the name of the products (product name 1, product name 2, product name 3, etc.).If the fields have just one product, I can easily concatenate them into "number" & "name" (e.g., 30 product name 1), but that doesn't work on multiple arrays. I'm trying to combine the fields such that the output will be number and name in order (e.g., 30 product name 1, 30 product name 2).It seems like ARRAYJOIN() into a list is the appropriate function, but I can't get it to work. The formula of IF(  ARRAYJOIN({number}),  "- " & ARRAYJOIN({number} & {name}, "\n- ")) produces "- 3030product name 1product name 2" instead of "- 30 product name 1 - 30 product name 2." Any ideas? 

This seems like a very basic question but search hasn't yielded me an answer.How do I set a field with spaces in the name using a fetch() request?  const res = await fetch('https://api.airtable.com/v0/xyz/Estimates', { method: 'POST', headers: { 'Authorization': `Bearer ${process.env.AIRTABLE_TOKEN}`, 'Content-Type': 'application/json' }, body: JSON.stringify({ "records": [ { "fields": { Client: [client.id], JSON: escapedJson, Total: total, Screens: screens, Outside Only: flags.outsideOnly } }, ] }) });

(Thank you in advance! I swear I've tried everything I could find here and no luck)I'm running a (successful) Create New Record automation from a Synced table, so my teammates can use the source data to develop their own additional work (but not adjust the source data itself). Yes, it duplicates a record -- but it's the only way I can deliver the starter content and let them build on.Next step is to run an Update Record automation, so when:Source data record is updated, thenMatching created record is also updatedTrigger (successfully finding the updated records in Source data) & Actions ("received invalid inputs") screenshots attached.

I have fields for "First Name" and "Preferred Name." I want the "Preferred Name" field to default to the value in "First Name," but still be editable if a different preferred name is desired. I also want to implement a similar approach for the mailing address, where the "Mailing Address" field defaults to the value in the "Physical Address" field but allows for easy editing when needed.Any ideas on how to achieve this without duplicating fields? I appreciate your input and suggestions!

I am designing an interface that contains a grid. I attempt to reorder the grid columns by grabbing the dots to the right of the name and manually reordering, but after changing the order it snaps back to how it was originally. I am not sure whether this is a bug or not. It occurs in the standalone Airtable Windows app and web based chrome.

This feels really silly but I can't get the LEFT, MID, RIGHT, functions to work with variables at all. It just keeps giving me an error no matter what I try. It works with a string in the function but not if I use a variable. Can someone tell me what I'm missing? I'm sure it's something simple...//Formula that doesn't work: LEFT({Text Phone}, 3) => #ERROR! //Formula that does work: LEFT("123456789", 3) => 123

Hello, I have a field that is using a formula in order to create a url. the formula is a concatenate to build a url to a form with prefill value. I then want to use it to send a email with gmail. And little thing I do not want to print the url but replace the text with “click here” I tried several things : in the body of the email [click here](record(step1…) I change the formula in the field it self in order to format. the field is ok in the table but when I send it the URL is there and the markdown is not interpretated… I realize that my URL : https://airtable.com/xxxxxxxx?prefill_First+name=Alexandre&prefill_Last+name=Husset&prefill_Email=alexandre@husset.fr&prefill_LinkedIn+profile=https://www.linkedin.com/in/alexandre-husset-61181a/ all the _ just disappear in the email https://airtable.com/xxxxxxxx?prefillFirst+name=Alexandre&prefillLast+name=Husset&prefillEmail=alexandre@husset.fr&prefillLinkedIn+profile=https://www.linkedin.com/in/alexandre-husset-61181a/

We are working with different clients on different Airtable bases. Also internally not everyone is working on every base. We do not want to change this (and include all client data in one base) also for security reasons.But for Management I am trying to do a Base/View/Interface where the Management Team can access e.g. all upcoming campaigns for all clients, without clicking through multiple bases or tabs. Meaning this base should be feeding from all existing client bases. Being able to make changes in this base is not prio 1 (but would be a nice to have though). All bases would have the same setup/columns based on the same templateIf I would sync all client bases to e new tab within my "management view base", would Interfaces allow me to show everything at one glance?Is this possible and if so, how would I do it? 

Hi folks, I know you can prefill dates in forms using URL functions. In this case, I don't need it to happen in a form, but on new record creation. I can use a formula for "today" - but it's uneditable for the small number of instances where it needs to be overridden. It's helpful to have "default values" for number fields, but it seems weird there is no default for date fields. Surely I am missing something obvious?

I'm trying to return a value if the date matches any of a string of dates. I'm trying to make sure dates don't land on company holidays. Thanks!

Hello--I have a base filled with content that we publish every day. I'd like a view where I only see content that is supposed to publish on a Monday though, but the options for dates don't have that capability. Any ideas on how to do it?  Thanks!

I have a long text field that takes the food and the preference of the user.Sample Input:Burgers (Enjoy), Pasta (Ok), Seafood (Nope), Pork (Ok), Beef (Ok), Vegies (Enjoy) I want to get all the texts that are "Enjoy"-ed by the user.Expected Output:Burgers, Vegies What formula can I use to get this output?

Thank you for considering to help me! Here's the process I'm trying to create:A new record is created via a form which will have a start and end date (i.e. 7/3-7/28)Based on the timeframe (above), I would like to set up an automation where additional new records are created (within the same table) for each week within that timeframe. (i.e. a new record with the dates 7/3-7/7; another record with the dates 7/10-7/14; another one for 7/17-7/21 and the last one for 7/24-7/28). There will be other fields that I'd like to copy from the original record as well. I'd like to avoid a script and just use formulas and automations, but am open to a script (although will need help writing one!) if that's the best/only option.Thank you!  

Hello,I am trying to debug why a certain script I wrote for automations failed because it takes more than the allowed 30 seconds. It seems that Airtable JavaScript environment doesn't support parallel execution of asynchronous tasks. Is that correct ? What can I don if I want to perform this kind of code: await Promise.all([ updateRemoteDB(), updateRemoteDB() ])Thanks,Yaniv

Apologies in advance if this is elsewhere or common knowledge or the query is posted in the wrong location (Formulas). I did look all around to find a similar Q&A elsewhere (found some close but none exactly what I was looking for), so...TWO sample use case needs for the following:1) Gardening: calculating when to sow or transplant a crop indoors or outdoors in relation to estimated frost dates.2) Annual Events (film festivals, awards shows) that occur at about the same time every year.Q1: How can I have a date withOUT the year? (reworded: How can I set up ballpark seasonal dates to faciliate copying over every year?)A-ish? I know I can do three columns (month, day, year) - but then I can't set up an annual calendar subscription, right?Q2: Is there a way to do a formula to calculate X# of weeks before a key date (i.e.: to add or subtract from the earliest frost date in a column).?Thank you!

Hello guys,I'm trying to create an automation that:When a new record is created -> Compare "E-mail" field with existing records -> If true, do something.The issue I'm facing is that: The automation is comparing the email to the contact being created instead contacts already created and always return "True" obviously.I'm I doing something wrong? Or is there any way other way to achieve this? Thanks in advanced

I have a problem using Automation to create a link between records in two tables.I have Table A and Table B.  Table A has a link field (’Link-A-B’) to Table B.  Table A also has a Form to create a new record in its table.  The form requires user to choose an entry into the Link-A-B field.  If the user selects a particular choice for the value, then the Form exposes another field in A (‘New Option’) that the user is required to type a value into.  Upon submission of the Form in this case—with a non-empty value in the’ New Option’ field—  an automation is triggered to create a new record in table B, and to enter the value of ‘New Option’ in A into the primary field in the new record in B. All the above I have working just fine in my Automation so far.  But the next action that I want to subsequently have happen in my automation is to change the link value in the Link-A-B field in the new A record: From what the Form user had selected, To a link to

If you share a read-only Interface, is the person with read-only access required to create an Airtable account? I wish to share an interface, but I don't want the read-only user to create an Airtable account and login each time they have to view the Interface.

I have a table called “Plans” that pulls in lookup values from my “Contracts” table, which is linked. I’ve been able to add the standard fields from Plans to a Page Creator page without an issue. However, when I try to add a lookup field from Plans, it doesn’t work. I can drag the field to the Page Creator, but the box never gets populated. Similarly, If I try placing a linked field on the page, it appears as a black box with its original field name from the Contracts base. See screen shot below. Any suggestions for getting the linked/lookup fields to work in Page Creator?

I have a formula that is achieving 2/3 of my goals, but I need some help figuring out that last 1/3! I am trying to add an "SOS" flag to any to-do that meets one or more of the following criteria:Has been manually flagged as "Behind" in the Alerts column.Has not been given a Due Date (so the Due Date field is blank).Has a Due Date that has passed AND it has NOT yet been marked as "Done."How would I structure that final part of the formula? Currently, I have: IF(     OR(          Alerts = "Behind",          {Due In} < 1     ),          "🆘",          "")I am trying to get the "Post job description on social media" task to be flagged, since it is overdue and not marked as done.Thank you so much!   

Seeking to identify if two numbers match exactly in both fields, such as 22 matching 22, and not partial matches like 2.  

I would like to separate a look up field (values separated by commas) into separate cells. I have information from Table 1 linked to Table 2 (Junction Table) that is linked to Table 3. Table 3 has a look up field (puling information form Table 1 to Table 2 into Table 3). The values in the look up field are separated by commas. (I am having a problems applying formulas to the look up field). Is it possible to separate these values into separate fields?

I just found out that both SET_LOCALE and SET_TIMEZONE functions returns an incorrect hour, at least for Europe/Lisbon and en-gb as per the below examples:SET_TIMEZONE(NOW(), 'Europe/Lisbon')SET_LOCALE(NOW(), 'en-gb')Both these functions as returning 1 hour less than the correct one.

Simple thing I'd like to do: Display the current date (and possibly time) on an Interface screen (blank template).  I created a field in the base that shows the date, but there's no way to display a single field.  I looked at the text object but there's no way to enter a formula in that object.Anyone accomplish this before?  TIA!

Context Unable to create an automation in Airtable. The path is as follows: An update in the "Sleep" field of Table1 triggers a search for records in Table2 that share a common field (using the "Name" field as the link). The automation then uses a script to update the corresponding records in Table2 with the updated "Sleep" content from Table1 into the Table2 fields, that have the same name, "NewSleep."Automation Path Image Below:My script is producing an error "'recordtoUpdate' is declared but its value is never read.(6133)." I believe what this means is the script doesn't understand or have a value it interprets from Table1 "Sleep" and therefore cannot update the the field of "NewSleep" for the records that have the corresponding name. Script:let records = input.config().recordslet table1 = base.getTable("Table1");let table2 = base.getTable("Table2")let newsleep = table1.getField('Sleep')for (let record of records) {let recordtoUpdate = await table2.selectRecordAsync(record