Solved

Hi All, I'm working on a base that needs several fields to be adjustable to display a date or text. Right now the date is being pulled from some formulas but the text is an option should the user need to add a note there instead. I'd really like to keep this all in one field instead of having a date field and a note field since this is duplicated across several different date fields. I can't figure out how to add a step to the formula to first check if something is text vs a number. Any suggestions?   

Hi there, Apologies if this is a bit elementary: I've created a URL field in a base, and I want to create a button in an Interface that will reference the link inside it and when clicked, take you to that page in a new tab. However, whenever I click "Go to URL in Record" option, it says unconfigured source and nothing comes up.  How do I fix this?  Thanks, Peter

Is there any option available to integrate Airtable and Amazon S3 Bucket for transferring data to and fro? If yes. please guide me with third party tools as well as how can I create by myself.

Hi there,I have a table which has all of the raw data from form submissions. I want to run some automations to change the format of email addresses, home addresses etc. However, I don't want to replace the raw data with the cleaned version, I want to have a table of the raw data and a table for the cleaned data. I want to clean the data as the forms are submitted. Is there a way to sync the data such that any new form submissions in Table A (raw) get put into Table B (cleaned), but which would allow me to then run automations and edits on the data in Table B without editing any data in Table A? Thanks!

 I have created a webflow logic triggered by a form. The data of the form is sent to airtable. Currently receiving the following error: "error": { "type": "INVALID_REQUEST_BODY", "message": "Could not parse request body"however tests are running successfully. Please see below: In webflow's community someone said to check JSONlint and this is occurs: let me know if there is any additional information I can provide in order to clarify. Any help is appreciated! 

Hello, I have a problem with an automation that works intermittently. I tried to follow the errors one by one to try to understand why sometimes it works and sometimes not! First records are created in a table (A) from a “Typeform” form which also fills in a “Parent record ID”. Then the automation must update records on another table (B) found from the “parent ID”. There is no problem to create the records on Table (A). But the automatism which is supposed to update the table (B) does not always work… it drives me crazy! An automation that is incorrectly configured never works! An automation may occasionally fail for x reasons. But when it only works 2 out of 3 times… it’s weird. Note that these issues arose after the new “conditional actions” were implemented last week…not sure if it’s related. Have any of you had issues like this? Thank you for your help.

Hi Community,I have interface with many layouts and with most, I have to allow users to (+ Add Records )  but then if they x out of that window it still creates an empty record and links it! how can I prevent this behavior and still give users the ability to link and or create new records from that button? If users change their minds and decided not to create a new record and just click the X button without putting any data records still getting created! Appreciate any input

Hi Everyone, I am struggling to develop a formula to determine which position in an array another field is located. Here is my example: The Array of Trans# is 2239, 4539, 4792, 8912, 10394 I am trying to find a formula that says Trans# 4792 is in position 3, Trans# is in position 1, Trans# 8912 is in position 4, etc. I can use FIND to tell me the starting position of the string, but cannot figure out to determine which position Trans# is. Thanks so much in advance.

I want to show the previous email exchange I had with my contacts. “I want to create an Interaction table” with the following fields: (Number of emails, Total interactions, Last interaction, Last email received, last email sent) a. How can I connect my Gmail/Outlook to Airtable for that? For calendar events (google/microsoft): I want to have the following fields. -last time I had a calendar invite with someone -last time I invited them to an event -last time they came to my event How would I automate/formulate this so it appears on my CRM? Thanks in advance for your help!

Have spent the day trying to figure out what I'm doing wrong and I'm totally stumped. Trying to write a formula to populate a status. If a person's start date is today or after, and their end date is today or after OR end date is blank, return "Onboarding." If a person's start date is before today, and their end date is after today, return "Active." If a person's start date and end date are in the past, return "Alumni." Those are working fine. BUTI also want to return "error" when there is something in the start date and the end date is empty. In my table there are two people with a start date, missing an end date, and it's returning "Alumni." Formula pasted below...Help! I'm new to writing formulas and I'm going totally cross-eyed trying to figure this out. IF(    AND(      {Position start date} < TODAY(),      {Position End Date} < TODAY() 

Hi AT Community,I'm creating an automation email within Airtable that uses percentage field data from my table.  I have set the precision to one decimal place (1.0) in the field column. However, when testing the automation, the preview shows that the token data percentage with 10 decimals (1.000000000), which looks ridiculous. Anyone know why this is happening? I know the workaround is a single-line entry, but I'd prefer to be able to enter the data as the percentage number, as that's how the information comes to us.Appreciate your help!

Hello!I'm creating a base that will capture all of my sales. The base consists of a customer table, products table, sales table, and I'd like a goals table. Ideally, the goals table would be have a column for the month/year, my goal amount of sales for that month, the actual sales made, and then a column that tells me how far from (under or over) the goal I am for that month. Similarly, I'd like to do the same for yearly goals, where it can show me the yearly goal total (based on the sum of each month in that year I'd set), what my actual sales for the year are, and how far from my goal (over or under) I am. My sales table already captures mm/yyyy and individually the month & year for the date of the sale so I'm pretty positive I can link a sale to the monthly goal record based on that month/year field with an automation.I'm just hitting roadblocks with how I show both monthly and yearly in the same table. I'm sure I can do a view to show me just the monthly or just the y

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