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 |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |