Automations

Hello everybody.It is possible to have a view of type "Locked view" and at the same time of type "Personal view".The thing is that I have views created exclusively to generate automations. So I want, on the one hand, for no one other than me to access them (no one but me needs to be bothered by displaying this view in the list of available views), and on the other hand, to prevent myself or someone else from modifying them by mistake.If not, what would be the best way to protect a filter view that is used exclusively to generate automations? The idea is to prevent adding records there, and at the same time having its configuration manipulated by mistake.Thank you.

Hi,I want to create an automation that when I create record in table A it automatically will create the same record as vlookup in table B.so if i update the record in table A it will reflect the record in table B.is it possible to do?thanks

Hi,I'm trying to create automation that every scheduled time 2 fields in the table will be updated to certain status.the trigger is working but i get an error of "Received invalid inputs."can anyone help me with this?attached image that show the automation:  

Hello, I am running into the problem where if two users trigger my automation at the same time or before the automation finishes then the second data point will not run/create a record. Is there a way to setup a queuing system where the second trigger can hold until the automation has completed?Thank you!

I have an automation that once a checkbox is checked, it creates a new record in a different table. It worked quite well and today it failed repeatedly saying "Creating the record failed due to insufficient permissions."I'm the owner of the account so i assume it does not mean my own insufficient permissions.... can someone explain this message and help resolve it? 

