# \[DONE\] About using entity fields

**URL:** <https://community.fibery.io/t/done-about-using-entity-fields/4398>\
**Category:** Get Help\
**Created:** [May 2, 2023, 5:30pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398 "2023-05-02T17:30:54Z")\
**Posts on this page:** 16\
**Page:** 2

<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:** [May 3, 2023, 3:46pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/21 "2023-05-03T15:46:46Z")

</div>

Glad to hear you solved it to your satisfaction, but I don’t quite understand this:

> [@aklavrov](#):
>
> we select the entity where we want to generate a response from the AI. And it is generated based on the DB1 database data that is defined by relation

If Ad1 were to be related to Avatar 1 AND Avatar 2, what would happen in your automation?  
It looks to me like the automation should only work if the relation between db2 and db1 is many-to-one

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 3:51pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/22 "2023-05-03T15:51:58Z")

</div>

This is a very strange situation. An example is in the screenshots with the test tables. Made them in order to make screenshots. Wrote the answer. And only after that I checked - it doesn’t work.

Went back to my tables, where everything works. And half an hour trying to figure out what the difference is. Everything is configured identically.

Checked it. In both cases, many-to-many. This creates even more questions)))

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 3:52pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/23 "2023-05-03T15:52:56Z")

</div>

I sent the video to support. Maybe they will figure out how this is possible)))

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 3:54pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/24 "2023-05-03T15:54:20Z")

</div>

> [@Chr1sG](#):
>
> If Ad1 were to be related to Avatar 1 AND Avatar 2, what would happen in your automation?

Haven’t tried linking to two at once.

---

<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:** [May 3, 2023, 3:54pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/25 "2023-05-03T15:54:30Z")

</div>

Putting aside AI, what happens if you just use the markdown that is in between the triple quotes?  
What shows up in the Media rich text field?

Also, how do the relation maps look like for these dbs?

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 3:55pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/26 "2023-05-03T15:55:55Z")

</div>

It should work even without the triple quotes. Just writing:  
{{DB1.Description}}  
{{DB1.Pain}}  
The result is an empty field.

---

<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:** [May 3, 2023, 3:59pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/27 "2023-05-03T15:59:52Z")

</div>

> [@aklavrov](#):
>
> The result is an empty field.

And what does the activity history show? Any errors?

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 4:03pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/28 "2023-05-03T16:03:04Z")

</div>

«Magic is Completed».  
No errors.

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 4:03pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/29 "2023-05-03T16:03:52Z")

</div>

As soon as I solve this problem, I’ll post it here.

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 5:10pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/30 "2023-05-03T17:10:36Z")

</div>

A quick comment.  
I linked DB2 to my database, in which I have everything works. Added the same query syntax to the automation, only querying my database for data - everything works 😅.  
How is that possible? 🤣 I’m waiting for a support response 🕶

Maagiic! 😅

---

<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:** [May 3, 2023, 5:56pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/31 "2023-05-03T17:56:12Z")

</div>

> [@aklavrov](#):
>
> I linked DB2 to my database, in which I have everything works. Added the same query syntax to the automation, only querying my database for data - everything works

Which db did you link DB2 to?  
What does your relation map look like now?

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 6:05pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/32 "2023-05-03T18:05:10Z")

</div>

Many-to-Many.  
Everything is the same as in the screenshots with the solution. Only instead of DB1 the link to another database in the same Space.  
I am more and more intrigued. 😅

---

<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:** [May 3, 2023, 6:30pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/33 "2023-05-03T18:30:11Z")

</div>

Out of curiosity, when you say that an automation is working, do you mean that no error is returned, or do you mean that you get meaningful information populated in the rich text field?

For example. this automation will complete without error, but that doesn’t mean it is doing anything useful:

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

It just overwrites the description field with nothing.  
And so, if you are using a markdown construction like this:

```auto
[ai]
Tell me something about the following:
"""
{{Nonsense.Description}}
"""
[/ai]

```

Something _will_ appear in the description field, but it won’t be meaningful.

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 3, 2023, 6:49pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/34 "2023-05-03T18:49:51Z")

</div>

Of course I’m talking about getting the information I need as a result of automation

---

<div class="post-metadata">

**Author:** ![aklavrov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/aklavrov/32/6715_2.png) [@aklavrov](https://community.fibery.io/u/aklavrov)\
**Post date:** [May 4, 2023, 4:19am UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/35 "2023-05-04T04:19:28Z")

</div>

Everything works.  
I changed the relation to “one-to-many”. That’s it.

[![](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/bc9987f2a3f08124c5669d2503b1b5a4f3029804.jpeg "Everything works pure experiment") ](https://www.youtube.com/watch?v=1VKOi48KLoc)

---

<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:** [October 4, 2024, 3:34pm UTC](https://community.fibery.io/t/done-about-using-entity-fields/4398/36 "2024-10-04T15:34:46Z")

</div>

Closed on October 4, 2024, 3:34pm UTC



[Previous page](https://community.fibery.io/t/done-about-using-entity-fields/4398.md?page=1)
