Mask edit

Developers Programming
#1

Hi,

Is it possible to have a visible mask on a field? For example: latitude/longitude fields have a mast as follow ??._?S if the data is in degrees, minutes and seconds. I would like to be able to force the user to enter the data according to that mask and then convert it to decimal degrees when saving and from decimal degrees when loading.

Any ideas?

Take care,
Sifa

#2

Re: Mask edit

Select your field in the form and under general settings, there is Grid Mask. Enter your mask there.
###-##-#### is an example for SSN

Regards,
Scott.

#3

Re: Mask edit

Thanks Scott, I will try it and report back…

#4

Re: Mask edit

Hi Scott - I now remember looking into this previously… SC cannot handle that particular mask. I get parse errors

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING

because this is the code that is generated

$this->nm_tira_mask($this->latitude, “xxx?xxx’xx.xx"S”);

…

#5

Re: Mask edit

Just taking shots here …

Can you set the mask like a regular expression?

??._… the other option may be to use the CHR(ascii) function to bypass the parsing error.

Regards,
Scott.

#6

Re: Mask edit

Thanks Scott - what you suggested works mostly. SC has a problem with the apostrophe and the double-quote though. Thanks for your assistance.

take care,
sifa