Automations

I need to change this formula to ignore weekends. It is successfully calculating the next day a task should take place on based on frequency, but that frequency should add 1 or 2 days if it is on a Sunday or Saturday. Anyone know how to change my formula to account for this? IF((Frequency = “Monthly”), (DATEADD(Due, 30, ‘days’)), IF((Frequency = “Biweekly”), (DATEADD(Due, 14, ‘days’)), IF((Frequency = “Weekly”), (DATEADD(Due, 7, ‘days’)), IF((Frequency = “Daily”), (DATEADD(Due, 1, ‘days’)), Due))))

Hey forum! Im trying to update a record via a sync from another base. Basically, I have two bases that are synced; one is with a customer and one is with my internal team. The customer provides the project, and it syncs to my internal base for my team to begin working on it. When its updated, I have it synced back to the customer for the updated information. I basically have a tab in the customer’s base that is our synced data; then link that information into the customers tab. What id like to do is not have to link the information coming from us; Id rather be able to update the record based on a trigger (estimate quoted, delivery date proposed, etc…) Is there an easy way to do this? I tried using the update record automation, but it seams to not work for adding that link to a specific project. thoughts?

I want to Launch an airtable webhook from the airtable button field. I was trying to pass the record ID. Is this possible and if so how?

I’m collecting name and email (and other data) from a form, entering it into Table A. Using a “new record” trigger on Table A, I want to create a new record in Table B using name and email, but only if a record doesn’t exist yet. Is this possible? I thought I could do it with the “find record” action, but there doesn’t seem to be a way to specify a following action if nothing is found.

Hi there! This seems like it should be easy but frustratingly, it’s just not working. When it sends the slack, it’s not displaying the name of the collaborator from the Created By field… Any clues? :frowning:

Hi folks, I’ve been using Same Table Linked Records Backlinks | BuiltOnAir to try to build columns that calculate hierarchies from a recursive link. For example, if I have a column of names plus a link: Object | Is subclass of Fork | Utensil Spoon | Frank Utensil | What I want to compute is a column that looks like this: Object | Is subclass of | *All subclasses* Fork | Utensil | Spoon | Utensil | Utensil | Kitchenware | Fork, Spoon Kitchenware | | Utensil, Fork, Spoon I’ve been running into a big load of bugs; i.e. I parse the table and add keyed {parent, kid} pairs to a list, but for some reason I’m getting a “cannot write, there are duplicate links” error. It’s beyond frustrating! Would love to know if there’s so

Hi, I’m a beginner with Airtable. My first test is to use the automation with run script action I created a automation on the trigger 'When a record is created ’ like this But i don’t see the message in the console when i create a new record I have 2 errors messages : Have you a idea about this issue ? (I have a Pro plan)

Hey All, I’m trying to run a simple automation, but for some reason it doesn’t work. I building a directory of growth hacks in an airtable base with a subject, description, category and image. There are 4 main categories (e.g. SEO, Paid Ads, Tools & Productivity). For each category I have an image (4 images). The automation I want to run is that whenever I add another growth hack (subject & description) and I assign a category to them, that the respective image will be added automatically. So “When I assign a growth hack to a category, the image belonging to that category should be added automatically to the image section”. I would to get some help on this one. Thanks in advance!

Hi Friends. I am looking for a way to have people select a time slot from a single select field when filling out a form, but then make that option unavailable to other people. When creating a form, you can choose which options are shown, but I can’t figure out how to automate changes to which options are shown. Any ideas? TYIA

I have multiple users submitting new records via a form I have a view that captures all these new records and I would like to make a number of fields UPPER CASE How do I apply the UPPER() formula over exiting data within the field?

Okay, SUPER SIMPLE, SUPER DUMB question - how do you create an HTTPs GET in a script automation that doesn’t wait for a response? More background - I’ve tried fetch() without await; the script still takes forever to complete and is obviously waiting for a response. If I decrease the processing at the GET endpoint, the script automation process time decreases as well. If I increase the processing time at the GET endpoint, the script automation time expands and eventually times out at 30 seconds. Is it possible that Airtable’s implementation of fetch() is simply unable to act as a non-blocking webhook caller?

What is the recommended way to deal with potentially null arrays when running a script as part of an automation? I’m setting up an automation flow that runs a script and as part of the script I’m calling record.getCellValue() which oftentimes will be null. When using the scripting block, I’ve handled this by using the nullish operator, like this: let array = record.getCellValue() ?? []; That way I always have an array, even if empty, and not null. When trying to re-create that script in an automation though, I get this error: I would’ve expected both scripting environments to have the same support. Am I missing something here? And if ?? isn’t supported, what’s the best way around it? I’m working with a lot of arrays so would like something succinct. Thanks for any help

