Hello,
I have a scenario where the custom field from an API Call is blank. It should show as “empty” since there are no values but it’s just blank. I checked our CRM and refreshed that section many times and the field I want is indeed empty since the data from that field was deleted quite some time ago.
What I wanted to do is if the value from that custom field (text) is empty, it will pass through the “Does not Exist” filter to continue but for some reason it is detecting something from that field and blocking it even though there is nothing there.
Is there a workaround or another filter I can use to make this work?
I tried using (customfield “Does not equal to” = “”) and (customfield is “Does not equal to” = null) but they don’t work.
Any help would be very much appreciated. Thank you!
Hi Mark,
You could use the length method and check for 0
1 Like
Hello @Mark_Carz1,
If it’s null or blank then I think it’s also considered empty.
As your images are shown maybe there is “SPACE” is added there. That’s why it’s also not shown as empty as others.
So apply the length formula as @Fario_Consulting suggests.
P.S.: Always search first, Check Make Academy. If this is helpful, mark it as a solution and
Need expert help or have questions? Contact or comment below!
1 Like
@dilipborad
Thank you for the advice.
I’m new to Make and I do not know how to achieve that nor can I find any topic about how to do the length method in the community. Can you provide quick instructions?
Hello @Mark_Carz1,
As per the initial attached images, I can see that you’ve used a few filters.
Now the real question is how to use filters and functions with Make’s Mapping Toolbox.
Try to add another level of filter and also check if the item contains space or not.
In the filter dialog, there are multiple options to use. Use contains and then pass {{space}}
in the value box. OR you can select the space keyword from the Mapping toolbox.
If you still can’t understand how to implement these things then I strongly recommend investing some time on 🟣 Make Academy: Course Overview
Make is providing their academic courses to understand some basic things and how to use them.
Specific course to your current question, But I recommend you go from the start. It’s worth it.
- router and a filter https://academy.make.com/courses/FoundationC02
- using functions 🟣 Make Academy: Course Overview
1 Like
@dilipborad Amazing advice! Turns out there’s a hidden space in the value so adding a filter to check this definitely worked. I am talking all of the Make courses and I am still learning. Thank you very much for your help!
Hello @Mark_Carz1,
If this is helps to you and solved your problems then please mark this topic as a complete
Then later other makers also get more help based on this topic.
Also make sure you practice things as well.
1 Like
@dilipborad Done! Thanks again for the help.
1 Like