I now have four different layouts automatically selected based on the four different expected values in a database field.
Is there any way to have a 5th layout that is shown if the field value does not match an expected value?
Right now, I am using expression
(ADDRESS2.strip()).upper()!='W' and (ADDRESS2.strip()).upper()!='X' and (ADDRESS2.strip()).upper()!='Y' and (ADDRESS2.strip()).upper()!='Z'
(ADDRESS2.strip()).upper() not in
or using the mapping to set another variable = true if a match is found. if that 2nd variable is false then only display the "unknown" layout? Maybe this is not the proper place for this or perhaps I need to create a different post?
There is no default setting as such as it may be that either no template or perhaps multiple templates need to be shown.
I think the way you have it setup is the best way to do it, to make sure the "Default" template is shown it really needs to check the conditions already specified.
Although it is a bit of a long condition I think the way you have done it is fine.
Will that be ok ?
If not then like you said the "not in" option may be a good place to look, but you need to define a list of items and that may be tricky to do inline.
CardExchange Solutions Support Team
"If you define the problem correctly, you almost have the solution." (Steve Jobs)
Thank you for your quick responses. I think I will stick with what I have working. (field != 'x' and field != 'y' and field != 'z' and ......) It is long but right now it is only four conditions so it is manageable.