English Español Deutsch Italiano Polski Nederlands Português Français 中文 日本語 हिन्दी اللغة العربية Русский Українська עִברִית Ελληνικά Türk Latvietis Dansk Norsk Íslenska 한국어 Suomen Gaeilge Bahasa Melayu Svenska Čeština
Log In
English

Log In

 

The Currency

How to add the currency to a value

You can add the currency to numeric fields ("Number", "Decimal", "Formula").

Open the field editing page.

Open the "Settings" tab and activate the "Show currency" option:

The currency format looks like this: %u%n ("Currency + Number") by default. If you want to change the order, specify the format: %n%u, the currency will be displayed to the right:

Specify the denomination of the currency.

If you want to add a space between the number and the currency, add a "space" before or after the denomination:

As a result, you will get a column with currency:

Using the records import from Excel or CSV, the currency must be specified manually, otherwise the system will import the column as "Single line".

Please note: if your document has a numeric separator "," (comma), the system will import the column as "Decimal". You can change the separator from dot to comma (works only for data output) on the field editing page.


Please, login to QuintaDB to be able to post comments
Share the discussion in the social networks: