Read the price value, or is it calculated that we can do it on a google sheet or excel

[ADAJALAN]

Is it possible in the appsheet to read the price value, or is it calculated that we can do it on a google sheet or excel,

example
IDR 40,000.00
Then it will read (forty million rupiah)

[Aurelien]

Hi @ADAJALAN

Are you talking about currency conversion ?
If so, you may want to use a calculation with a virtual column in AppSheet, in order to get a rough conversion from one currency to another.

[Rafael_ANEIC-PY]

Hello, I think he’s talking about conversion from number to words, there are no native functions that can accomplish this, but when there’s a will, there’s a way, you can check out this post to learn more about your request:

Convert Number to Text Format Questions

@tsg_despatch Something like this? You’re free to take a copy of this app from my portfolio: Portfolio URL: https://www.appsheet.com/portfolio/245151 App Name: Number2Text

Here’s the link to the sample app:

AppSheet

AppSheet : mobile apps from spreadsheets : Template: Education & Training...

A sample app

[Aurelien]

Hi @Rafael_ANEIC-PY

Thanks for correcting me, you are correct

Also:

help.appsheet.com

EXTRACTPRICES()

Extract list of Price values within text value

help.appsheet.com

EXTRACTNUMBERS()

Extract list of numeric values within text value