autoformat user input text field
Hello, I want to create a text field that would auto-format a number entered in an open to the public app to include dashes in the correct locations. I need a dash after the first two numbers a...
Forum Discussion
Two fields would be needed
Pre Dash, Text Field
Dash, Formula Text Field
This should work for the formula
// Create Dash Text Output format XX-ABCD....-XX
// Capture Left Two Characters
var text LeftTwo = Left([Pre Dash], 2);
// Capture Right Two Characters
var text RightTwo = Right([Pre Dash], 2);
//Capture 1st part of the middle
var text MiddleOne = NotLeft([Pre Dash], 2);
// Capture Full Middle
var text Middle = NotRight($MiddleOne,2);
// Create the Output
var text Output = List("-", $LeftTwo, $Middle, $RightTwo);
$Output
------------------------------
Don Larson
------------------------------
Pre Dash, Text Field
Dash, Formula Text Field
This should work for the formula
// Create Dash Text Output format XX-ABCD....-XX
// Capture Left Two Characters
var text LeftTwo = Left([Pre Dash], 2);
// Capture Right Two Characters
var text RightTwo = Right([Pre Dash], 2);
//Capture 1st part of the middle
var text MiddleOne = NotLeft([Pre Dash], 2);
// Capture Full Middle
var text Middle = NotRight($MiddleOne,2);
// Create the Output
var text Output = List("-", $LeftTwo, $Middle, $RightTwo);
$Output
------------------------------
Don Larson
------------------------------
Excellent, thank you.
------------------------------
Rhonda Jones
------------------------------
------------------------------
Rhonda Jones
------------------------------