Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Ferdi]

hi,

Can anyone help me: I want to add a library field 'xyz', which's value is calculated, based on what the value of the fields 'a' and 'b' are. I know how to add fields, but can't get the formula right:  

if value of field 'a' = empty AND value of field 'b'=empty, then value of 'xyz' tagged'. Else value of field 'xyz' = 'not tagged'

I found the formula 'isempty[field]', but can't figure out how to check this or two fields.

many thanks!

[MrC]

There are a couple of tricks you can use to simulate AND operations, and some more still when you're just testing for emptiness in both.  Let's shoot for the latter.  If A is empty and if B is empty, then the concatenation of A and B is also empty.  So, you can use this:

   if(isempty([A][B]), both empty, not both empty)

Other ways to simulate AND, OR and XOR:

    http://wiki.jriver.com/index.php/Database_Expressions_AND_OR_And_XOR

[Ferdi]

Ingenious. I am glad I asked, I'd never would have come up with that!
Thanks much, Mr. C!