Hi, everyone. I was testing my automation with my team and I came across an issue when I had test emails sent. For some reason, the URL sometimes gets cut off and renders the link invalid. It looks almost as if the URL is cut off for it’s length, but I’m not aware that there’s any character limit for that field type. Has anyone gotten this problem? Is it possible that I may need to switch to a different field type? Any information would be helpful, thank you!

Hi, I have a status column and when i change it to Active, i want to send a webhook to Zapier URL instead of checking on data change (it’s not realtime). Is it possible to do that? Thank you

I’m building platform with airtable and other db synced. With automation of create and update, I can sync data between two db in real time. But this time, i want to delete record on db when the user delete a record on airtable, but I can not find the trigger of delete. Can I get any help for this? Thanks

The Automations do run without any issue when I enter the data directly in Airtable. However, I found out, they do not run if the data is submitted via Airtable Form. I am not sure why they decided to behave this way. If the data is entered, I would expect the automations behave same way, regardless how the data was entered. In my case my Automations have trigger to run when a field of a record is updated. That works well for both entering new data or updating existing data. So I guess I will need to create another copy of my existing automations and set the trigger to run when a new form is submitted?? I guess I have to use the form trigger. Just find it unnecessary.

https://apostolicfaithchurch.box.com/s/otajygxrz336kdx9b7b5ns26amu29tmp Hi there, I am wondering if there is a way to dynamically insert a link into an html element as shown in the video. html <iframe src= "" allowfullscreen="" allowtransparency=""></iframe> Source link: https://objectstorage.us-phoenix-1.oraclecloud.com/n/ax22fojcamx7/b/general-devotionals-audio/o/2021%2FMay%2F495%20A%20Cheerful%20Giver.mp3 Each is in its own AirTable field. Thank you!

Hi All, I am about to rip my hair out (over something that is probably obvious to everyone else!) I have set up an email automation to be sent to the team when a finance date has passed. However the email is sending whenever a date is entered into the field (not when its overdue) and in the email automation the date doesn’t match what is entered into the field and states that its a month earlier. This is the automation I have set up at the moment. The second date field is to ensure that if finance approval has been received already a reminder is not sent. and this is the email that is sent. However when the email comes through, it gets as soon as I enter any date in the Finance Due field and then the date in the email doesn’t match the date

Dear airtable community, currently I’m using the “QR Code Maker” app in Airtable, which works great for me at this point. Now I want to take the next step and fully automate my process, by letting the app generate a qr code, without me manually having to confirm that procedure. As soon as a certain field is filled the qr code should be added to the chosen line. Since I couldn’t find this option straight in the app, I had a look into the automation category and noticed the custom script option. As far as I can assess this, I think that this is the best option. If there is another great solution to tackle my automated qr code creation, please be so kind and let me know, any help is highly appreciated! Thanks in advance guys, take care and stay safe! Kind regards, Karim :slightly_smiling_face:

Hi guys, here’s what I need help with: Thanks

I’ve been using Airtable for a couple years and I’ve accumulated a lot (26 automations), and I can’t believe there is no way to manually sort (rearrange) the automations… Am I missing something, Airtable can you build this?!

Hi! Does anyone know of a clever way to track outlook email threads using Airtable’s native automations? Unfortunatley, Zapier isn’t an option for us or I would use that. Currently, I have an automation to create a new record when a folder in my Outlook receives an email (based on an outlook filter rule). When someone replies to said email, I’d like a new record created and linked to the existing record for that email thread.

Hi guys! I’m taking a form on my company, and this form is available for the same person to answer how many times she wants. It’s a definitive and continuum form. I was thinking about a filter that could give me the last answer of each person over the time, like a checkbox or a field with yes or no. Like an automation who could give me if the “submit” was the “last submit” of that person, so I could filter and create a unique visualization. The only in common record in each answer is the name, so if they have the same name, and the timestamp of each one it’s different, I would like that this automation could give me an answer for the question “Was it the last answer of this person?” It’s possible? Thanks

Trying to set up a Outlook calendar automation, but it isn’t testing successfully. All required fields are populated that I can see, and I tried retesting each action in order. Date fields that are being considered are the same format. The last action is the only one that isn’t working.

Hi everyone! In a client’s base, they have a form where applicants essentially fill out a job application. Applicants upload their resume, and then I have an automation set up that pushes their demographic information into a “Contacts” table and the job-specific information, including their resume, into an “Applications” table. This works perfectly about 90% of the time. Seemingly randomly, some resumes aren’t appearing in the Applications table. When I look at the record history, I see this: Why would the automation add the resume only to immediately delete it? Has anyone run into this before?