Automations

Hi,I have a table where people insert new records through an Interface, one of these columns needs to be unique.My issue is that i cannot stop people from inputting the same data by mistake through Airtable's Interfaces (so for example they need to fill the form  with "12345", but they write "21345" by mistake, and "21345" is already there in the database), so i want to catch this duplicate's existence afterwards by sending an email and performing other operations when it happens.Do you know if this can be done?

Hi,I created a base linked to a form that insert records. When a record is inserted or updated in my base, some automations are linked to perform actions. Everything worked fine till two days ago, now the trigger of the automations does not activate and actions are not performed, but they work fine when I do manual tests.Can someone help me? I have a free plan but all the things I use are included in that plan

Hi. I couldn't find any specific information related to this. We are currently looking into possible options to conver a Google-Sheets based system to something more thorough.  We want to make sure we do not hit any walls later on in the future, once the system starts to grow. For the Pro plan, there is a 100k automations limit per month.  If you perform automations outside of AirTable, using Make or Zapier, for example watching rows and then updating rows based on certain conditions - would these count towards AirTable automation limit? My intuition would tell me no, but I would prefer to be certain about this - as that way I know we always have a plan B if we hit the limit.

Hey, Is it possible to rate one record multiple times (1 collaborator to rate same recordmultiple times), and later on to show an average rating? And to do that with multiple collaborators? For example, restaurant review, Can I rate the same restaurant multiple times, and calculate the average rating for that particular restaurant? And that average rating to be a combination of multiple different ratings from multiple collaborators. I’m not quite sure how to do that… Thanks

I'd like to set up an automation to send an alert when two records have the same value in a date field.For example, Record A has a date of August 6.  Record B has a date of August 7.  Then the date of Record B changes to August 6 (same as Record A).Can someone please tell me if this is possible, and if so, how?

Hey guys,I have a lot of blog posts that I am trying to showcase on my website but I don't have the room to store them in the webflow CMS since I use CMS for a lot. I would like to avoid upgrading the website plan as my blog posts will eventually out grow the limited amount of CMS items webflow offers anyways. Is there anyway to view my airtable CMS items to my website WITHOUT storing them in the webflow CMS?Thanks!

I am trying to create an automation so that everytime a new record is created in the "link to another table" column, the SUM tag is automatically printed. This is because I am trying to do a cumulative sum but am unsure as to how to get it to automatically update and display the sum when a new record is created.

Hi! I’m not sure if this is possible and if so, how. But is it possible on Airtable to use a script so that when a record status changes, to get a popup to appear that contains information relative to that record and a confirmation button that will allow the base user to launch an action through that button (via webhook for instance) ? Thanks 

Good day!I have an issue with an automation that SHOULD populate a table from the above data. The records that don't have the little green star should still be used for the automation to populate this table:The first table has 6 records that aren't being populated and should, into the second image.The image doesn't show the trigger being on, but I checked one later for the test, and it still is giving the invalid input. Not sure what is incorrect. Any pointers?   

I have an Automation that is triggered by the appearance (in a new form-generated record in Table-A, {T.A-Rec.1} ) as having a non-empty value in a field {T.A- Field.1’}.  This {T.A- Field.1} is a link to a record in Table-B.Record {T.A-Rec.1} ALSO has a link field {T.A-Field.2} containing a link, {Ref.C.Link}, to a record in Table C.I wish to update a record in Table C, the record referenced by {Ref.C.Link}.  The field in the referenced Table-C record that I want to update is {T.C-Field.3}, also a link field to Table-B.  The value that I want to put into the {T.C-Field.3} in the referenced Table-C record is that of {T.A- Field.1’}, the link to that same record in Table-B.In my Automation so far, I seem to get the trigger to work OK.   But when I try to configure an 'Update Record' Action to update the {T.C-Field.3} field in the referenced Table-C record I get very confused about specifying what record/field to update with which record/field value.  Nothing tes

How do I automatically mirror data from one table to another in the same baseIn excel it's an = formula Essentially I have 1 table where I am asking managers to add their Initiatives and I want everything added to that table to automatically be copied over to another table in the same base where I will run calculations and extra stuff that I do not want my managers to be confused by.

I would like to have a number field that increments by one whenever the “most recent sale” date field is edited so we can sort products by the number of sales. How do I make an automation that does cellA+1 when another cellB is updated? edit: If anyone knows of a way to do this without a third field, I’d be obliged.

Hello! I have set up an automation that post events that are scheudled on the days they happen. The automation is working well except for the time always posting in UTC despite the data being formated for EDT across all users for this particular table. I have added photos of the date set up in the table, the automation, and the post. Would anyone have advice on how to have it post in the correct timezone? Thank you!

Hi there,I am relatively new to Airtable.  I enjoy this platform very much and trying to learn more to allow for more automation.  I am hoping someone could assist me in trying to do the following:I have made a view of our enrollments that need to be audited.  I am then setting up an automation to send an email at a particular time of the month for our audit team to pick up this data to audit.  I have tried two different ways but not doing really what I am looking for it to do.First, I created the view in my workspace and then tried setting up an automation to send to our audit team at a certain day and time.  However, it won't let me choose this particular view to send.Secondly, I synced my view to the training teams table and then set up an automation to send the email when a record is added to the view.  This works but it is only an email.  So they have to log into Airtable to view the data.  I was hoping to attach the view with the informatio

