Leading zeros not showing when entering numbers in text columns

Suggestion Box Bugs
1

In a text column of a table, when I add a number, the value is displayed as number type. Leading zeros are not shown.

image
image721Ă—304 13.1 KB

image
image804Ă—365 12.2 KB

@Shaina_Torgerson , could you please take a look. This is urgent for me.

2

:waving_hand: @Breno_Nunes

not sure if its suitable for your use case or temp fix for now (if or when coda fixes issue) but changing column type to canvas and then toggling on “Display editable preview” will display the zeros before the digit.

image
image255Ă—288 1.49 KB

Hope this helps!

Cheers!
Mel

2 Likes
3

Thank your help , @Melanie_Teh.
I’ve been using too many workarounds. I just can’t understand why Coda can’t fix bugs. Let me list another two of them that have been around for a while.

5 Likes
4

heard @Breno_Nunes and wholeheartedly agree.

the changing/auto of text column is a known problem and quite critical in some cases for workflow execution without disruption.

now that the merger is done and dusted, hopefully they revert back to their “quality of life” hackathons (usually in Jan i think which we missed this year cos of merger) and this issue gets picked up by a codan/grammarlian :zany_face:

1 Like
5

I have only recently started to have this issue.
Last week, I was able to store numbers as strings (Such as for area codes, zip codes, serial numbers etc) with the leading zeros.
This week I have just started to have this issue where all of my columns with leading zeros have been reformatted to be missing their leading zeros.

This needs to be fixed immediately as I have been storing thousands of data points that require their leading zeros which have all now disappeared.

Text fields NEED to be true string fields. Not formatted to how they think it should look. If I wanted it as a number, I would have specified it as so.

3 Likes
6

:waving_hand:t5: @Breno_Nunes and @Lin_Silver,

Many thanks for raising this—we’re working on fix, so your leading or trailing zeros don’t have issues.

I’ll respond back once we’ve made the update.

3 Likes
7

:waving_hand:t5: @Breno_Nunes and @Lin_Silver, we’ve made an update that should fix this issue, so you can see the leading zeroes as before.

Please let us know if that’s not the case, we’re happy to dig in more.

Additionally, we’ve also released an update to provide more number format options—you can read more about it here!

4 Likes
8

Thank you very much @Ayuba_Audu.
I’d be great if you could tackle the constantly changing column text type bug next.:smiley:

9

Thank you so much, very appreciated!