Solved

Hello, Table 1= I have a list of workshops and a multiple select field "date" which allows me to record all dates when this workshop will be organized the next year. Each line has a unique workshop linked to several dates.I have another table, table 2 or program, where each line is built by a workshop given at a fixed date.I would like to automatically fill in the table 2. That is to say I would like to create a new record in table 2 when a date is added in the multiple select field of table 1.Is this possible? (I manage to create the record, but not to extract the value of the date entered in Table 1 to fill the calendar field of Table2). Many thanks for your help!

I’m using the following formula to take a record from one field to update a record in another field. IF({production Pipeline} = "Media Delivery", "Media Coordinator") & IF({production Pipeline} = "Ingest", "Media Coordinator") & IF({production Pipeline} = "Transcripts", {Assignee})Now I’m writing a similar formula but the record has multiple selections and there are too many combinations to use the same formula, so rather than use “=” I would like to use “contain” but I can’t find a way to express contains.I’m trying to get the formula to say  IF({production Pipeline} CONTAINS "Transcripts", Assignee) Is there a work around for thisI tried “!=” and “>=” and “<=” that does not return the desired results

Is there a formula I can use to convert a date (6/28/2023) to a text (June 2023)? It'll make it easy for me to group by that month.

Good afternoon! How do I display the number of days in a month in the table, excluding Sunday. There can be as many as four non-working Sundays in a month, as well as five.

Can any or all of these be done?Share an interface with people in my organization without the link being public facing, with navigation links to multiple pagesShare with people in my organization without adding them as a member of AirtableThe option to create a universal link that is not public facing and is only available to people within our companies web domain, ex: widgets.comUnlimited sharing with as many people in my organization as needed, with "view only" accessThe context is that I am creating a user research repository and exploring Airtable as a solution. It needs to be shared ideally without having to add individual users, and it needs to be a secure link.

