Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago

Custom Separator In Text Field

Is it possible to create a custom separator in a text field? For example, if I want the input to be 4 characters, period, 3 characters, period, 3 characters. Can I set this as an input, similar to the separator selection in a numerical field (but custom)?

------------------------------
Mike Tamoush
------------------------------

1 Reply

  •  I think you would have to do this with two separate fields. One would be at a dead entry field and the other would be a display field.
    I think because you're going to display back to the user in your dots separated format, there's a good chance that the users at least some of them might enter the data in that format. So the formula will probably have to strip out any non-alpha numeric characters like a period,  and then format the data to re-introduce the dot separators in the correct locations. 


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------