Possible to use conditions in Rules for Field Definitions?

[Glen Collins]

Hello. I have a "Rules for Field Definition" setup for lookup and set value. I'm wondering if it's possible to use a condition statement to set a form value if nothing is returned. I've tried a few things taking samples from the wiki but I have not been successful.

So basically what I need to do is search for dates in a form and if the date exists set a form value (textbox) to Yes and if it does not exist set the form value to No.

I tried something like:

if(![entry.field1], Textbox1=Yes, Textbox1=No)

I tried encasing the search field in parens and also the values and still no luck. I'm not even sure if it's possible as I've found no good samples. I'm still looking but I figured I'd throw this out there and see where it leads.

Thanks!

Glen

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

There is a [entry._count] returned

And if that is 0 then your lookup basically has returned nothing

Alex

[Glen Collins]

Thanks Alex! This is what I just did and it works....

Support=(IF(EMPTY("[entry.SupportAnswer]"), "No", "Yes"))

Works as I hoped for!

Thanks!

Glen

[Alex Medved _ConfiForms_]

Also a good way to solve this! 

As usual, there are multiple ways to do the same thing in ConfiForms :-)