Help

Can I get 0000 to display as 0000?

Topic Labels: Data Integrations
Solved
Jump to Solution
835 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Susan_Stegemann
5 - Automation Enthusiast
5 - Automation Enthusiast

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? 

1 Solution

Accepted Solutions

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

See Solution in Thread

2 Replies 2
traffik-world
5 - Automation Enthusiast
5 - Automation Enthusiast

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.