Writing a input formula that only allows a specific format
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 ------------------------------1View0likes1CommentLimit URL field to specific Sites? Possible?
Hey Community, We are using Quickbase to to manage larger customer projects in our true CRM, which is Salesforce. I created a hyperlink field in Quickbase so our users and quickly jump from Program to program. I want to try and make a rule in Quickbase so that only Salesforce URLs can be used in this field and they can't throw anything into that spot like google or yelp or w/e. Any suggestions on how to make this rule in my app? Thank you, ------------------------------ Jack Woods ------------------------------7Views0likes4CommentsOR in a Custom Data Rule
Hello...not the most experienced person with QuickBase, but I am trying to build a Custom Data Rule to prevent any employee from entering a time not in our current work week. It works fine, until I add the OR statement to allow me OR my manger to be able to make an older entry. (It works fine if I only name one of us, but fails with both names. The first part with the End and Start times works fine also.) If([End Time]<[Start Time], "End Time cannot be before Start Time", [End Time]=[Start Time], "End Time cannot be the same as Start Time", not IsUserEmail("david@example.com") or not IsUserEmail("jason@example.com") and ([Date]>[Test Date] or [Date]<[Test Date]-Days(7)),"Date must be in current work week") What am I missing? Probably just a set of () somewhere. But I can't figure it out. Any suggestions? Thank you! ------------------------------ David ------------------------------3Views0likes1Comment