Hello world, I’m new to airtable and to this community and I think that I need your help :pray: I have a integer field (called “votes”) that is set to 1 when a record is created. I have a checkbox field which is not filled by default. I created this automation : When record matches this criteria = Checkbox is filled Then I want to update the record’s field “votes” by adding 1 But as it’s a integer field I can only “Add a number” :confused: Can you advice me on what should I do please ? Thanks :slightly_smiling_face:

Hi, How can I add Multiple Select option from other table?When a new record is added in "Services" I want to be added as an option.Thanks

Hi- So I know just enough to be dangerous. To myself. So thanks for any help you can provide.I am trying to time stamp records when the Status changes to Pending. I figured out the formula, but as soon as the Status changes from Pending to Published (the next step in the process), the time stamp goes away. I am trying to keep track of when writers submit their articles (marked Pending).Is there any way to keep that time stamp - even when the Status gets changed from Pending to Published? Is there a better/smarter way to accomplish this?Thanks for any help you can provide.

On the Pro Plan.I am using a simple automation to send emails to static addresses.  The process is functioning well and emails are successfully sent to any address correctly entered into the To: field of the automation.  However, there is one exception.  The process will not send to one specific email address (sales@xxxxx.com).  No email is ever received.  It does not go to the Junk box: Airtable automation history says the message was sent.  This is particularly odd because this is the email address used as the login for the whole account!  It is happening in several different automations.  In the attached screenshot the email to diane@xxxx.com was received.  There is no sign of the one going to sales@xxxx.com.  The automation history says it was sent.Any ideas?

I have an updates table with two forms.  One form is for instructors to upload their lesson plan to the main program table.  The other form is for program managers to make changes to records in that same main table.I have two different forms, with separate pre-fill form urls.  Screenshots are below.Whenever an instructor uses their upload form to submit the lesson plan, the link for program managers breaks.  Why is this happening?Thanks in advance.         

Hi Airtable community, Looking for some help with setting up a basic CRM. Context: This company runs multiple programs. 1 person can sign up to multiple programs Want to create 2 tables: Table 1: Sign-up forms: All sign-up form data sits here, there will be multiple rows per person in this table. Table 2: CRM: This table has one row per person. Each row/record/person links to that person’s forms in the sign-up form table. I have created a quick Loom video to explain

Hello Airtable Community,I am trying to run a script from a button in a table and have used the following guide:https://airtable.com/developers/scripting/examples/recordpickerhttps://airtable.com/developers/scripting/api/input (to optimize by filtering on a view)When the button is used for the first time, it takes a very long time for the script to run; subsequent presses are almost immediate until the next cache refresh, i.e. a few minutes ( then the user have to wait a long time again).Here are the measured times:Full table 8039 records: 1 min and 49 secondsView 97 records: 1 minute and 6 secondsHere is the very basic code:  let table = base.getTable("POI"); let view = table.getView("DA"); let record = await input.recordAsync('Pick a record', view); if (record) { output.text(`You picked ${record.getCellValueAsString("POI")}`); }  Do you know if there's another solution? I just want the script to run on a specific record. I can't use an independent automaton, b

Hi all,I'm looking to roll up a set of linked records into one total linked records field.I am building a sales CRM and have different recruiters being labeled for different phases. Below is an example of my "leads" database. All items in brackets are [linked records] to the recruiter tab, where i've build recruiter interfaces for them to interact with their current lead statuses and etc.For example:Prospect LeadRecruiter Phase 1Recruiter Phase 2Recruiter Phase 3Total RecruitersProspect 1[Sally][Jane][Sarah][Sally] [Jane] [Sarah]Prospect 2[Jane] [Sally] [Sally][Jane] [Sally]Right now, I can't get the "total recruiters" field to autopopulate based on linked records in phases 1, 2, and 3. Recruiters, via the interface, can select a different recruiter to be on phase 2 or 3 once past phase 1. Ideally, I want every recruiter who is in touch with a prospect to be linked in the "total recruiters" column so that recruiters can easily see all of the prospects they have, and then what

Hello Community,I'm seeking your assistance in finding additional resources or suggestions for my approach in tackling a particular issue.Objective:I want to integrate a button within my Airtable database that can generate an interactive email chatbox (open or close) for partners to request notifications with just one click, specific to certain projects.Potential Solutions:SendGrid isn't a viable option for this task.Building my own extension is an option, but I'm unfamiliar with the process, and without clear guidance, I'm concerned about its feasibility. Building a new extension - Airtable Blocks SDK Hard coding would be a last resort since I am new to Airtable and don't want to reinvent the wheel if avoidable.Zapier offers some promising potential solutions, such as "Send emails for new Airtable records in views (zapier.com)", but I'm unsure about how to proceed without clear directions.I would be extremely grateful for any advice, solutions, or resources you can share with me.

Hi guys! Is it possible to automate the translating with google translate extension in airtable? So that you don't have to go to the extension and press the button "Translate with Google"?

Y'all.  I'm losing my mind over here.  I've done other automations in the past, but I've spent 2+ hours on something simple, and still can't make it work!  I'm trying to outline a sequence of lessons for a course.  Each lesson has a Prerequisites column and a Follow-Ups column.  I simple want to create an automation that will do the following:When a record is updated in the follow-ups field,Update the records that are referenced as Follow-Ups (children) to reflect that the original record is a Prerequisite (Parent)Why is this so hard???