# Using a table as a key/value store for avriables

**URL:** <https://community.fibery.io/t/using-a-table-as-a-key-value-store-for-avriables/3939>\
**Category:** Get Help\
**Created:** [February 8, 2023, 6:03am UTC](https://community.fibery.io/t/using-a-table-as-a-key-value-store-for-avriables/3939 "2023-02-08T06:03:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![TAK](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tak/32/6113_2.png) [@TAK](https://community.fibery.io/u/TAK)\
**Post date:** [February 8, 2023, 6:03am UTC](https://community.fibery.io/t/using-a-table-as-a-key-value-store-for-avriables/3939/1 "2023-02-08T06:03:37Z")

</div>

I’m trying to do some calculations that require a set of variables, and rather than writing those numbers directly into forumal’s it would be useful if I could look up a specific row in a table, eg filter on a term in the “key” column and return the value stored in the “value” column.

Is this possible?

Regards  
Tomas

---

<div class="post-metadata">

**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:** [February 8, 2023, 6:13am UTC](https://community.fibery.io/t/using-a-table-as-a-key-value-store-for-avriables/3939/2 "2023-02-08T06:13:03Z")

</div>

Related:

> [@Global Variables](https://community.fibery.io/t/global-variables/2129):
>
> Do you have any plans to create global variables? I guess this is linked to the concept of shared code snippets. It would be great if I could create/set a variable for a given workspace and then use it in formulas.

You could create a database of ‘global variables’ and these can be referenced in _automation_ formulas, but in order to use them in formula fields, you would need to make sure that any entities that need to use them are linked to them.  
This would imply creating a relation between the database of entities that need them and the global variables database, and populating this relation field with the variables for all entities (either using an auto relation or via an automation I guess).