search

dcolley / integromat-facebook-support

0 stars 0 forks source link

PLEASE HELP Filter Empty property I am sure the answer is simple but I just... #127

Open dcolley opened 2 years ago

dcolley commented 2 years ago

Source: copied from https://www.facebook.com/groups/integromat/permalink/3969358459841424/

PLEASE HELP Filter Empty property I am sure the answer is simple but I just can't get it to work. I have a Hubspot Number Property called 'Shopify Line Item' I would like Integromat to create a deal ONLY if this property is EMPTY. I would have thought this to be easy yet, after trying multiple ways, I can't seem to figure it out.

dcolley commented 2 years ago

Comment ID: 3969407259836544 in the condition, choose "if not exists" or of it exist and null - you have "null" tag in the text tab

dcolley commented 2 years ago

Comment ID: 3969448826499054 Make sure the filter condition is “Equal to” under the Number operators section. Click the “Equal To” text and scroll down. Also, you can use the “Exists” or “Does Not Exist” to check if the field is empty or not

dcolley commented 2 years ago

Comment ID: 3969501599827110 Yedidel Elhayany Tried both of these and they do not work

dcolley commented 2 years ago

Comment ID: 3969502933160310 Tried this also before but does not work for whatever reason 🤔

dcolley commented 2 years ago

Comment ID: 3969504733160130 I too would’ve thought this to work but I do not understand why it does not

dcolley commented 2 years ago

Comment ID: 3969535656490371 Sylvie Moreau have you tested the module before the filter to see what the results are of it?

dcolley commented 2 years ago

Comment ID: 3969538396490097 yes

dcolley commented 2 years ago

Comment ID: 3969540493156554 Guy Butts Funny though because this information is also entered into a Google sheets file. I am now wondering if I should just "watch" my google sheet file instead and create a deal from this information

dcolley commented 2 years ago

Comment ID: 3969554136488523 Start by reviewing one of the history executions. Click on the module that holds the data with the line item (I believe it's the HubSpot search module?) And then in the popup that reviews the input and output of data, top right corner there's a button with two download options, grab the output data. This will show you the raw data that you got there. I believe this will help you figure out how to define the filter. Good luck!

dcolley commented 2 years ago

Comment ID: 3973169856126951 David Treves thank you I will check this out