I've posted the code below.What am I missing here? I'm trying to update the field 'Parent' with the Parent's record ID when creating records in the 'Child' table, but it says that it cannot accept the value provided...even though it's an array of recordIDs (in this case, just a single one).I even have a log showing that it provides the correct record ID, which it does.I appreciate any help anyone is willing to offer. let sourceTable = base.getTable("Parent"); let destinationTable = base.getTable("Child"); let query = await sourceTable.selectRecordsAsync(); let checkedRecords = query.records.filter(record => record.getCellValue("Transfer")); let recordsToCreate = checkedRecords.map(record => { // Get the record ID from the source record let sourceRecordId = record.id; return { fields: { 'Name': record.getCellValue('Name'), 'Parent': [sourceRecordId] // Pass as an array } } }); while (recordsToCreate.length

When I scroll down on a table in the Grid view when I have more records than fit on the screen everything scrolls back up to the top. See the video below.

Hi, I'm having a little trouble with a project.I have a table called "Report" with the report names, submitted by, email address, and attachments and another table (Contact list) with a contact list with just names and emails.My customers have to fill in a form, and this fill in the main table (report table). My question is, how can I check if the contact that submitted the form (submitted by) is already on the contact list? I would like to do like a checkbox, so I can link an automation to this column and send me an email with the contact information of people that have not been on the contact list.I can't automatically add new people to the contact list, because that table is synchronized to another base.How can I solve this problem? I thought about the function lookup, but I wasn't able to apply it. Thank you very much!

No idea, why my every attempt to paste data via the API fails.Now, I try to paste the complex string to the column of type "long string".Data sample:   ["https://app.clickup.com/t/123","https://app.clickup.com/t/456"]  When I paste it manually, it works fine and I see in the airtable.But when I push this data via the API, I get an error  ERROR: Your request is invalid or could not be processed by the service Cannot parse value "["https://app.clickup.com/t/123","https://app.clickup.com/t/456"]" for field tasks  PS: the same data goes to the google spreadsheet just fine.

Hello, I do have a table with 10k rows in it. The table contains WooCommerce orders (including the address from both the buyer and recipient). Each address has about 5 different columns (i.e. address, second address line, postcode, ZIP etc.).So what I need to do is to append both address types (buyers address and address of recipients) in the same columns. At the end it won't make any difference if it is an address from the buyer or recipient. All data should be in the same columns.So at the end there should around 20k rows in the table (containing the addresse of both buyers and recipients). I.e. row 1–10000 should contain the buyers addresses and in the same columns from row 10001–20000 the addresses of the recipients. How can I add 10k more rows and copy paste the values from the columns (recipient) in the corresponding columns of the buyer? Thanks a lot for help, Michael

Hi,I use n8n to do some automated data collection that i want to store in the Aritable.I get the current date in the n8n with the code var data = DateTime.now().toFormat('dd/M/yyyy'); return { json: {Date: data} } the output is  [ { "Date": "27/6/2023" } ]  The format seems to be valid, due to the airtable date documentation  As the next step, i add some extra data and append it to the table, i get the error Cannot parse date value "27/6/2023" for field Date  That is super confusing because the format is exactly as in the documentation: {name: 'european', format: 'D/M/YYYY'}  

Hello.  I'm new to Airtable, but have some experience in other db applications. I am creating an app to track trading.  I have a trade table where details about each trade are stored.  It also stores the result of the trade in a field called TradeResult.  I made a grid view where I summed TradeResult grouped on TradeDate so I know the total results for each day. What's the best way to display that in calendar view?  I'd like to be able to look at the calendar and see how each day went. And not to be greedy, but if I could display the weeks total result on Saturday, that would be perfect.Any help is appreciated.

Hi There! Fairly new to airtable - and loving it! Context: I’m in the process of developing an interface whereby users can view or create ‘parent’ records, whilst also being able to view and update linked child records. Currently you aren’t able to ‘create’ linked child records in an interface (unless you do them one by one), so I’m looking for a workaround to create those records via clicking a button in the interface to trigger running a script via automations. The script would work on basis of: For this record > create X no of linked records in ‘child table’ (X = numerical value in ‘no of child records’ field) Problem I know there are multiple script examples out there that deal with creation of multiple linked records (namely the script developed by @ Kuovonne in 2020)- but I’m struggling to adapt them to my use case as a lot are built in the scripting app, and throw up errors when using them in scripts within automation . Very much a scripting newbie so any help or pointers ver

I have this working formula to return 'Reaction Hours'...ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2) If the request and reaction times are equal, 0.00 will be returned (correctly).  But then I embed it in an IF statement (simply to prevent #ERROR outputs if 1 of the input fields hasn't been populated yet)... IF(AND({Reacted Date & Time},{Request Date & Time}), ROUND(DATETIME_DIFF({Reacted Date & Time},{Request Date & Time},'minutes')/60,2),"") Now it works fine apart from the situation where a zero is returned, in which case the result is empty/blank.  Both date fields are present, so the first part of the IF statement is triggering, but for some reason the 0.00 value is replaced by empty/blank.  Any ideas why?  

As the topic suggests, i'd like to create a formular field using the API and assign a formular value. The purpose is to use RECORD_ID() as a primary key for my records. I have made a call using the API to attempt to do this but i'm getting a validation error.I will be grateful for any pointers, thanks.

Hello. I've just started using Airtable today. I've created a database of workshops for my job. I have add a calendar view, which shows the workshop title and facilitator. It all looks great! However, when I subscribe to this calendar through Outlook or Google Calendar, it only shows the workshop ID. How can I also display at least the title, too?Thank you!

Greetings. i am having difficulty narrowing down the conditions for an automation. I want to activate this condition in my automation only if the name of a specific linked record contains the word “Conversation”. I could not make it work using the the linked record name, so i tried creating a Lookup Field that would just reflect the value of the Record name that i wanted. But it still does not work. Is there a way to accomplish this? Thanks for any help you can give!

Hello. I am setting up automation and need to program "To" to grab the emails from a field in my airtable base.  For example, when I need to send a report to just the operations department, I want to assign that report to that email group.   I use Outlook Email for the automation.   Here are some screenshots.   I can't get the automation to recognize a field I enter with the email addresses.      I tried a field using the addresses as one line separated by a comma and then tried three fields with a different email address in each.  Neither worked. What am I doing wrong or is there a better way to handle this? The PDF is generated by PDF Generator API if that makes a difference.  Thanks. Wendy

Hi,I have an event list that contains a Start Day column including time (needed in some instances, but often left as 0:00). As I would like a simplified view in some interfaces, I created a formula column to display the date without the time using the formula:DATETIME_FORMAT({Start Day}, 'DD MMM YYYY')However, the formula returns the wrong day, in fact Day -1. I imagine this is due to the 0:00 time being read wrong? Any suggestions to circumvent? Adding a formula to just +1 the day would probably not work for the events in which time is indicated.Thanks! 

Hello, I have a table whose fields are mostly file attachments. when I 'send record' via email, the attachment resolution decreases and images are pixelated upon zooming. Also the file names are being changed from the original names.Are there workarounds?

I have a field that links to another table (Initiatives) in my Budget table. In my interface, I'm trying to filter certain components by which ones have a certain initiative in that field. But, when I go to add an initiative to the filter, nothing shows up, so I can't actually filter by it.Does anyone know why this might be happening? Trying to use anything other than "has any of" seems to make me have to type it (and still nothing shows up), and I'd rather it be more like a drop-down.Thanks! 

For the Free version I only have 1 base for my social media calendar. Can i have 4 collaborators that can edit and comment without upgrading. This is the only thing I’m using Airtable for.

Hello, for the past few days, we've been getting fails on automated tweets. This seems like an error on Airtable side, right? Is everybody experiencing this now? This shouldn't be about crossed limits, as the limit is based on the connected account right? So it has to be that AT still uses the API v1.1 as opposed the v2.0 version?Thanks!

Hello Airtable world, We’re trying to extract customer’s names from a lookup field of a synced table where the names sometimes include a second name after the comma. Our data usually looks like this: John Smith Jane Doe, Terry Doe James Bond We’d like to be able to have a column that displays the following: John Smith Jane Doe James Bond So far we’ve tried the functions below, both returning and error. IF({Customer's Name}, REGEX_EXTRACT({Customer's Name}, "[^,]*")) LEFT({Customer's Name}, FIND(",", {Customer's Name}) -1) The number of characters is unpredictable both, before and after the comma. I suspect the biggest issue is that our primary field from which we’re hoping to pull information is a lookup field and not just simple text. Is there a solution to achieving this?

In my template table I have a lookup field that is formatted as currency. In the child table I have the same field with the same formatting, but I'm getting an "root must be a number" error when I run the script. I'm guessing this needs to be modified in some way because of the lookup field issue, but I'm not sure how: 'templateRate': c.getCellValue('Rate')