Strange formatting when using the "prefix/postfix" option in columns display format

[hanc]

Hi all,

I expect that the “prefix/postfix” option add some text to the end or beginning of the value that I want change, but instead I have unexpected results.

How can i achieve the desired result (without using the formula)?

Thank you.

[Michael_Kosorukov]

Hi Hanc, can you please explain in more detail (ideally illustrate or provide the reference point) what you’d like to achieve? What you’ve shown is intended behaviour, but I might’ve missed your point.

[hanc]

Hi Michael,

Imagine you have a text field that displays a phone number. Now I want to add the prefix at the beginning of the number (the field is a Text).

Original phone number: 758485695

Now I use the display format utility to add the “0” at the beginning of the string.

This is what I expect
New phone number: 0758485695

But actually the value changes as shown in the previous post. So I don’t understand the logic of this feature.

[Michael_Kosorukov]

I see, may I ask you to share this page’s URL? We;ll llook into this

[hanc]

Hi Michael,

You can simple create a new project from a template, select a table column, and change the display format using the prefix/postfix.

Before

After

As you can see I added the letter “I” as a prefix but the content has completely changed.