Automations

I have an automation that is using a script I found on the message boards to format numeric values to currency. It works great. I pull the value from the script into the body of an email automation. However, when there is no value in the field I am using instead of showing nothing in the body of the email it shows 0.00Below is the script being used. If amount to send in USD for Email is blank how can I suppress the 0.00 from showing in the variable placeholder in the body of the email?  let inputValues = input.config();let currency = inputValues.currency;//define function to convert numbers to currencies for report displayfunction toCurrency(rawValue) {    return  (Number(rawValue)).toFixed(2).replace(/\d(?=(\d{3})+\.)/g, '$&,');}output.set("amount to send in USD for Email", toCurrency

Hi All! So I have set up an automation that adds a tag to my "Status" column (which is a multiple select column) when a certain checkbox is ticked as true. The automation seems to run fine, BUT, it replaces any previous tags in the "Status" column that were there beforehand. Is there a way to prevent the new tag from replacing the previous tag and just adding a new one? I did do some research and it looks like in previous versions of Airtable, one could select "Append" in the action section of the automation set up, but that doesnt seem to be an option now? Anyone got any pointers for me please? x

Hey all, I currently have the pro plan and therefore have the limitation of 5000 unique email adresses per day for the “send email” automation. What would happen on a given day if I exceed this limit? Would it just fail until the next 24h period starts and therefore all the automation triggered above that limit will just fail? Would it go beyond the limit and let you off the hook with a warning? Would it start to eat your monthly limit (5000*31) until you reach it? Thanks in advance for your reply. Sincerely, Timo

Hi all,I'm working on moving my team's operations over to Airtable, and I'm trying to find a way to automatically compare records in different tables at the end of the month.  I'm pretty sure I'll need to use scripting, but I'm wondering if there's a no-code or low-code way to do this instead of fumbling my way through javascript with chatGPT. The use case is:I have a base (LIST1) that is a list of sites we operate at every month, and another base (LIST2) that is a junction table documenting our activities (joining other bases of staff, vehicles, sites, equipment, etc).  I'm trying to set up an automation that fires at the end of every month to see if there are any sites we didn't visit that month and if so add those to a third base (LIST3) as a new record for each 'missed' site. The plan is toFind all records from LIST1 that have the inspection interval "monthly" - I CAN DO THIS I CAN DO THIS - Find all records from LIST2 that were inspected in the l

Hi,I would like to double check some variables and values I've used across automations. Is there a way to search through all automations?Rgds,Björn

Hi, I have an item status field the contains the values active, expired, and delete. in addition, I have another calculated field that contains the expiration date of the item. I want to set an automation that will run daily and change item status to expired when expiration_date < today(). I tried using the attached automation but it didnt change the status as I expected. 

Hi! I have a large existing google sheets I am trying to organize into Airtable. I own an events agency that books out talent for hundreds of events each month. This is a living document that is updated every day by people who fill out our form to book - this was a google form that dropped down into a google doc, but Airtable seems much more user friendly. I want the rows to automatically drop into date & event start time order with an AM/PM format. My current information has the date, start time & end time in separate columns but the Airtable automation has date/time within one field. Is there a way to merge this so my existing data can format without me having to re-input hundreds of upcoming events into a new spreadsheet? Screenshots of my Google Sheets spreadsheet & how it imported into Airtable. Thanks! 

Hi Yall!! So I am tying to add in an automation that uses a check box being marked as "true" as a trigger in TABLE 1 to add one of my multiple select options in TABLE 2.  An example of how I would need it to work: Table 1: Check box is marked as "Checked/True"Automation kicks inTable 2: one of the multiple selectable items in the column I need to select is added Trigger: Checkbox is checked in Table 1Action: Tag is added in Table 2 Is it possible to add in automations that work across multiple tables?  Any idea how I could build this automation? My main issue is coming into selecting the correct record ID?  Any help would be seriously appreciated! Thank you!  

Hi,Is there a way to either add a global bcc address to Gmail mail sending in automations, or a way to batch update them?Soon moving to production with an Airtable system, and would like to put myself as bcc in all outgoing emails for the first weeks or so for monitoring that everything looks as it should.Rgds,Björn

