Hi I have a student 'onboarding' table which, when completed, triggers an automation to create a new record in a 'live students' table. So, each field in each new record is linked to one of my 'onboarding' fields. Some of the linked fields are formu...
Hi. I'm struggling with a formula to include a blank attachment field as part of 3 AND conditions. I'm testing this in my base before I put the AND part into a make.com airtable trigger module.At the moment, I have this: IF(
AND(
{Ind Doc}!=BL...
Hi. I am trying to construct a formula in a Make.com search records module. The module is the trigger and I've been trying:AND({Ind Doc}!=BLANK(),(DATETIME_DIFF(NOW(),{Record Created}(),"days")=14))('Ind Doc' is an attachment field)Any help would be ...
Hi. Sorry, but I'm struggling to know how to do this. After my automation sequence, I want to update a date field with todays date to show when the automation ran. I've searched hard here, but I cannot find a way to do this. I've tried a formula in t...
Hi. I have a very basic password system that uses letters to denote numbers. The numbers come from a client's DOB.I have a date (DOB) field and another field using DATETIME_FORMAT to only show the numbers (DDMMYY). That's all fine.I would like to hav...
Thank you for the replies. I may not have been very clear, sorry. ...My onboarding table is effectively a process of data gathering. Once the data is collected, only approx 20% of that data is needed, ongoing. However, I need to keep the original on...
Solved it! Removing the exclamation mark did the trick. (No Idea why, so an explanation would be gratefully received). I am still a bit new to all this. {Ind Doc}!=BLANK(), ... to make ... {Ind Doc}=BLANK(),
Hi Adam. Thank you, I did try this and it makes no difference. Do you think it might be something to do with me having 3 parameters in the AND formula? - Or maybe because two of those parameters reference the same field?
