hi, is there a way to format the view of a value without change the cell value.
For example : in a row of my column [phone] i have this phone value : 0601010101
I would like that the user can see the number like that on view detail : 06 01 01 01 01
but I need to have only 10 numerics caracteres in this cell.
Hi @Flo
You may want to check this:
[Show/store mobile number in the correct format](https://community.appsheet.com/t/show-store-mobile-number-in-the-correct-format/12218/16) Questions
Okay, thanks Aleksi, it’s working with the Excel fields set to Text
[Data type characters validation?](https://community.appsheet.com/t/data-type-characters-validation/15568/4) Questions
Hi @techno_gateways, For 10 digit numeric mobile phone numbers , you may wish to try valid_if expression of AND(NUMBER([_THIS])>=1111111111, NUMBER([_THIS])<=9999999999) with column type as phone Testing showed that the expression invalidates all non numeric characters.-alphabets and special characters and any phone number less than 10 digits or more than 10 digits long.
thanks but my purpose is to find a way to show the value of a cell in a different way that the value is stored.
An other example : I have a date time value 17/08/2021 16:50 and I want to show only the date in the row detail but i need to keep the date time format in the column.
Display Value Feature Requests
Similar to how you can assign a Display Name for a column that shows instead of the column name, I’d like to be able to specify a Display Value. Example: Say I have a table of contracts, each with a contract ID, like “122”,“133”,“144”. But I want these contract ID values to be displayed as “C-122” , “C-133” , “C-144” So for the Display Value field I would enter: “C-” & [_THIS] Obviously I could create another column to just concatenate a “C-” onto the id, but that seems unnecessary. I also …
OK. Then, you can use a virtual column with this:
Flo:
hi, is there a way to format the view of a value without change the cell value.
In short, no.
It’s not the best idea but you can create a virtual column and use CONCATÉNATE() and MID () To assemble right version. For original column with phone number you can use Valid if: LEN([_ThisRow].[phone number])=10