Pre-Filter Records for Record Selector

🧩 Low-Code Development
#1

Hi everyone! I’m new to the community, so Hello World.

I need to use a conditional filter based on multiple values. When working with just one value it works without issues
record.values.txt_Input_Activity != “SEL”

What I need to do is something like this:
record.values.txt_Input_Activity != “SEL” OR “Trusted_Contact” OR “OtherValue”

Do you know any syntax that could work on this scenario? I’ve attached the image f the conditional field.

Thanks in advance,

2024-12-06_09-26-56
2024-12-06_09-26-561130Ă—380 22.5 KB

#2

Hey, you can use !has(record.values.Field, "Value")

Note: You’ll have to save the record for the condition to evaluate, there is currently a bug with conditional fields and multi values which is being fixed.

Docs: Expression Function Reference :: Corteza Docs

#3

Thanks for your help!

That expression is not working. I got the following error:

Failed to evaluate record block conditional fields: 417249149906386947: can not evaluate has(record.values.txt_Input_Activity, “SEL”): runtime error: invalid memory address or nil pointer dereference.

Maybe I have to use something else to make it work?

#4

I now see I misunderstood the question. You’re not talking about multi value fields at all.

To use OR in the expression you need to use the || symbol instead of OR.

so for example record.values.Field == "Foo" || record.values.Field2 == "Bar"

Docs: Expressions :: Corteza Docs

The has function is for use with multi value fields.

#5

Thanks, that option worked.

Here is an example
record.values.txt_Input_Activity == “Assessment” || record.values.txt_Input_Activity == “Crisis_Room” || record.values.txt_Input_Activity == “Partner_Event”

1 Like
#6