The Quick Base Community will be read-only from August 19th-23rd while we finalize the updates to launch our new community site. On August 23rd the new community site will be live and accessible right here at this same URL with the full launch on August 27th with a special AMA with Jay Jamison on our exciting Cloudpipes news.
If you run into an issue while we are working on our migration you can reach out to our Care team via a Care case for help. There is a link to submit a case right on the Community home page or at our Contact Us page at www.quickbase.com. Thank you for your patience while we work behind the scenes.
I'd like to have a numeric field defined to only hold (6) digits (no decimals). But I'd like it displayed as "12345-6" with the hyphen. I didn't see a field masking function, and a formula formatting does not take the current value being entered.
You won't be able to use a hyphen in a numeric field. You can however create a formula text field and set the max characters to 7 (will include the hyphen) and use a formula based on the number field you have. Here's an example:
You can call this formula text field anything you want but remember its' only a text representation of your number field and you can't do math with text unless you convert it back to numbers (but you already have the original number field).