# Issues with using "Join" formula

**URL:** <https://community.fibery.io/t/issues-with-using-join-formula/2878>\
**Category:** Get Help\
**Created:** [May 29, 2022, 3:26pm UTC](https://community.fibery.io/t/issues-with-using-join-formula/2878 "2022-05-29T15:26:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pattricia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/pattricia/32/5105_2.png) [@pattricia](https://community.fibery.io/u/pattricia)\
**Post date:** [May 29, 2022, 3:26pm UTC](https://community.fibery.io/t/issues-with-using-join-formula/2878/1 "2022-05-29T15:26:30Z")

</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, single select) + Study type (single select)

Every time I follow the example of the Join formula I get different types of errors.  
Could you please advise me on how such a formula should be built?  
Or maybe I should build it in another way?

Thank you in advance for your support!

take care  
pat

---

<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 29, 2022, 5:06pm UTC](https://community.fibery.io/t/issues-with-using-join-formula/2878/2 "2022-05-29T17:06:18Z")

</div>

I’m not sure you need to use join.  
If the various fields are single selects or to-one relations, you can just use .Name

Details + Markets.Name + Products.Name + Study type.Name

but given the field names, perhaps they are not single selects/ to-one relations?

---

<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 29, 2022, 5:09pm UTC](https://community.fibery.io/t/issues-with-using-join-formula/2878/3 "2022-05-29T17:09:05Z")

</div>

In general, use .Name for fields where there can only be one item, use .Join(Name,", ") for fields where there can be multiple.

---

<div class="post-metadata">

**Author:** ![pattricia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/pattricia/32/5105_2.png) [@pattricia](https://community.fibery.io/u/pattricia)\
**Post date:** [May 29, 2022, 9:46pm UTC](https://community.fibery.io/t/issues-with-using-join-formula/2878/4 "2022-05-29T21:46:08Z")

</div>

Thank you, @Chr1sG, it worked!