Two conditon Invalid value error

AppSheet AppSheet Q&A
, ,
1

Hi,

When I write this expression, it shows an error. I want to show two types of errors in the appsheet form column [ Gate Entry No ]. [Gate Entry No] is the key column When the user types in a duplicate entry, he should see an error message. But I do not understand this expression . Can you help me solve this?

I have given you the below error screenshot please view and reply to me.

screeenshot
screeenshot871Ă—570 41.4 KB

screenshot
screenshot718Ă—519 32.6 KB

2

I corrected my suggestion, I typed it too fast.

You have one extra parenthesis after the AND() part

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/ERROR/m-p/403611#M158236

1 Like
3

IFS (NOT(AND(AND([_THIS]>1038991,[_THIS]<1000000)),“Invalid Gate Entry No”,
(IN([_THIS],SELECT(CAMPUS SCAN SHEET[GATE ENTRY NO],[GATE ENTRY NO]=[_THIS].
[GATE ENTRY N0]),“Already scan your shipment”
))))

4

Hi @Aurelien

Show error:- Condition AND(AND(([_THIS] > 1038991), ([_THIS] < 1000000))) has an invalid structure: at least 2 subexpression(s) required

5

https://help.appsheet.com/en/articles/961274-list-expressions

IFS (
  NOT(
    AND([_THIS]>1038991,
        [_THIS]<1000000
    )
  ),
  "Invalid Gate Entry No",
  IN([_THIS],
      SELECT(CAMPUS SCAN SHEET[GATE ENTRY NO],
          [GATE ENTRY NO]=[_THIS]
      )
  ),
  "Already scan your shipment"
)

or, suggestion:

IFS (
  NOT(
    AND([_THIS]>1038991,
        [_THIS]<1000000
    )
  ),
  "Invalid Gate Entry No",
  ISBLANK(
    FILTER(
      "CAMPUS SCAN SHEET",
      ([_THIS] = [GATE ENTRY NO])
    )
    - LIST([_THISROW])
  ),
  "Already scan your shipment"
)
1 Like