Glad to hear you solved it to your satisfaction, but I don’t quite understand this:
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
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)))
I sent the video to support. Maybe they will figure out how this is possible)))
Haven’t tried linking to two at once.
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?
It should work even without the triple quotes. Just writing:
{{DB1.Description}}
{{DB1.Pain}}
The result is an empty field.
And what does the activity history show? Any errors?
«Magic is Completed».
No errors.
As soon as I solve this problem, I’ll post it here.
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!
Which db did you link DB2 to?
What does your relation map look like now?
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.
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:
It just overwrites the description field with nothing.
And so, if you are using a markdown construction like this:
[ai]
Tell me something about the following:
"""
{{Nonsense.Description}}
"""
[/ai]
Something will appear in the description field, but it won’t be meaningful.
Of course I’m talking about getting the information I need as a result of automation
Everything works.
I changed the relation to “one-to-many”. That’s it.
