Combine this expression

AppSheet AppSheet Q&A
, , , ,
1 
NOT(IN([_THIS], Form Table[AWB NO])

"Already scanned this Shipment on " &
SELECT(Form Table[Scanned Date], [AWB NO] = [_THISROW].[AWB NO])

How to combine this expression with the expression given below

Valid If formula for column AWB

AND(AND
(ISBLANK(
  FILTER(
    "CAMPUS SCAN SHEET",
    ([_THIS] = [AWB NO])
  )
  - LIST([_THISROW])
),

LEN([AWB NO]) > 6),

NOT(
  OR(
    CONTAINS([_This], "CRP"),
    CONTAINS([_This], "~"),
    CONTAINS([_This], "&"),
    CONTAINS([_This], "_"),
    CONTAINS([_This], "MYNR0"),
    CONTAINS([_This], "/"),
    CONTAINS([_This], "CAMPU")
  )))

Error_Message_If_Invalid formula for column AWB NO (Text)

IFS(
  IN(
    [_THIS],
    SELECT(
      CAMPUS SCAN SHEET[AWB NO],
      [AWB NO]=[_THIS].[AWB NO]
    )
  ),
  "Already Scanned This Shipment",
  NOT(
  OR(
    CONTAINS([_This], "CRP"),
    CONTAINS([_This], "~"),
    CONTAINS([_This], "&"),
    CONTAINS([_This], "MYNR0"),
    CONTAINS([_This], "_r1"),
    CONTAINS([_This], "CAMPU")
    )
  ),
  "Invalid Entry, Rescan AWB NO"
)
2

I responded to this in your other post.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Duplicate-Remark/m-p/480074#M189194

1 Like