Can I get 0000 to display as 0000?

Question

I guess this related to an integration, but it's not an integration-specific question.

We have records that typically accompany a unique number. Sometimes, we will have a record that doesn't have a number. To identify them as records where we've thoughtfully considered them to be records associated with no number, we want to use 0000 as the default, where a single 0 might mean we just forgot to enter the appropriate number.

I'm using a Number field currently -- and I think the field needs to be a number field for the integration. Is there a way to get a Number field to display 0000 instead of 0?

Susan_Stegemann · Accepted Answer

Hello Susan,

You cannot use "0000" as default. However, if all your numbers are positive, a workaround could be to use -1 as a default number.

Right click and the field, edit, toggle allow negative number, go to default and define -1 as a default.

I hope this helps 🙂

That is a brilliant suggestion. I'm going to see if that will suffice. Thank you.

traffik-world · Answer

Hello Susan,

You cannot use "0000" as default. However, if all your numbers are positive, a workaround could be to use -1 as a default number.

Right click and the field, edit, toggle allow negative number, go to default and define -1 as a default.

I hope this helps 🙂

That is a brilliant suggestion. I'm going to see if that will suffice. Thank you.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded