Skip to main content
Question

Writing a input formula that only allows a specific format

  • December 3, 2021
  • 0 replies
  • 102 views

Hello,
I would like to write a formula for a input field that only allows input of an IP address. What is the best field type to use for this?
Thanks!

------------------------------
Phil Heron
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
The field type would need to be a text field because an IP address is a mixture of numeric and non numeric characters.   Then you would need to develop a formula which calculates whether the IP address is in a valid format.   Once you have that formula you can block the save either by using custom data rules or a form rule to let the user know that the IP address is not a valid format. 

As for what that formula that would look like, first you would have to state what the rules are for a valid IP address and then if you're unable to write that formula a few of us could pitch in with ideas. But there is no built-in edit mask in need of QuickBase to validate a string meets the criteria of being a valid IP address.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------