hauwi - profile

hauwi · Apr 02, 2024

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...

hauwi · Mar 02, 2024

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...

hauwi · Feb 22, 2024

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 ...

hauwi · Feb 21, 2024

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...

hauwi · Feb 20, 2024

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...

hauwi · Apr 03, 2024

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...

hauwi · Mar 02, 2024

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(),

hauwi · Mar 02, 2024

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?

hauwi · Feb 25, 2024

Thank you @ScottWorld. Much appreciated. 

hauwi · Feb 22, 2024

Perfect, thank you. Now why didn't I think of that? DOH!!

User Statistics

User Activity

Can I create new record using lookup values only - to create an independant (editable) table

IF AND BLANK formula not working for attachment field

Airtable formula error in 'search records' module in Make.com

Automation to update record with today's date

Convert numbers to pre-defined letters - to create a simple password

Re: Can I create new record using lookup values only - to create an independant (editable) table

Re: IF AND BLANK formula not working for attachment field

Re: IF AND BLANK formula not working for attachment field

Re: Airtable formula error in 'search records' module in Make.com

Re: Automation to update record with today's date