How to make an error tool limit range of inputs

[BillyL14]

Hi there,

I am trying to make an error message appear on an app. I have a workflow where we have to insert the period of the report, the format will be YYYYMM, i.e. June 2020 = 202006.

I would like to make an expression that says the expression can only be 6 digits long, the first 2 must be "20" and the last two can be from "01" to "12". I have tried a few things but not able to do it so far unfortunately. Any advice?

Thanks a lot

[Ladarthure · Accepted solution]

Hi @BillyL14,

here is a solution to do so,, I just used a block until done to do the test first and then set the test to be true on all records, can be done differently of course, and the test is left(period, 2 ) = '20' and lenght(period) = 6

[BillyL14]

hi @Ladarthure, thank you very much, would there be any way of customising the error message for that way?

[Ladarthure]

Hi @BillyL14, 

you can use the message tool in the developper catergory which allows you to customize messages and choose the level of the message you wnat to have!

Hpe it helped!