Solved

Good afternoon! There are several product sections, each product has its own identification number. How to make the id is filled in automatically in a row (example P00005) and you need to save the number of characters (example, P00009. P00010)

Hi,I want to send forms to end users, using a link sent via mail.the link contains data that should be uploaded to the form with info relevant to specific users.I created the URL to the form successfully, but when I send the mail, the user receives it as a text and not hyperlink.the link to the form is very long, so I suspect that this is the reason it doesn't become active.Any Ideas on how to approach this issue?ThanksNitai

I want to send an email every day at 12:00 p.m. to each record that matches a specific criteria. Trigger: At a scheduled time Actions 1: Find Records Actions 2: Send Gmail When I run the application with the above settings, the email addresses of the target users are included in the cc and the email is sent all at once. How can I send each email individually?

I'm building a base that users can copy, and I notice all my tables, records, fields, and extensions copy over when I create a template of that base. However, I'd like the templated base to include the automations I built, plus the interfaces if possible. (Honestly, the automations are more important.) I've poked around the Community and even asked ChatGPT (which swears this built-in functionality is possible in Airtable, but I can't find it!).I see other topics in the Community related to duplicating bases (and thereby duplicating automations) but this base template will be set up for other users to use as a starting point, and they wouldn't have access to the backend of my Airtable system.Thanks for any guidance!

Hi, I've searched for an answer but haven't found anything posted recently. Thanks for any help.Simple question. I'm looking for records daily at 3 p.m. that meet certain conditions. If I find them, I send an email with the records. But is there a way to do nothing if I don't find anything that matches the conditions? Will the automation automatically abort if conditions are not met? I don't want to send blank emails. Thank you.

I have 2 tables each have one common column i.e website. How can I generate 3rd table which will be intersection of table 1 and table 2?Note: I am using airtable free plan

Hi I'm trying to use a nested formula to calculate a risk matrix if an entry has different conditions: F({ Platform product data sources (from Submissions)} =Platform Product/Data, OR ({Subproccessor (from Submissions)}=Subprocessor), ‘CRITICAL’,IF ({ Platform product data sources (from Submissions)} =HRIS (People data), "MEDIUM",IF({Platform product data sources (from Submissions)} =Commercial and Financial platforms/data, 'HIGH','low’)))But I'm getting a formula error, I'd appreciate any help on where I'm going wrong! Thanks! 

Hi all!I was wondering why ARRAYJOIN(values, "\n") is not working in my base.The only way I have been able to achieve line breaks is by creating a formula field.I added some screenshots!Thanks!

Hello!So i was wondering if it was possible to create a formula (or combine formulas) in order to use the data from one date field and add 7 days to it in another. and then filter it if the project status matches certain conditions.I got the first part to work using: DATEADD({Project Date}, 7, "days") which worked perfectly,  but im not sure if its possible to then have it say "not needed" or even have it be blank if the project type matches certain conditions and still show the date if it matches other conditions! I also tried this:IF(OR({Project Type} = "Wedding",{Project Type} = "Elopement"),DATEADD({Project Date}, 7, "days"),IF(AND(OR({Project Type} = "Couples",{Project Type} = "Family"),"Not Needed","Not Needed"))) which kinda worked but it only filled in the wedding date status and not of the other options. Let me know if that makes sense and if you can help please 🙂

Hello,I have a formula column where I dynamically build a string of characters. Everything is fine to build the new string.However, when I copy and paste (Command-C) the cell, I end up with a character " added at the beginning and end of the new string but also, by consequence, in the middle of my content if it detects a " character.It automatically doubles it! GrrrHow can I eliminate this problem? Thanks for your help. I am getting crazy.

I've seen some posts regarding this same issue, but no recent workable solutions so I'm posting again. This automation hasn't run for a few weeks (since June 😎 and no changes were made but it's no longer working. The step failing is sending an email. I get a message: "An attachment url is disallowed". The entire automation goes like this:1. When X form is submitted (including Z attachment)2. Find record (where record ID matches record ID)3. Send an email to Y email address with Z attachment (from X form submission). File format is pdf if that mattersSteps 1 and 2 run just fine...it's step 3 that throws the "An attachment URL is disallowed" message.Nothing has changed to the automation or the file format.What I do notice is a change in the URL of the attachment.This is the URL (incomplete) of an attachment when it was working on June 8. The root of the URL was cdn.filestackcontent.comThis is the URL of the attachment uploaded in the failed attempt. The URL room is airtable-attac

I have two tables that share a linked field. Example data:Table 1:FRUITSTATUS (single dropdown)REVIEWS (linked)ApplesIncomplete[1] [2] [3] [4]OrangesIncomplete BananasIncomplete AvocadosIncomplete Table 2: REVIEWDATEFRUIT (linked)OUTCOME11-JulApplesFail22-JulOrangesFail33-JulApplesFail44-JulApplesPassThe data in Table 2 is created using form.I'm trying to update the STATUS field in Table 1 to "Complete" when a form is submitted with a passing outcome for a FRUIT. So in this case, the STATUS for the "Apples" record should have been updated to "Complete" on 4-Jul.I've been trying this using an automation with the following settings:Trigger: When a record is created. Table 2 is selected.Conditional Logic group == If OUTCOME is "Pass". Within that logic group, I have an Update Record action item. Table = Table 1, Record ID = REVIEWS (the linked record), Fields = STATUS > Complete.The trigger is able to find a record and the conditional logic is able to pass the

