How to display units (ex: kg) on appsheet?

[akarizky]

Hello everyone, I couldn't find solutions, so I'm trying my luck here.

How to display units (ex: kg) on appsheet ? 

The display on my screenshoot is 75.00, so how to appearing 75.00 kg

I hope you understand what I mean, sorry if my english is bad.

[Suvrutt_Gurjar]

AppSheet numerical columns such as numbers and decimal type cannot have units ( that is text) added to their values.

You could display the units in the column headings the way you have done. If it is must to display units along with the numerical /decimal values, you could construct TEXT type columns with an expression something like 

CONCATENATE([Number Column], " unit") and display these concatenated columns in detail and summary views as necessary with CONTEXT() functions.

Edit: There is a feature request for this requirement and you could upvote it there.

Option to add prefix/suffix to number/decimal type... - Page 2 - Google Cloud Community

[akarizky · Accepted solution]

I've found it, just create a New Virtual Column, and enter the app formula CONCATENATE(TEXT([Total kg Lembar])," kg") works fine! Thanks everyone!!

[Suvrutt_Gurjar]

---

@akarizky wrote:

I've found it, just create a New Virtual Column, and enter the app formula CONCATENATE(TEXT([Total kg Lembar])," kg") works fine! Thanks everyone!!

---

You are welcome. Great. Well, yes that ( creating a text column with concatenation )was the precise suggestion in the beginning itself.

---

@Suvrutt_Gurjar wrote:

If it is must to display units along with the numerical /decimal values, you could construct TEXT type columns with an expression something like 

CONCATENATE([Number Column], " unit") and display these concatenated columns in detail and summary views as necessary with CONTEXT() functions.

---

[Yahia_DAK]

hello everyone,

I specifically developed this application to find an alternative solution to the unit problem you mentioned.
Below is a screenshot of the application and the formulas used.

[Suvrutt_Gurjar]

Thank you for sharing and putting up a neat functionality of multiple selectable units.. Good to know you made use of suggestion to concatenate to display the quantity and unit together in a text column.

[Yahia_DAK]

@Suvrutt_Gurjar 

Thank you very much for your comment. Regarding the concatenation of the unit in the text column, this is the only alternative that can be used since the unit functionality is not native in Appsheet.
The text column remains for viewing and editing reports while the calculations are done on the decimal column.

[Suvrutt_Gurjar]

---

@Yahia_DAK wrote:

Regarding the concatenation of the unit in the text column, this is the only alternative that can be used since the unit functionality is not native in Appsheet.

---

You are absolutely correct. That is what I also mentioned in my first response above.

---

@Suvrutt_Gurjar wrote:

AppSheet numerical columns such as numbers and decimal type cannot have units ( that is text) added to their values.

You could display the units in the column headings the way you have done. If it is must to display units along with the numerical /decimal values, you could construct TEXT type columns with an expression something like 

---