Hi everyone! I'm struggling to create an automation. We have a list of customer-support interactions that are either marked as Open, In Progress, or Resolved. For the most part, interactions are resolved same-day, but occasionally, some will need to be left as Open or In Progress, creating the need for a daily email summary that lists those unresolved interactions (if there are any). With that, I've been trying to create a scheduled automation that runs at 8:30 AM every day based on a view (that is set to only show unresolved interactions), and I'd like the automation to only send the email if there are items within that view. I've been trying to configure this, but with no luck. I'm not sure what I'm doing incorrectly (maybe it's my "Find records" step?) There's currently 1 record within that view, but when I test the automation in it's current state (attached) it's not meeting the conditions. Any ideas? Thank you in advance! 

Greetings,I am working with 4 tables of approximately 10,000 records each. The primary field is the name of a specific medical product. I am trying to go through and categorize these products so I also have a field for "category" with multi-agent selection as the field type based on the type of product it is. Some, but not all, of the medical products will be on multiple tables. Is it possible to set up an automation so that if I categorize an agent on one table, it will automatically update the category for that agent on any other tables it happens to be on? I am working on an automation to Find records with a matching agent (medical product) and update them. I believe I am stuck on fine tuning the update since it will be dynamic. I can't quite get it to match the category I want it updated to. Can I do this with just 1 automation or do I need to do 2? How should I structure it/them? Thank you for helping. 

I work in a school and manage a process where teachers submit a form after grading tests. This form triggers an automated email to the parents. Currently, if multiple students are submitted in the same form, all their names appear in each email sent out. I want to personalize these emails so that each parent receives only their child’s information.I am considering writing a script that can be triggered by a button. The idea is that when the button is pressed, the records would be split by each student's name, and an automation would then trigger the sending of these personalized emails.Has anyone implemented something similar or have ideas on how to best approach this? I would greatly appreciate examples of scripts or advice on setting up these automations effectively.Thank you in advance!

I have a base where I want to track how Contacts engage with Events (dozens of them). I have one single-select status field per Event on the Contact record and would ideally like to use those fields to programmatically link the two records.For instance:Contact James Doe has the status "Invited" in the field "Conference 2024" (which corresponds to the Event record Conference 2024). In that case, I want to automatically link Conference 2024 in the "Events invited to" linked records field on James Doe's record (appending it to any existing records there).I know I could set this up for every single event individually with automations, but I would like to avoid doing this dozens of times for dozens of different event

Hello! I'm hoping someone here is great with automations/scripting/something to help. I'm trying to run an automation every Sunday to randomize work tasks for my team and then send an email or Teams message. I want it to refresh the randomization when this runs at it's scheduled time. I have 6 members, and already have their off days input. The Airtable randomize values extension works for what I'm wanting (and avoids the cells that are already filled with "Off"), but I can't run it on an automation and honestly, I don't know enough about JavaScript to change the code. Their code requires inputs from the extension panel with the min/max bounds (mine would be set to 1,1, which is how it avoids the "Off" cells) AND the specific field to update. Here are my data references:Automation should run every Sunday at 3am (before anyone is logged in.. the time is somewhat arbitrary)Randomize each task excluding "Off"6 member

Hi community, I have set up a trigger that loads a record and passes on linked records values to a script supposed to order those by date from earliest to latest. I'm struggling to get this to work, can anyone advise? Thanks!const inputConfig = input.config() const linkedRecords = inputConfig.linkedRecords linkedRecords.sort(function(a,b) { var c= new Date(a.date).getTime(); var d= new Date(b.name).getTime(); return c-d; }) output.set("linkedRecords", linkedRecords) 

Hello, I am stuck.I have a table that I upload a csv from my databaseThe table has records (all records have a unique GuestID) that are either the parent record (field name GuestAccountOwner is equal to true)Or a child account where GuestAccountOwner is equal to false and GuestAccountID is equal to the GuestID of the parent record.I am trying to output in a new table on one record for each parent, but combining data from both parent and child. So the record would have the ParentName, Parent Email, ParentPhone but on the same record there would be Child1Name, Child1DOB, Child2Name, Child2DOB. Based on the DOB of each child there would also be a Child1BirthMonth and Child1BirthYear, etc for each child as well.Basically the automation has to go through and find the parent records, count the chidren and put it all on one line, I can either have all the fields ready with that naming convention or it can be added on the fly.Is this possible?

Hi there!Hope everyone is doing great! Remind to drink water 🙂 I'm working on a project to connect two different users (not the same table).I want to set up an automation to match records by using two records, geographical area and interests.Let's first try by doing matches with one field.I have two different users :Our client : they want to meet people from France, USA, Italy, Brasil (for example).Our Partners : usually from one country.Both of the country fields have same naming convention and are both a Multiple Select.I have created a specific table "Matching Table". On an interface which is a little CRM for our clients, I created a button to create a record on the Matching Table.Once the record created in the matching Table (here is the automation I try to create) I want to add Partners records (Link to DB Partners) to the record created for the client.The problem is that the matching doesn

I have a form for inputting contact and basic account information for new sales (form 1) - when the form is submitted, it sends a survey that the customer needs to fill out (form 2).Depending on one of the fields from form 1, form 2 can be one of five different form views (specific questions and information are pertinent to specific account types).I currently have a nested IF function and hardcoded URLs for the five different forms - is there a way to make this connection dynamic instead?  Concern would be something like, if a sixth account type was created it breaks the workflow.

Hey everyone!I'm new to this and need some help. I have a list of client details that include two attachments: a price list and a software update list. These attachments are used in automated emails. Periodically, I need to update these attachments with the latest versions.I've tried two methods:1. Linked records: I created a second table with the attachments linked to the client list. However, I'm having trouble getting the attachments to appear in the client list.2. Update record automation: My understanding is that I need to first find the relevant records and then run a repeating group to update them. However, I'm facing two challenges here. First, it seems to only find up to 100 records, but our list is much larger. Second, I'm struggling to get the automation to work smoothly.Has anyone encountered a similar situation and found a solution? Any advice would be greatly appreciated!

Are empty record fields counted as 'Unique' in the Unique total number? I expect not, but just checking.

I may be going the wrong way around this. I am trying to send records from one table to another as a group of linked records. There are two condition groups for creating two linked records each time the automation is triggered.Condition 1 is:Farm contains "Ahoaho"Status is "Sales"Sales Summary (Linked Record) is EmptyCondition 2 is:Farm contains "Ahoaho"Status is "Sales"Sales Summary (Linked Record) is EmptyI would like to be able to further group these by "like dates," so that stocktake records from different dates don't get linked to the same Sales Summary record.My first approach was to attempt creating a repeating group based on unique instances of "stocktake date," however the repeating group fu

This automation has brought me to my knees, please help.I'm trying to create a google calendar event for a session booked from a start time to end time. The automation fails because it's unable to parse datetime: " "This is my flow:1. I enter the date and time in text format (Text date)- 3 April, 2024 at 17:002. Then convert the above to date format using Datetime parse formula - 4/3/2024 17:00(formula - DATETIME_PARSE({Text date},'D MMM YYYY at HH:mm') 3. Then I convert this to ISO format using Datetime formula - 2024-04-03 17:00:00.000(formula - DATETIME_FORMAT({parsed and formatted date},"YYYY-MM-DD HH:mm:ss.SSS") What i get in step 3 is what is entered as start time in the automation. Similarly the end time is calculated using three steps. 

Hey all.I'm looking to automate a task based on # of projects included in a record.The above is a listing of test courses.  The are marked for the trigger conditions, and should be the only records that are created into the Project Production Table. I'd had a simple automation that did this perfectly.  However, I'm needing it modified to where it will now create new records based on the # of projects in that field:Here's the automation setup:

Safari v14.1.2 To the right of a table where it says ‘add or import’ the add or import is flickering and quickly. It started on one base and has spread to another. What can i do to stop it happening and annoying my eyesight. (Uploading a screenshot is pointless as it won’t capture the flickering, rather I’d have to time the screenshot to coincide which at the speed of flicker could take ages. )

I’m very NEW to Airtable.I want to create a B2C project. The goal is to have the client enter a due date and an email is triggered to notify them each time the item is due. I don’t need to know their due dates because it will become their personal tracker .It’s like their personal planner/accountability tool.Is this possible?If so clear and simple instructions because I’m learning how to develop a base from scratch.thanks in advance 

I am trying to create an Automation that will send an email to all records in a View, but I consistently get an error which indicates that the Action does not recognize the email field. Specifically: Job Board TableNew Listing View – New listing (all records with today’s date)Worker Availability Table                  Active List View Trigger: New record in Job Board Table – New Listing ViewAction:  Find records in Job Board Table – New Listing ViewEmail: to all records in Job Board Table – New Listing (field type: email) Testing my action produces the following error report: Invalid email address in the "to" field: <b>Worker email (El Correo de electrónico)</b><br/>theothergarynelson@comcast.net<br/><br/><br/&gt

Hey guys,I am having an issue with a formula field not showing up in a teams message. I have a formula field inserted into the body of the message, the formula is just "Required" or "Not Required" text. But when I test the action the formula field's text doesn't show on the teams message. Has anyone encountered this or know a fix for this?Thanks!

Hi there,I am looking to create nice email templates on Airtable and send them via the automation function. I tried with Aeropage but I need to pay for it which I rather not do.I also tried with Sendgrid but can't find how to do it once the template has been created.Thanks in advance for your help

I have an automation which sends out entries to the database through email.Error message showed that one of the emails couldn't be sent due to it exceed 25mb.Is there a way to increase the size limit of the email or is compressing the file the only way around this?