How to set format of a string

[Chris_Veale]

I’ve searched but am struggling to find an answer

Is there a way to confirm that the string result is in a certain format? Ive seen length of string which may go someway to help
Users need to input a field in the format of
LNNNLLL
Where L is a Letter and N is a number - Its a reference number

Anyway that this can be validated with code to avoid user error in the input?

[ABG]

How about 7 adjacent small List Pickers, each for a letter (1,5-7) or number(2-4)?

[TIMAI2]

Textbox Extension and some regex and maybe a regex extension

[ABG]

Even with forcing the format, you still have to go out to your data base and lookup
some name and description data to confirm the right key was written.

[TIMAI2]

Slightly longwinded blocks but it works with Taifun’s Textbox extension doing the heavy lifting

refNumber.aia (22.7 KB)

BLOCKS

[codo]

Only tested parts of it, but think something like this should work (see below). Probably best to restrict user input to only be able to enter: LNNNLLL, then give error message to correct format.

[Chris_Veale]

Thanks - I ended up using Taifun Tools extension with some regex

[Chris_Veale]

Good point - Ive got a workaround for that at the moment - it flags as a new record but next up is to validate “live”