Automations

Hello,I have three columns with multiple select options: Lecture (Mandatory), Lecture (Required), and Lecture (Optional). I want to automate the process so that if I add a new value to Lecture (Mandatory), it automatically gets added to the other two columns.For example, if "English Lecture" is added manually to Lecture (Mandatory), then "English Lecture" should also be added to the multiple select options of Lecture (Required) and Lecture (Optional). How can i do that using automation I have make some small automation but it is not workingSet the Trigger:Choose the trigger "When record matches conditions."Set the condition to monitor the "Lecture (Mandatory)" field for updates.       let table = base.getTable("Your Table Name"); let recordId = input.config().recordId; // Fetch the record that triggered the automation let record = await table.selectRecordAsync(recordId); // Retrieve the values from the multiple select fields let certificat

Hi! I am trying to create an attendance form that is able to create multiple records from a single form submission. What will be most convenient for our users will be a batch attendance as they login and log out at the same time.Im currently attempting this by using fillout forms. Im willing to try any options to achieve this result.Image 1:  Rows 1 to 5 is the output that i want. Row 6 is what i get.Image 2: What my form has to look like Appreciate all the help I can get! 

Table A (Names) has a lookup field in Table B (Clubs).  I would like a field in Table B that lists all records from Table A that  looked up that particular record (club) in Table B.   In other words, I would like a field in Table B that shows all the names for a particular club.  How do I do this?

My team has several hundred user profiles with personal information stored in a database with no API. We keep the personal info there, but we have an SFTP to upload CSVs for information regarding statuses and due dates on various per-profile tasks. Those CSVs land in Airtable, where I'm working to create interfaces that are a lot more user friendly than the database. The really unfortunate thing is, I need a way to track any status or date changes we make in Airtable in order for teammates to manually update that data in the database. At any one time, there will be three "truths": what the old upload previously said, what the teammate has changed it to, and what the new upload says. (I should note, the new upload will probably overwrite the old upload? I'm not sure, I haven't set it up yet as I'm designing the base with fake data.)I can't wrap my head around the best way to do this. I could:1. Have user status/date changes change the last uploaded data, but then compare to the new

Hello,I am trying to set up an automation that sends an email when a record is updated, but only if it is updated via our Mini Extensions add on.We ask people to submit via an Airtable form with information that is TBC, and when the record is created, we can ask people to update anything via Mini Extensions so that they don't have to log in or have an Airtable account.It would be great to know when someone has updated the record through the Mini Extensions form, as currently I can only set up an automation when a record is changed at all - this would be inappropriate as we are updating the records ourselves all the time.The condition options in automations for 'send an email > when a record is updated > if conditions are met' do not have the condition I am hoping for; any advice appreciated.Cheers

Hello. I am trying to send Gmail attachments I receive automatically to an attachments column in Airtable. I finally realized that Airtable wants the URL in array form, which I can do. However, I have not figured out how to use the array functions toArray, map, or add to append the files instead of overwriting and keeping the last one. I have searched and read numerous posts in both the Make and Airtable communities. This is my most recent attempt at make.com.My ultimate goal is to allow students to email their attachments and have them appear in the portal I built with Softr.I feel like I am so close. Thank you.

Hi! I have a task table with a Status field and a Completed Date field. I'm trying to create an automation to update the Completed Date field when the Status changes to Done. Wondering if there is a way to add the date that the status was changed to Done in the Completed Date field. For instance, if I change the status to Done today, the date in the Completed Date field should be timestamped with today's date 5/24/23. I added screenshots of my automation flow ... as you'll see I am not sure what to use in the update fields configuration page. I read somewhere that I can use Today () but that doesn't seem right in the automation. What should I do here, and is it even possible? Thanks! 

Hey there,I have a linked records field with 4 lookup fields that look up content from another table. I created an automation to automatically put in the Teacher tame into the linked field so that it finds the matching record and populates the fields. I then get the error: Field "Teacher" cannot accept the provided value: Cannot modify a computed field. I'm not modifying the teacher field through the automation but a field called PARTNERS Lookup, which in turn should automatically populate the "Teacher" field (and a few others). I'm not sure why this isn't working. Any help would be appreciated!     

