# On a scale of 1 to oh please god don't **URL:** \ **Category:** Get Help\ **Created:** [September 13, 2022, 2:08pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293 "2022-09-13T14:08:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![James](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/james/32/5492_2.png) [@James](https://community.fibery.io/u/James)\ **Post date:** [September 13, 2022, 2:08pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293/1 "2022-09-13T14:08:25Z")
How inefficient is this technique? Since you can’t query a database from a field formula, but you can follow relations… 1. Have a “all data” table with 1 row and a column per other linked table 2. Have a “all data” many-to-one column in each linked table, with every row populated 3. Have a rule for each table to set the column whenever a new row is added 4. Access all your data from any formula (including fields) ---
**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:** [September 13, 2022, 2:57pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293/2 "2022-09-13T14:57:51Z")
It’s not a 1, but it’s not god-worrying 🙂 To be honest, I find an easier method is to add a formula field (called “X” or whatever) which is just the value true. Then create a self-relation (many-to-many) which uses automatic linking where X = X. Now, every entity is linked to every other entity in its own database, and you can do formula queries on the whole db easily. ---
**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:** [September 13, 2022, 3:00pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293/3 "2022-09-13T15:00:00Z")
![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/8cceaa2c69dcfbf59e8830bfc14d4d3177c042a8.png) ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/267c10f0f7972d57b99ff9b94d48ce5ce210b092.png) ---
**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:** [September 13, 2022, 3:04pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293/4 "2022-09-13T15:04:08Z")
![firefox_9RWagHNjih](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/e73ae51812ecab9dd2e199bbe254eee06f7e02f7.gif) ---
**Author:** ![James](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/james/32/5492_2.png) [@James](https://community.fibery.io/u/James)\ **Post date:** [September 13, 2022, 3:20pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293/5 "2022-09-13T15:20:48Z")
nice to know that link is persistent, I assumed it was a one off thing to populate existing rows ---
**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\ **Post date:** [September 13, 2022, 4:38pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293/6 "2022-09-13T16:38:01Z")
Does “X” need to be a formula, or is that only to prevent accidentally changing a value so it no longer matches all? ---
**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:** [September 13, 2022, 4:48pm UTC](https://community.fibery.io/t/on-a-scale-of-1-to-oh-please-god-dont/3293/7 "2022-09-13T16:48:00Z")
It’s a formula to ensure that it’s read-only (even though it is a static value)