Ask Your Question

How to hide sections depending on two fields in a database [closed]

asked 2013-01-11 13:25:43 +0200

ChrisCardiff gravatar image

updated 2013-02-01 10:35:02 +0200

qubit gravatar image

I want to hide a section of a letter if two fields in a database are true, species = Feline and sex = Female. So, I create the section, then tick the 'hide' box and enter the first condition to hide : recalls.Sheet1.Species=="Feline the second condition is recalls.Sheet1.Sex=="Female".

Each of these conditions works fine alone, but I can't find the right operator/syntax to link the two conditions together - I've tried AND And and &

where am I going wrong?



edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-20 19:12:02.984832

2 Answers

Sort by » oldest newest most voted

answered 2013-01-22 10:35:58 +0200

ChrisCardiff gravatar image

Thanks for this - but I'm still stuck!

In the help index tab: conditions;in fields and sections it says

When you define a condition, use the same elements for defining a formula, namely comparative operators, mathematical and statistical functions, number formats, variables and constants.

Looking at the "elements" it shows to use the Boolean AND, which is what I've tried, but without success. Is there some punctuation I need to use around the AND operator?



edit flag offensive delete link more

answered 2013-01-11 23:45:06 +0200

m.a.riosv gravatar image

Search in the help index tab: conditions;in fields and sections

edit flag offensive delete link more

Question Tools


Asked: 2013-01-11 13:25:43 +0200

Seen: 92 times

Last updated: Jan 22 '13