Hi,I have a table of assets, faults, professionals and suppliers. Every time a fault is over, an email is sent to the customer (automation of email sending). Each property can have several malfunctions, each malfunction can have several professionals who handled the malfunction and several suppliers through whom we bought products to handle the malfunction. In the table of professionals there is the private bank account of each professional and the same also in the table of suppliers. Is there a way that if the fault is over and 2 professionals have repaired it and we have bought materials to treat the fault from 2 suppliers, the customer will be sent an email in the following format: Hi (customer's name), please transfer payment for the fault's termination to (professional 1) to the following bank account details: Bank - xxxxx branch - xxxxx bank account number - xxxxxx In addition, please transfer payment for (professional 2) to the following bank account details: Bank - xxxxx branch

Hi everyone! I'm working on a project to track and monitor my Airtable automations. I want to create a base that will automatically populate with all my existing automations and update every time an automation runs. This way, I can easily view the run history of all my automations in one place, without having to check each one individually. Is it possible to connect automations to a base and track their run count automatically? I've reviewed the documentation but couldn't find a solution. Any ideas or suggestions would be greatly appreciated! Thanks in advance!

I have a base with a record for each computer (about 4,000 total) that I am responsible for managing in my large corporation, and each record has fields about the computer including its Serial Number and Hostname, among others.I am provided with a semi-regular report in the form of a CSV from the company that lists every computer that has checked in with their security monitoring program which is required to be installed every computer. The CSV has more than 30,000 records. I want to ensure the computers I am responsible for are compliant and checking in, so I import the CSV into Airtable and then search for my computers by SN and Hostname. I use an automation to search for each computer in the CSV and update a field in each computer record to indicate if a match is found or not.In my current setup, the trigger for the automation is a single-select field on each computer record. When that field is set to "search for matches", the automation runs, and each computer's record is updated t

I would like to have a notification sent when a field is changed. For example, if a field is changed to Ready for Review, I would like an email to be sent to a certain person. How do I do that or can I do it?

When a form is submitted, the information does not populate into the base right away as it always has. When I check the base the following day-- usually 24 hours later-- the information is there.We are on the Team (plus) plan, and have been for more than a year. This is the 4th or 5th time this has occurred within the past year. This impacts our workflow. Please help... what does the mean?

The objective of the code is to select the options that are in the array for a multiple select field. I don't understand why it never allows adding options even if they are exactly the same as those in the table. It is an automation script. Thanks in advance for the help.  let table = base.getTable("TABLE"); // the table is correct let fieldName = "Technology"; let recordId = "recXXXXXXXXXXXXXX"; // the record id is correct let selectedOptions = ["AI", "Augmented Reality"]; let record = await table.selectRecordAsync(recordId); if (record) { let currentValues = record.getCellValue(fieldName) || []; let newValues = [ ...currentValues.filter(opcion => selectedOptions.includes(opcion)), ...selectedOptions.filter(opcion => !currentValues.includes(opcion)) ]; await table.updateRecordAsync(recordId, { [fieldName]: newValues }); console.log(`Record ${recordId} updated with options: ${newValues.join(", ")}`); } else { conso

I teaching myself automations and have a requirement I cannot figure out how to get to work. Love ideas.I need to set up a daily automation that looks at all of the records in a certain table and if any record has yesterday's date, send a single email to the recipient that includes a link to a view to look at the data. So the logic would be something like in table X, count number of records where payment date = yesterday. If count > 0, send an email with a link to a view that shows all the records with payment date = yesterday.Thank you!!!

Hi allCan someone please advise how to make an automation to occur for when a button is clicked ("complete in 'Next Action' field) this will match the Quantity Ordered number to Quantity Dispatched number so that Quantity Remaining formula shows as 0.Alternative suggestions welcome 🙂 Just wanting an override in my system as Ordered doesnt = Dispatched 

I need some help with something. I am building out a project management system for my team. Our projects tend to be pretty big, so each project has it's own base. But, we need a project overview base to allow leadership to see the status of projects easily. I have an Overview base built, but I need some way to automatically update the percent complete of each project in the Overview base. We have the team level subscription, so I cannot update the source records from the project base. I would prefer not to use any 3rd party systems like Make or Zapier, but if that is the only way to do this, I am open to it. Any help or ideas would be awesome! 

I have read all the comments and solutions re: logos in the emails.  I have done<img width="200" height="50" src="https://www.brittcoxgroup.com/site_data/brittcoxgroup/editor_assets/Wide%20Logo%20with%20CB.png">but it still does not work.  Please help. 

The AI responses in an automation action have drastically deteriorated. I suspect the reason is Airtable is no longer calling GPT-4. Previously, you could choose between GPT-3 or GPT-4. Now it is a toggle that says "Use AI models that optimize for best results", which I only noticed when investigating some bizarre fields in my base that were populated via AI. 

Dear all, when I prepare the message of a mail to be sent in an automation, some field (eg.: coming from a column with formula (concatenate)) are different from the original.In particulare the character "_" is lost and even "\\" is changed to "\\".Less important: also some emojis are changed. Could you help me to fix the issue?Thank you very much.Best regardsA. Borriero

Hi allI have an Orders Table and an Order Line Items table.I have a Date Required field within the Orders Table which is linked to my Order Line Items table.I want to have an Updated ETD (estimated time of departure) field against each line item so it is separate from affecting the overall order ETD (i.e. each line item with one order can have a different ETD).Ideally I want to just show the format as mmm-yy (i.e. July-24)Any ideas on automating this so that the Updated ETD takes the Date Required data but can be editable? Thanks!

Hi AllMy apologies if this is too simplistic - I’ve only got six months or so experience with Airtable…I suspect use case doesn’t matter here, since my “issue” is at the record and field level. Here is the scenario:- a form with some fields pre-filled is sent to a Client for additions and updates, is submitted by them, and creates a new record in an UPDATE table, separate from the main, “real” table; Clients often have no regard for “garbage in, garbage out”…- a manual review of the two tables “side-by-side” is performed to make sure data in each field is the type of data expected - both in text and attachment fields- an automation does an “Update Record” on the main table, using the data from the UPDATES table record, hence moving the new data to the Client's existing record in the main tableThe result is that blank fields in the UPDATE table overwrite existing data in the main table. BAD RESULT! At present, ALL fields are included in the update record automation, since there is no wa

Hi there, Is there a possible way to dissable a botton for certain records? Thanks

Hi,I'm afraid I couldn't find the correct Airtable documentation on this, please point me in the direction if there ready help somewhere.In an automation I have a conditional logic step. In that I have two conditions to be be met. One is a "type" kind of single select field, which translates to "Mini Day" in this case. This works.The other condition tries to look for text in a rollup field. Here is the problem, I can't get it to work and can't figure out how 'contain' works. In the preview field I can see the text I'm looking for, eg "Digi-Gold", but it doesn't work when tested.Here's a screenshot of the view:I also tried other text strings ('perusmaksu' and 'sessio') but nothing I tried works.What are requisites for "contain" to work? How does it work? Can I use use one condition to find several text strings, e.g. "sessio OR gold"?Rgds,Björn   

Hi there, I'm looking to bulk create a handful of training sessions based off an initial kickoff date. I have a table of training sessions and a template table with an offset from the first session. Most trainings run on a regular basis, but sometimes we need to reschedule. For this reason, I need the result to be a normal, editable field (not a formula I can't touch). I am using automations to create the number of sessions I need. I also have an automation to populate the first training session based on a value on another table that will be entered manually. I can't figure out how to populate the subsequent dates for sessions based off an offset. I tried a DATEADD() formula to sum my duration field (the offset) with the original date, but that didn't work. In plain English, if session 1 is today, session 2 will be next week in the same time and place, session 3 will be 2 weeks from today, etc. Any ideas? I appreciate the help!