"Is not in" opposite operator

Hello,

I want to run a workflow when an input_text “is in” do a search datatype -->text field. BUT i only have the option of “is not in”. I know there is the “contain” but this is not good because one of the text could contain the other but that doesnt mean they are equal.

“Cat hat” contains “Cat” but they are not the same. i need to find an exact match between an input and a datafield.

Ive tried filterin advanced and cant find how to do it right.

Hi there, @jaimeisaac… I’m not sure I understand your post, but it seems like you shouldn’t be focused on the Only when condition when you haven’t defined the thing you want to change. Are you trying to change a thing in the cliente data type where the thing’s nombre field is the same as the value that has been entered into the Input nombre cliente input? If so, I believe the thing to change would be Search for clientes:first item with a constraint on the search of nombre = Input nombre cliente's value. The search would either find a thing to change or it wouldn’t, so I’m not sure why you would need an Only when condition. If you do need the condition, you can use the same search I mentioned above, and the condition would be Search for cliente's:count > 0.

If I have missed the mark here, share some more details/screenshots, and I am sure someone will be able to help you out.

Best…
Mike

1 Like

Thank you, I appreciate the time you took to clear my head. I was a little confused with the logic. What I’m trying to achieve is to execute custom events depending on the existence or not of a previous thing with same name(create or updatea thing). Im encapulating two o more task on each custom events so i can avoid using “only if” on several places.

What is new for me is the fact that if a search for doesnt give results then no operation will be executed right?

I got it working now but the web app “hangs”, i mean the progress bar just slows down and never completes. Im trying to catch many data fields from an API and then put everyone of them in different tables and lots of conditions so im not creating double things and instead just update them. I got frustrated by this and just move on to a different data aproach with “list of custom datatypes” which i was trying to avoid because every post i see warns against using them with more than 20 items; but for me it is much simple to add items to list rather than adding datafield to tables and then make nested searches.

Another downside of nested searched is that these operations are generating on average 20WU per data input, with small tables. If i take into account for thousands per month ,on big tables,well its going to be a lot.

I will try to optimize my tables and worflows with your advice and see how it goes.

Thank you

Hello,
Just want to let you know that i implemented the search logic you told me and now the performance is much better, no freezing , i overcomplicated the “only if” condition.

Thank you so much.

1 Like