# Single field to RichText **URL:** \ **Category:** Get Help\ **Created:** [May 9, 2023, 8:00pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434 "2023-05-09T20:00:46Z")\ **Posts on this page:** 15\ **Page:** 1
**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 9, 2023, 8:00pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/1 "2023-05-09T20:00:46Z")
How to pass the value of multiple Single fields to the RichText field one by one on one line with a Button inside the same database? I tried it through Overwrite. There I specified: `{{Database.SingleField1}}, {{Database.SingleField2}}.` But it didn’t work. Instead of field values, it inserts empty. Although the result of the script shows “Button to Completed”. Any idea how this can be solved? Thank you in advance. ---
**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 9, 2023, 8:56pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/2 "2023-05-09T20:56:01Z")
If you have database A related to database B (many-to-one or one-to-one) you should be able to reference the content of fields in a linked B entity by using {{LinkFieldName.FieldName}} where LinkFieldName is the name of the relation field (as viewed from A database) and FieldName is the name of the property field in the B database. But FieldName needs to be ‘primitive’ i.e. a date/text/number field ---
**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:** [May 9, 2023, 11:08pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/3 "2023-05-09T23:08:50Z")
When referencing a plain Text field within the same DB as the the Rich Text target, this syntax works for me (using the Rich Text “Overwrite” Action) ```auto {{Text Field Name}} ``` ---
**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 10, 2023, 10:14am UTC](https://community.fibery.io/t/single-field-to-richtext/4434/4 "2023-05-10T10:14:25Z")
Thank you. Useful information. As to the question. I have everything in one database. It’s about transferring data within one database and one entity from one field to another. ---
**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 10, 2023, 10:18am UTC](https://community.fibery.io/t/single-field-to-richtext/4434/5 "2023-05-10T10:18:55Z")
Please tell me about your example {{Text Field Name}} ‘Text’ is about what? ‘Field’ - it’s clear The ‘Name’ is the name of the entity from which we take the value of the Single field? ---
**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 10, 2023, 10:33am UTC](https://community.fibery.io/t/single-field-to-richtext/4434/6 "2023-05-10T10:33:45Z")
I found a solution. But it is too cumbersome. I would be very glad if something more succinct came along. **Sulution:** Create a duplicate Text field for each Single field. In automation, set rules for each value of the Single field, so that the Text field will have an identical text value. Then we will add the value of the Text field to RichText, using {{Text}} syntax with a button. Done. I tried the solution from this article. [https://the.fibery.io/search/szDH3#User\_Guide/Guide/How-to-use-Single-selects-in-Formula-161](https://the.fibery.io/search/szDH3#User_Guide/Guide/How-to-use-Single-selects-in-Formula-161) But it doesn’t work at all in Markdown syntax. ---
**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 10, 2023, 11:06am UTC](https://community.fibery.io/t/single-field-to-richtext/4434/7 "2023-05-10T11:06:11Z")
If you just want to add the values from single select field(s) to a rich text field, you can use `{{Select1.Name}}` `{{Select2.Name}}` where Select1/2 are the names of the fields. ---
**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 10, 2023, 11:46am UTC](https://community.fibery.io/t/single-field-to-richtext/4434/8 "2023-05-10T11:46:12Z")
That’s exactly what I need. Thank you very much! 😉 👍 ---
**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:** [May 10, 2023, 2:08pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/9 "2023-05-10T14:08:53Z")
The entire string “Text Field Name” is just the Name of a Text field in the DB, used here as an example. ---
**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 10, 2023, 2:23pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/10 "2023-05-10T14:23:31Z")
Tried this. It came up empty )) Chr1s solution worked 😉 ---
**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:** [September 25, 2023, 1:49pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/11 "2023-09-25T13:49:30Z")
What if the FieldName field is not ‘primitive’ ? If the field type is SingleSelect. How to get the value of this field in another database? I tried the {{{DB.Field.Name}}} syntax. It expectedly did not work))))). Relation — Many-to-one. ---
**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 25, 2023, 2:17pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/12 "2023-09-25T14:17:01Z")
Do you mean that you have two DBs (1 and 2) and DB2 has a select field whose value you want get into a rich text field in DB1? Assuming there can only be (max) one DB2 entity linked to each DB1 entity, then you should be able to just use `{{FieldNameForDB2.FieldNameForSelect.Name}}` where `FieldNameForDB2` is how the DB2 entity relation is named (when looking from DB1 entity) and `FieldNameForSelect` is the field name for the select field in DB2 ---
**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:** [September 25, 2023, 2:25pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/13 "2023-09-25T14:25:34Z")
> [@Chr1sG](#): > > {{FieldNameForDB2.FieldNameForSelect.Name}} That’s exactly what I tried. I get the following response: [object Array] «one DB2 entity linked to each DB1 entity» — Yes ---
**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 25, 2023, 2:30pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/14 "2023-09-25T14:30:19Z")
Maybe you can share some screenshots/video (entity view, db view etc.) to show your specific set up, because I checked that it works for me. ---
**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:** [September 25, 2023, 2:35pm UTC](https://community.fibery.io/t/single-field-to-richtext/4434/15 "2023-09-25T14:35:14Z")
If it works for you, then I probably did something wrong. I’ll check it out. If anything, I’ll send screenshots to support. Thanks for the feedback 👌