# Get Help

**URL:** https://community.fibery.io/c/get-help/5.md?page=34

[Latest](https://community.fibery.io/latest.md) · [Categories](https://community.fibery.io/categories.md) · [Tags](https://community.fibery.io/tags.md)

**Page:** 35

---

## [Script Request: Mark duplicates in relational DB](https://community.fibery.io/t/script-request-mark-duplicates-in-relational-db/3182)

<div class="topic-metadata">

**Author:** [@Maximilian\_Breckbill](https://community.fibery.io/u/Maximilian_Breckbill)\
**Replies:** 6\
**Last updated:** [August 18, 2022, 12:58pm UTC](https://community.fibery.io/t/script-request-mark-duplicates-in-relational-db/3182 "2022-08-18T12:58:16Z")

</div>

Hi Fibery Community - I’m looking for help creating a simple script for my relational DB. Basically, every time a new entity is created in my relational DB, I’d like the automation to scan the DB for duplicates. If it f…

---

## [To-Many Hierarchical Relations and Filtered Lists](https://community.fibery.io/t/to-many-hierarchical-relations-and-filtered-lists/3124)

<div class="topic-metadata">

**Author:** [@ccollins](https://community.fibery.io/u/ccollins)\
**Replies:** 1\
**Last updated:** [August 18, 2022, 6:39am UTC](https://community.fibery.io/t/to-many-hierarchical-relations-and-filtered-lists/3124 "2022-08-18T06:39:09Z")

</div>

I have two questions below. I’m trying to go back through my workspace and simplify some structures. If anybody has any ideas/advice on either of these issues I’d greatly appreciate it. Hierarchical Relations for One/Ma…

---

## [How can I only show user type specific views?](https://community.fibery.io/t/how-can-i-only-show-user-type-specific-views/3177)

<div class="topic-metadata">

**Author:** [@ccollins](https://community.fibery.io/u/ccollins)\
**Replies:** 4\
**Last updated:** [August 17, 2022, 5:01pm UTC](https://community.fibery.io/t/how-can-i-only-show-user-type-specific-views/3177 "2022-08-17T17:01:52Z")

</div>

Different roles within my company need different views for the same database. Some people require formula fields for analysis, some need just the data entry fields, some just need statuses. As far as I can tell, the curr…

---

## [Formula to check if the description field (rich text) is empty or not?](https://community.fibery.io/t/formula-to-check-if-the-description-field-rich-text-is-empty-or-not/1162)

<div class="topic-metadata">

**Author:** [@nimesh](https://community.fibery.io/u/nimesh)\
**Replies:** 8\
**Last updated:** [August 5, 2022, 2:51pm UTC](https://community.fibery.io/t/formula-to-check-if-the-description-field-rich-text-is-empty-or-not/1162 "2022-08-05T14:51:07Z")

</div>

I have been trying to figure out the formula to check if the description(rich text) is empty or not. So, a little help would be very helpful. Thanks.

---

## [Use updateEntity with multi-select fields](https://community.fibery.io/t/use-updateentity-with-multi-select-fields/3108)

<div class="topic-metadata">

**Author:** [@cannibalflea](https://community.fibery.io/u/cannibalflea)\
**Replies:** 3\
**Last updated:** [August 5, 2022, 12:19pm UTC](https://community.fibery.io/t/use-updateentity-with-multi-select-fields/3108 "2022-08-05T12:19:16Z")

</div>

I was trying to find examples of how to add multiple items to multi-select fields using scripts and the updateEntity function. I was passing in the following values object to the function: { Name: 'Test task', Assig…

---

## [Insert entity reference with scripts or markdown templates](https://community.fibery.io/t/insert-entity-reference-with-scripts-or-markdown-templates/2976)

<div class="topic-metadata">

**Author:** [@cannibalflea](https://community.fibery.io/u/cannibalflea)\
**Replies:** 2\
**Last updated:** [July 25, 2022, 4:42am UTC](https://community.fibery.io/t/insert-entity-reference-with-scripts-or-markdown-templates/2976 "2022-07-25T04:42:15Z")

</div>

I am wondering if there is currently a way of inserting entity references in rich text areas via scripts or through markdown templates. The help page on markdown templates seems to show only inserting some attributes as…

---

## [HELP! - I just deleted an important DB by mistake](https://community.fibery.io/t/help-i-just-deleted-an-important-db-by-mistake/3101)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 0\
**Last updated:** [July 23, 2022, 7:21pm UTC](https://community.fibery.io/t/help-i-just-deleted-an-important-db-by-mistake/3101 "2022-07-23T19:21:46Z")

</div>

UPDATE: OK, I was able to un-delete it from the Audit log. At first I did not see how to do it (no checkboxes were available for the restore operation). I can’t un-delete it from the Audit log :sob:

---

## [What am I doing wrong?](https://community.fibery.io/t/what-am-i-doing-wrong/3080)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 10\
**Last updated:** [July 19, 2022, 2:48pm UTC](https://community.fibery.io/t/what-am-i-doing-wrong/3080 "2022-07-19T14:48:12Z")

</div>

I want this Rule to set “Start Date” (which is working), and then set “Due Date” to be 7 days later, but “Due Date” is always empty after this Rule runs:

---

## [Formulas cannot reference a DB directly?](https://community.fibery.io/t/formulas-cannot-reference-a-db-directly/3076)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 1\
**Last updated:** [July 15, 2022, 7:58pm UTC](https://community.fibery.io/t/formulas-cannot-reference-a-db-directly/3076 "2022-07-15T19:58:32Z")

</div>

Maybe I’m crazy, but I thought in Formulas we used to be able to reference any DB directly (and then filter it, etc). Or maybe this was only available in Rules?

---

## [Appending an entity name if an rich text field is not empty](https://community.fibery.io/t/appending-an-entity-name-if-an-rich-text-field-is-not-empty/3071)

<div class="topic-metadata">

**Author:** [@pattricia](https://community.fibery.io/u/pattricia)\
**Replies:** 1\
**Last updated:** [July 14, 2022, 8:34am UTC](https://community.fibery.io/t/appending-an-entity-name-if-an-rich-text-field-is-not-empty/3071 "2022-07-14T08:34:48Z")

</div>

Hello Fibery Folks, I have the following challenge that I need some support with. Some of the entities in my database contact a rich text description. I’d like to run a rule or a script that would let me do the followin…

---

## [API select query on state or description field does not work](https://community.fibery.io/t/api-select-query-on-state-or-description-field-does-not-work/3069)

<div class="topic-metadata">

**Author:** [@Lug-gl](https://community.fibery.io/u/Lug-gl)\
**Replies:** 3\
**Last updated:** [July 14, 2022, 7:19am UTC](https://community.fibery.io/t/api-select-query-on-state-or-description-field-does-not-work/3069 "2022-07-14T07:19:06Z")

</div>

Hey, I’m trying to select the single-select field “State” and rich text field “Description” via API. For both I’m not quiet sure, if I’m doing something wrong: \[ { "command": "fibery.entity/query",…

---

## [Is this setup possible?](https://community.fibery.io/t/is-this-setup-possible/3059)

<div class="topic-metadata">

**Author:** [@Chris\_Campanile](https://community.fibery.io/u/Chris_Campanile)\
**Replies:** 6\
**Last updated:** [July 11, 2022, 7:24pm UTC](https://community.fibery.io/t/is-this-setup-possible/3059 "2022-07-11T19:24:39Z")

</div>

Hi, new to Fibery, but familiar with concepts and similar tools. For those more experienced, I’m wondering if this is within reach: Multiple Spaces/DBs will all have a “Notes” field for majority of my Entities. For th…

---

## [How can I delete a duplicate entry automatically?](https://community.fibery.io/t/how-can-i-delete-a-duplicate-entry-automatically/1968)

<div class="topic-metadata">

**Author:** [@karthikk\_vijay](https://community.fibery.io/u/karthikk_vijay)\
**Replies:** 6\
**Last updated:** [July 6, 2022, 3:55pm UTC](https://community.fibery.io/t/how-can-i-delete-a-duplicate-entry-automatically/1968 "2022-07-06T15:55:37Z")

</div>

Hey everyone, nice to be a part of the fib fam :slight\_smile: So, we import lots of data through CSV, and sometimes there might be duplicates from different files that get imported into the same type. Is there a way th…

---

## [Filtered Assignees Formula](https://community.fibery.io/t/filtered-assignees-formula/3034)

<div class="topic-metadata">

**Author:** [@ccollins](https://community.fibery.io/u/ccollins)\
**Replies:** 4\
**Last updated:** [July 5, 2022, 7:53pm UTC](https://community.fibery.io/t/filtered-assignees-formula/3034 "2022-07-05T19:53:56Z")

</div>

I’m trying to create a project-level formula that shows all assignees for the project’s tasks but only for the tasks that are not yet completed. I feel like this should be possible, but am struggling to figure out how to…

---

## [Planhat and Chargebee integration](https://community.fibery.io/t/planhat-and-chargebee-integration/3024)

<div class="topic-metadata">

**Author:** [@Philippe\_Pinault](https://community.fibery.io/u/Philippe_Pinault)\
**Replies:** 1\
**Last updated:** [July 1, 2022, 5:30pm UTC](https://community.fibery.io/t/planhat-and-chargebee-integration/3024 "2022-07-01T17:30:38Z")

</div>

Hi there, I’m new to this forum and a heavy user of Fibery :slight\_smile: I’m not a tech guy and would like to integrate Planhat (https://www.planhat.com/) and Chargebee (https://www.chargebee.com/) to Fibery. These ap…

---

## [Can Automations update a State field using a Formula?](https://community.fibery.io/t/can-automations-update-a-state-field-using-a-formula/3007)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 1\
**Last updated:** [June 28, 2022, 7:07am UTC](https://community.fibery.io/t/can-automations-update-a-state-field-using-a-formula/3007 "2022-06-28T07:07:20Z")

</div>

I was expecting that I could simply return the string Name of the State I want to select, but the Type required from the Formula is apparently the State type itself, and I see no way to filter or return this Type.

---

## [Upgrading to paid plan - no monthly option 🙁](https://community.fibery.io/t/upgrading-to-paid-plan-no-monthly-option/3004)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 2\
**Last updated:** [June 27, 2022, 1:20pm UTC](https://community.fibery.io/t/upgrading-to-paid-plan-no-monthly-option/3004 "2022-06-27T13:20:38Z")

</div>

My trial has expired and I want to upgrade to a paid plan. :smiley: However, on the upgrade page, I don’t see an option to select monthly payments, only annually. This will be a much easier sell if I can continue on a …

---

## [Formula Question (Text Multiplier)](https://community.fibery.io/t/formula-question-text-multiplier/3003)

<div class="topic-metadata">

**Author:** [@ccollins](https://community.fibery.io/u/ccollins)\
**Replies:** 2\
**Last updated:** [June 27, 2022, 4:50am UTC](https://community.fibery.io/t/formula-question-text-multiplier/3003 "2022-06-27T04:50:06Z")

</div>

I couldn’t find any other threads about this. Thank you to any advice in advance. Text Multiplier Are there any functions that would let me multiple text? My specific use case would be having emojis represent a count …

---

## [Where did the "Json" field type go?](https://community.fibery.io/t/where-did-the-json-field-type-go/2872)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 16\
**Last updated:** [June 18, 2022, 5:47pm UTC](https://community.fibery.io/t/where-did-the-json-field-type-go/2872 "2022-06-18T17:47:43Z")

</div>

Yesterday I noticed a new field type “Json” and was able to play with it briefly. But today it is gone :worried:

---

## [How to update Workflow State in a Rule via Formula?](https://community.fibery.io/t/how-to-update-workflow-state-in-a-rule-via-formula/2970)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 0\
**Last updated:** [June 17, 2022, 9:42pm UTC](https://community.fibery.io/t/how-to-update-workflow-state-in-a-rule-via-formula/2970 "2022-06-17T21:42:19Z")

</div>

I can’t wrap my head around how to do this. I want something like: If( MatchRegex(\[Step 1 Task\].State.Name,"Waiting"), \[Step 1 Task\].State.Filter(Name="Progress").Sort().First(), // Choose a new State \[Step 1 Task\].Stat…

---

## [Integromat: retrieving images from Fibery?](https://community.fibery.io/t/integromat-retrieving-images-from-fibery/2895)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 2\
**Last updated:** [June 9, 2022, 2:53pm UTC](https://community.fibery.io/t/integromat-retrieving-images-from-fibery/2895 "2022-06-09T14:53:57Z")

</div>

I’m building an Integromat scenario that pushes my new Fibery Task entities to Asana. So far mostly working, except I don’t know what to do about images embedded in Rich Text fields, which are referenced in the markdown…

---

## [Global parameters/variables workaround?](https://community.fibery.io/t/global-parameters-variables-workaround/2903)

<div class="topic-metadata">

**Author:** [@Dimitri\_S](https://community.fibery.io/u/Dimitri_S)\
**Replies:** 5\
**Last updated:** [June 9, 2022, 12:27pm UTC](https://community.fibery.io/t/global-parameters-variables-workaround/2903 "2022-06-09T12:27:42Z")

</div>

What’s a good workaround for having a global parameter, that is to say a value that stays the same for all records but might be used in multiple formulas in various Fibery spaces? Some example of “global parameters”: I…

---

## [Move items between databases using automations](https://community.fibery.io/t/move-items-between-databases-using-automations/2893)

<div class="topic-metadata">

**Author:** [@shaye](https://community.fibery.io/u/shaye)\
**Replies:** 5\
**Last updated:** [June 1, 2022, 12:56pm UTC](https://community.fibery.io/t/move-items-between-databases-using-automations/2893 "2022-06-01T12:56:43Z")

</div>

Hi, I’m trying to replicate clickup’s GTD workflow. Included in that workflow are several automations which move items from one database to another based on whether a checkbox is ticked or not e.g. item is added to data…

---

## [Why does this Rule never fire? (when 1:1 entity is linked)](https://community.fibery.io/t/why-does-this-rule-never-fire-when-1-1-entity-is-linked/2888)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 4\
**Last updated:** [May 31, 2022, 6:25am UTC](https://community.fibery.io/t/why-does-this-rule-never-fire-when-1-1-entity-is-linked/2888 "2022-05-31T06:25:24Z")

</div>

It should fire when a “Client” is linked to the relation, but it does not fire: Even after I remove the conditions, it still doesn’t fire: The “Client” relation in question gets set by this Client rule (it works)…

---

## [How to enumerate and search the Workspace via API?](https://community.fibery.io/t/how-to-enumerate-and-search-the-workspace-via-api/2886)

<div class="topic-metadata">

**Author:** [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Replies:** 0\
**Last updated:** [May 30, 2022, 4:20pm UTC](https://community.fibery.io/t/how-to-enumerate-and-search-the-workspace-via-api/2886 "2022-05-30T16:20:30Z")

</div>

The API documentation doesn’t say much about Folders, Documents, or the “Left Menu”. Is there a way to – Enumerate/walk/search the Workspace as reflected in the Left Menu (Spaces, DBs, Views, Folders) Search for a Fol…

---

## [Issues with using "Join" formula](https://community.fibery.io/t/issues-with-using-join-formula/2878)

<div class="topic-metadata">

**Author:** [@pattricia](https://community.fibery.io/u/pattricia)\
**Replies:** 3\
**Last updated:** [May 29, 2022, 9:46pm UTC](https://community.fibery.io/t/issues-with-using-join-formula/2878 "2022-05-29T21:46:08Z")

</div>

Hi guys, I have issues using the Join formula. I would like to have the Name field be constructed in the following way: Name = Details (text) + Markets (reference field, single select) + Products (reference field, sin…

---

## [Is each workspace on a seperate paid plan?](https://community.fibery.io/t/is-each-workspace-on-a-seperate-paid-plan/1220)

<div class="topic-metadata">

**Author:** [@Rob\_b](https://community.fibery.io/u/Rob_b)\
**Replies:** 10\
**Last updated:** [May 27, 2022, 9:17am UTC](https://community.fibery.io/t/is-each-workspace-on-a-seperate-paid-plan/1220 "2022-05-27T09:17:16Z")

</div>

Does each workspace on its own paid plan? Or can I have several workspaces on the same plan?

---

## [Pull highlighted text out of doc](https://community.fibery.io/t/pull-highlighted-text-out-of-doc/2834)

<div class="topic-metadata">

**Author:** [@Sarah\_Arminta](https://community.fibery.io/u/Sarah_Arminta)\
**Replies:** 3\
**Last updated:** [May 24, 2022, 2:24am UTC](https://community.fibery.io/t/pull-highlighted-text-out-of-doc/2834 "2022-05-24T02:24:05Z")

</div>

I have a doc field which has some highlighted sections. Can I create another field and use a formula to pull out these highlights?

---

## [Self Referencing Filters](https://community.fibery.io/t/self-referencing-filters/2836)

<div class="topic-metadata">

**Author:** [@Sarah\_Arminta](https://community.fibery.io/u/Sarah_Arminta)\
**Replies:** 2\
**Last updated:** [May 23, 2022, 5:02pm UTC](https://community.fibery.io/t/self-referencing-filters/2836 "2022-05-23T17:02:10Z")

</div>

I use a lot of self-referencing filters, first in Notion, now Obsidian. Can I do this in Fibery? Can I have a filtered table within another table row and filter it to only show entities (is that the correct term?) that r…

---

## [I have a question about security implementation nuances](https://community.fibery.io/t/i-have-a-question-about-security-implementation-nuances/2839)

<div class="topic-metadata">

**Author:** [@daosa](https://community.fibery.io/u/daosa)\
**Replies:** 2\
**Last updated:** [May 23, 2022, 4:46pm UTC](https://community.fibery.io/t/i-have-a-question-about-security-implementation-nuances/2839 "2022-05-23T16:46:17Z")

</div>

Hello everyone. I have probably quite noob question. So, if I have an account on Fibery, does it mean that I am the only Admin of my workspace, who has access to workspace’s data? Or is there some SuperAdmin, like Fiber…

[Previous page](https://community.fibery.io/c/get-help/5.md?page=33)

[Next page](https://community.fibery.io/c/get-help/5.md?page=35)