I have a "Person" table that has birth date. On another table, I lookup that birthdate to find the person's current age when "Event" happened. Next year, a new "Event" will have different age for the person (as they are a year older). But I need to know what age they were at each "Event"So how do I create a column of ages that are dynamic on entry, but don't change once they are entered?

I want to have my date of payment updated automatically to the next month whenever it is reached but I am having some issues with having it to work. I already have a trigger that executes emails once the date of payment is a week to or has been reached.

Hi there, thanks for taking the time to read my question! New to Airtable and it's formulas - what I'm trying to do is create a simple Hours of Operation setup where a user can select the days of the week a business is open (stored in Open Days), add the open hours for each day, then combine the values to show the complete hours of operation (combined in Hours of Operation field). I'm starting with just Monday and Tuesday and I don't seem to be able to put two IF formulas within the same record. Only the Monday IF/FIND formula works and not the Tuesday. If I delete the Monday portion and leave the Tuesday, then the Tuesday portion works. That's what makes me think that you can only have a single IF formula (as well as nested IFs) and not more than one. I included screenshots and my formulas. If there's a better way of doing this I'm definitely open to that.Formula in "Hours of Operation" field:IF( FIND("Monday",{Open Days},0)=1,"Monday "&{M-Start}&" - "&{M-End}, "Mond

Hello! I'm new to Airtable and trying to create a formula field based on a date field. The formula should add 1 year to the date (the easy part), then round up to the half year beginning January 1 or July 1. For example,  5/15/23 would calculate 7/1/24; and 10/2/23 would calculate 1/1/25. Any and all help is appreciated!

I've already updated some fields using the Airtable API, but never in a multiple select field. Right now I need to update a multiple select field using Airtable API. For this, I'm implementing the following code in a script action on an automation.let inputConfig = input.config();let recordId = inputConfig.recorId;const update = {"fields": {"Testeee": [{name: 'A'}, {name: 'B'}]}}let myHeaders = new Headers();myHeaders.append("Authorization", "I_PUT_MY_VALID_TOKEN_HERE");myHeaders.append("Content-Type", "application/json");let response = await fetch(`https://api.airtable.com/v0/{baseid}/{tableid}/${recordId}`, {method: 'PATCH', headers: myHeaders, body: JSON.stringify(update)});let res = await response.json();console.log(res);*consider that the fields {baseid} and {tableid} are correctly filledI'm receiving an error when I try to run it. The error is:type: "INVALID_VALUE_FOR_COLUMN"message: "Cannot parse value for field Testeee"I've already received this error o

Hi I cannot figure out how to, if it is even possible, to update a specific field ( which is currently blank ), with specified text, which is appended on to the back of another fields data, within the same record, when a third field matches a certain condition. A bit of a tongue twister, apologies. For example :I have 3 fields, namely status, name and surname.First field :  Status Second field : surname Third field : left blank The first field ( status ) is populated with Awaiting order completion. The second field ( surname ), is populated with deer.  Every time I change the status to order complete, I would like the third field ( which is blank ), to be auto populated with the second fields data ( surname ), deer in this instance, and have specified text appended. Therefore the third field should look like this : deer specified text. Can anyone offer any guidance on this please ? Hopefully this is not too confusing. Trying to use arbitrary

Hey guys,I'm trying to set up an easy way to track budgets within my club. There are multiple subteams in the club with each their own budget, and I want them to be able to submit orders to me so that I can place them and then have a live update on a total of how much each team has spent. I want it set up where if I select a checkbox, that means that order price gets added to the total spent in another tab.I am running into the issue where if any of the checkboxes are selected then all the payment totals get summed at once rather than just the singular order I checked. Also, if I ever uncheck a box, I want that to also be reflected. I'll leave a video below with some of my issue to clear it up.

Title pretty much says it all.  I found the article covering how to create a GCal automation in general.  I don't see anywhere in here where you can specify that, for instance, all invited attendees should be able to edit the event or add more attendees.  From what I can see playing around in GCal's native web client, you can set a default property for the client that when creating events in any calendar you have access to, it should use a particular setting for attendee access level:This is a "General" setting, not a setting belonging to any of your individual calendars.So I'm pretty sure if you wanted to have events get created with any setting other than making attendees read-only, that change needs to come from the client side, i.e. AirTable needs to enable choosing this setting in the Automation.

Hi! I am looking for a formula to calculate the school year. I have a date field that I want to use. The formula I thought would work is not working. Please see below: IF(AND(Date>“08/15/2021”, Date<“06/30/2022”), “2021-22 School Year”, IF(AND(Date>“8/15/2022”, Date<“6/30/2023”), “2022-23 School Year”, IF(AND(Date>“08/15/2023”, Date<“06/30/2024”), “2023-24 School Year”, IF(AND(Date>“08/15/2024”, Date<“06/30/2025”), “2024-25 School Year”, IF(AND(Date>“08/15/2025”, Date<“06/30/2026”), “2025-26 School Year”)))))

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!