ERROR

[Sayad]

I put in the Maximum value 1038991 and Minimum value 1000000. When I put the Valid If expression and set Invalid value error but Invalid value error showing only Valid If condition. When i put wrong gate entry in the form showing already scan this shipment. How can i set two types error.

[SkrOYC]

Again I barely understanded but you want to have another Invalid value error depending on what went wrong?

Take a look a this topic  How To Show a Custom Valid If Error Message - Google Cloud Community

[Joseph_Seddik]

IF() | AppSheet Help Center 

[Sayad]

Sir,

Can you explain me. 

[Joseph_Seddik]

I haven't seen that @SkrOYC  had already replied. First read the guide he quoted, it even contains a video tutorial:

Take a look a this topic  How To Show a Custom Valid If Error Message - Google Cloud Community

---

[Aurelien]

Hi @Sayad 

In your valid_If expression, you will have to set your two conditions. 

Could be:

AND(
  firstConditionToMatch,
  secondConditionToMatch
)

Then, in your Invalid Error message, you can reuse this.

It will be:

IFS(
  NOT(firstConditionToMatch),"YourFirstMessage",
  NOT(secondConditionToMatch),"YourSecondMessage"
)

In your case, first condition will be:

AND(
  [_THIS]<10380000,
  [_THIS]>10000000
)

 (not sure about numbers value...) 

And the second one will be the one you have set.

[Sayad]

Sir, Showing error Yes/No expression in invalid error.  

[Aurelien]

Can you share your expression ?

[Sayad]

Sir, How can I set this expression in Error_Message_If_Invalid

IFS(
NOT(firstConditionToMatch),"YourFirstMessage",
NOT(secondConditionToMatch),"YourSecondMessage"
)

 

 

 

[graham_howe]

@Aurelien was suggesting a syntax for the function not the actual words to use. You will need to put in whatever condition logic you require, for example:

IFS(
  NOT([_THIS]<1038991), "The value is too big",
  NOT([_THIS]>1000000), "The value is too small"
)

[Sayad]

Ok, and how will the valid error message show up? 

[Sayad]

How can set one more condition.

[Aurelien · Accepted solution]

@Sayad 

I suggest you have a look here:

https://help.appsheet.com/en/articles/2355961-ifs

https://help.appsheet.com/en/articles/2347624-and

https://help.appsheet.com/en/articles/2357288-or

App expressions are pretty similar to what you can use under Google Sheets or MS Excel.

You have to build your expression using such syntax.

For your case, the expression you need to set for the Message error is:

IFS (
  NOT(AND([_THIS]>1038991,[_THIS]<1000000)),"Invalid Gate Entry No",
  (your actual expression here, without the NOT),"Already scan your shipment"
)

Please note this is my last contribution to this post.

EDIT: minor change

EDIT @Sayad I removed one extra parenthesis. with the AND expression. (typed it too fast)