Any assistance would be greatly appreciated! I have a Serial Number (SN#) that is labeled "Locker Name". I want to make sure that the SN# is 7 Characters/Digits before finishing the automation as sometimes it get typed in wrong. the SN# format is NS01234 or NS00123. People leave off the 0's from time to time. i want to create a new record with this number in a new table. Linking is not option here. Here is what i am trying to do but i am getting this error: TypeError: Cannot read properties of undefined (reading 'length')at main on line 4     if (sn.length === 5) {       i guess i am asking how to get the Length of the value to read so that i can achieve this??  let sn = input.config.LockerName;let updatedSN = '';if (sn.length === 5) {updatedSN = 'NS00' + sn.slice(-3);} else if (sn.length === 6) {updatedSN = 'NS0' + sn.slice(-4);} else if (sn.length === 7) {updatedSN = sn;} else {updatedSN = 'Invalid SN#';}outpu

I am trying to generate an Invoice for line items in Airtable. New Google docs creation automation is very helpful but it lacks basic formatting functions. So, I use Microsoft Word module in Make but do not know what format I should use in this “Raw values” field. Could anyone please give me an example? I know this is not really a Airtable question but documentation on this module is quite limited. My Word templates : {{invoice_number}}-{{invoice_date}} {{buyer}} {{#details}} {{item_code}} {{item_description}} {{unit_price}} {{/details}} Thanks in advance!

We use a webhook from Shopify to capture order data in Airtable. When the webhook comes in, we create a record in Airtable with pertinent order data. I want to parse out the line items in the order into another table for use in creating a packing slip. Here is sample data: Airtable - MA Test The Data table represents the data as it comes in from the webhook. The Desired Output table represents the ideal output. This is where I need help, creating an automation/script to parse out that data into new rows. Thanks for your help!

So we've set an Airtable Automation where every day at 12:00PM it sends an email digest to the project managers to show Rush or High Priority tasks that are due today or before today. I had one question:Is there a way to have the link of each task on the email? For instance, once we get those emails with the tasks due, it would be nice to have it where each task comes with the respective Airtable link that leads to the corresponding task right away. I've attached the screenshot of the current automation set. Thank you!

Hi AllHoping there's a simple solution for this: I have a table that is updated regularly with status changes, content changes and also linked records.I would like to send the users of the base a daily email at night that shows a grid of those records that have been updated that day. This way they will get a clear picture of what happened each day. Many other PM tools provide this automatically. This is not an email that is sent as soon as a change occurs but rather it will be a scheduled emails that contains ALL the records that were changed that day.Is this possible? Thanks very much!

Hello Community,I have a table with events and a linked table with needs for the events. Different needs can be assigned to each event. Each event and each need has a status. I would like that if all needs that are assigned to an event have the status "delivered" or "declined", that the status of the event changes to Needs processed.Does anyone have an idea how I can implement this?Best regardsMirko

I have two tables. The first is a item "types" as below...the second is a table of "details". Each row represents 1 item of the total number of that item type. Each row in the second table will have unique data, like an ID, a physical address and a QR code....If I add a new row in to table 1, with a qty of 20 units (in the Qty column), how can i automatically add that many rows to the second table, and link them to the dislay type from the first table?Thanks

Hello! Wondering if someone knows why this is happening- I am trying to mimic a script I use in another base, and I've just realized why it's not working. In my other base, I can set the 'record' but in the second, this field doesn't exist. What am I missing? Here it is in the base where it works, where Record existsAnd in the base where it doesn't work, where record doesn't appear as a field: 

Hello,Please, I would like to create an automation that, on the 1st day of each month at midnight, creates a new record with the actual trigger time. I expect the trigger time in the action section to be the same as in the trigger section of the automation scheme. However, somehow, the "Actual trigger time" field value is created with the last day of the previous month.Thank you for clarifying what I am doing wrong

Hi Unable to automatically generate Invoice number when make new invoice from Airtable to QBO though MAKE Please help    

Hi there, Here's the scenario: • I have an automation to send an email to the marketing contact if the 'marketing contact email' field isn't empty• the 'marketing contact field' is a Rollup field with a formula of ARRAYUNIQUE(values)• even though the 'marketing contact field'rollup field is empty, as you'll see from the test run on the below Loom, it still tried to execute that worflow. • is it seen as not empty because there's a formula in it?https://www.loom.com/share/5b726b2bc41a414da662f055af863b55

I've posted here before, but never was able to find a solution, thanks those who tried to help me though.  I've since recreated what I'm trying to do in hopes that it is simpler and can be done.  Here goes. Use Case: I have orders getting added to a table "Order Fulfillment" by Zapier.  The Course can be several different things "ITIL 4 Foundation, ITIL 4 Foundation w/TAKE2, etc".  What needs to happen is, when the order gets created into this table and I check the "Run Automation" checkbox, it needs to find the next available Voucher Code from the table Voucher Code and move the information in Voucher Code table to the Order Fulfillment table and update the record.  The Course is what should tell it which to match and use. Is this at all possible to do?

Hello,Something strange is happening in an automation that queries a view and sends it via Gmail as a table.I have configured two numeric fields that the only thing that changes is the format. In one I have it as a currency and in the other as a number.But the format to show in terms of separation of thousands and decimals is the same. The problem is that when I send the email from Gmail, it only keeps the format that I want to show correctly in the currency field, but not in the other one. Could it be a system error?

I have a Jotform that populates an airTable base.  If someone submits an exact duplicate form, I created a vew that shows ONLY those submissions that have duplicates.  I have a checkbox in that view that when I click it, it hides that entry from that view, and (Importantly), it hides the other submission because the two submissions are no longer exact duplicates. This works great.  What I am looking for is a way (automation) that will automatically click one of the two.One slight complication is that there can be 3 identical submissions and I want the automation to click the checkbox on all but one of the submissions. That one unchecked will still disappear from the view because it is no longer a duplicate.

Hi all -- I set up an automation to trigger a personalized email every time I click a checkbox in a table. I connected and reconnected my Google account, but am not receiving an email even though it says the test was successful.The email I'm trying to send *from* is my work email, if that makes any difference (wondering if our Google admin might have a security setting that would prevent from automated sending, but not trigger an error when testing).Any help would be greatly appreciated.

Hi Everyone, Happy Friday!Looking for a little bit of help. I have a record of emails in one table titled "Clients" and in another table labeled "Appointment History".For every time the status of an appointment is changed from "booked" to "completed", I want to send an email to the client for customer feedback. The current automation  I have essentially updates ALL statuses from Booked to Completed at Midnight. The issue I am running into (I think) is my record ID. For the "to" section under the "Send Email' Action. I have chose the following upon testing to see if it will work, I get this error"Invalid email address in the "to" field: rec---" from what it appears, I need to seperate multiple emails with commas, however I am choosing the emails from a list in a table. Do i have to insert a comma or a semicolon at the end of each email address in my table to make this configuration work?  Thanks in advance