Hi
New to Appsheet so apologies if this is really simple to everyone else.
I have a form that I show the next field to a user based on the selection of the previous field, so often Enum options etc
I have a field (FIELD A for this example) that actually needs multiple expressions I think as it has to be displayed from a couple of other fields (that probably makes no sense)
Here is my show_if statement:
AND([contractortype]=“Maintenance T”, [quotetype]=“Manual Quote”)
great! that works, Field A is displayed when ‘Maintenance T’ and ‘Manual Quote’ options are selected
but I also need to add
ISNOTBLANK ([tradeuser])
I don’t know how to write that expression, I can make either expression work alone but not when together
Is there a simple way to make both expressions work together?
As a beginner I thought I could just literally do this:
AND([contractortype]=“Maintenance T”, [quotetype]=“Manual Quote”)
ISNOTBLANK ([tradeuser])
Be grateful for any advice
I’m not clear exactly what you want. It sounds like:
OR(
AND(
[contractortype]=“Maintenance T”,
[quotetype]=“Manual Quote”
),
ISNOTBLANK([tradeuser])
)
Steve
That worked perfectly, exactly what I wanted. I’ve spent hours trying to make that work, now I will try and learn the logic in that expression.
Thanks so much, fantastic support.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |