Skip to main content

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? 

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 🙂

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.

Reply


Terms & Conditions