# Money field type with currency selector for each record

**URL:** <https://community.fibery.io/t/money-field-type-with-currency-selector-for-each-record/3191>\
**Category:** Ideas & Features\
**Created:** [August 20, 2022, 6:17am UTC](https://community.fibery.io/t/money-field-type-with-currency-selector-for-each-record/3191 "2022-08-20T06:17:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![PetrMyazin](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/petrmyazin/32/5401_2.png) [@PetrMyazin](https://community.fibery.io/u/PetrMyazin)\
**Post date:** [August 20, 2022, 6:17am UTC](https://community.fibery.io/t/money-field-type-with-currency-selector-for-each-record/3191/1 "2022-08-20T06:17:51Z")

</div>

Currently there is Number field type where we can choose Format = Money and then choose a fixed currency for this field.

Proposal: separate field type Money which internally consists of two pieces: a number part and currency, so user (Editor or Contributor) can choose currency while input new data item.

Use case:  
I have a database of invoices, we make invoices in difference currencies: EUR, USD, CNY, …  
Currently I can’t use Number, Format=Money, because I can’t fix one currency. What I do: I create two Fields: 1) Number, Format=Number 2) Single Select with currency selection.  
Disadvantages: formatting. Currency column (Single Select filed) separated from Amount part, looks not so good as Number, Format=Money.

Use case 2:  
I do plan expenses and income (budget), each row can have it’s own currency. For example:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/ec5a7a96966a1d95771a1a6f406022c357665db2.png)

---

<div class="post-metadata">

**Author:** ![Oshyan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/oshyan/32/11431_2.png) [@Oshyan](https://community.fibery.io/u/Oshyan)\
**Post date:** [August 21, 2022, 1:35am UTC](https://community.fibery.io/t/money-field-type-with-currency-selector-for-each-record/3191/2 "2022-08-21T01:35:41Z")

</div>

I don’t think there is any way to have individual Fields configured differently _per-Entity_. I could be wrong but I would guess this is a very challenging and unique requirement _in general_. Your explanation of why it is useful to you here makes perfect sense, I’m just saying that the capability that would enable it - ability to configure each Entity’s fields differently within a single DB - seems difficult and unlikely to be implemented.

As a workaround, if it is primarily about aesthetics, the desire to have a single currency field for _display_, then you could have 3 fields (I know, this is adding yet another field, hah):

- Currency type
- Amount
- Calculation field which concatenates values of Type and Amount together to make a nicer display of actual value in correct currency

E.g.:

- USD
- 53.20
- **$53.20 USD**

You could even add the currency symbol based on value of the Currency Type field, I believe, e.g. “If Currency Type = USD, $”.

---

<div class="post-metadata">

**Author:** ![PetrMyazin](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/petrmyazin/32/5401_2.png) [@PetrMyazin](https://community.fibery.io/u/PetrMyazin)\
**Post date:** [August 21, 2022, 7:25am UTC](https://community.fibery.io/t/money-field-type-with-currency-selector-for-each-record/3191/3 "2022-08-21T07:25:49Z")

</div>

Nice idea to use calculation field! Thank you.