# When importing data from csv, allow to set a static field value (not present in source data) **URL:** \ **Category:** Ideas & Features\ **Created:** [October 10, 2025, 3:42pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785 "2025-10-10T15:42:37Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [October 10, 2025, 3:42pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/1 "2025-10-10T15:42:37Z")
Use case: Importing data from different clients, each uses a different currency. Each client is a difference CSV. Ideally I can set the currency for that import when I’m importing that CSV. The other options are either importing then setting. Or fixing it in the csv before importing. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 10, 2025, 4:01pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/2 "2025-10-10T16:01:41Z")
> [@RonMakesSystems](#): > > Ideally I can set the currency for that import when I’m importing that CSV What does this mean? A currency field is just a number field with some extra formatting, and the formatting is the same for every entity in the db. If you’re importing USD amounts one minute and the importing EUR amounts the next, surely you need to import into different fields each time. ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [October 10, 2025, 4:05pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/3 "2025-10-10T16:05:28Z")
> [@Chr1sG](#): > > currency field is just a number field In my scenario it is a relation to the Currency database from the Currency Exchange integration. > [@Chr1sG](#): > > If you’re importing USD amounts one minute and the importing EUR amounts the next, surely you need to import into different fields each time. Not if you’re specifying the currency on another field! ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 10, 2025, 5:16pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/4 "2025-10-10T17:16:23Z")
So your example is a specific case of a more general need of wanting to import a CSV file whilst setting a fixed value for a to-one relation field (which is otherwise not present in the csv data) right? ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [October 10, 2025, 5:17pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/5 "2025-10-10T17:17:42Z")
Exactly, but the need is not only for a to-one relation field, but any field. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 10, 2025, 5:19pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/6 "2025-10-10T17:19:30Z")
So generically, you want to be able to import data from CSV and have Fibery set the value for a field not present in the data. ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [October 10, 2025, 5:21pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/7 "2025-10-10T17:21:59Z")
Exactly. Sometimes when exporting data from a provider, you can only do it one X at a time (per client, per currency, per whatever). Then this value is not visible in the CSV as it is the same for all of then, this is the use case a feature like this would be helpful. Another use case is tracking imports. Not super needed because the Creation Date tells you when things were created, but might be useful in some cases. So you have an “Import” database, and link to a new entity every time you import, for example. ---
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [October 10, 2025, 5:55pm UTC](https://community.fibery.io/t/when-importing-data-from-csv-allow-to-set-a-static-field-value-not-present-in-source-data/9785/8 "2025-10-10T17:55:19Z")
Thx. I’ve renamed the topic for clarity