Is there a way to limit data to numerics in VARCHAR datatype? We want users to o

judym598

Certified Senior Developer

over 9 years ago

Is there a way to limit data to numerics in VARCHAR datatype? We want users to only enter numbers in a field we have on a form even though it is associated with a VARCHAR datatype.

Discussion posts and replies are publicly visible

Parents

0 PhilB
A Score Level 1
over 9 years ago

You have a number of options - most use validations and various tests - but one of the simplest is just to cast the value parameter of the text field to integer or decimal depending on your requirements:

load(
local!someValue,
a!textField(
label: "Value",
value: tointeger(local!someValue),
saveInto: local!someValue
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 PhilB
A Score Level 1
over 9 years ago

You have a number of options - most use validations and various tests - but one of the simplest is just to cast the value parameter of the text field to integer or decimal depending on your requirements:

load(
local!someValue,
a!textField(
label: "Value",
value: tointeger(local!someValue),
saveInto: local!someValue
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data