# Lookup point to a URL-type field

**URL:** <https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799>\
**Category:** Ideas & Features\
**Tags:** flexible-domain\
**Created:** [July 14, 2021, 1:40am UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799 "2021-07-14T01:40:57Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![sohee](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sohee](https://community.fibery.io/u/sohee)\
**Post date:** [July 14, 2021, 1:40am UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/1 "2021-07-14T01:40:57Z")

</div>

Hi, currently a Lookup field cannot point to a URL-type field, does it?

My situation:  
I have a `Reference Docs` Entity with a `URL` field

 ![1](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/2/281918058b72628c94fa40af769a7f1c358ff334.jpeg)

I want to create a Lookup field in `Fund Fees` Entity that point to `URL` field in `Reference Docs` Entity. But the `URL` field is not available to choose.

 ![3](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/9fa5dccc74cc4b5baf9d611cddad896dbabe09b5.jpeg)

Just want to know if this is normal behavior?

Thanks

---

<div class="post-metadata">

**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\
**Post date:** [July 14, 2021, 4:52am UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/2 "2021-07-14T04:52:27Z")

</div>

Looks like a bug, we’ll check it

---

<div class="post-metadata">

**Author:** ![Sergey\_Truhtanov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/sergey_truhtanov/32/13986_2.png) [@Sergey\_Truhtanov](https://community.fibery.io/u/Sergey_Truhtanov)\
**Post date:** [July 14, 2021, 4:41pm UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/3 "2021-07-14T16:41:17Z")

</div>

Hello.  
The reason url field is not available in the list of available lookup fields is that Fibery does not support collection of primitive fields at the moment.  
For example you cannot create a field that will be an array of text values. You need to create several text fields instead. But in case of relation fields we do support collections. For example you can create _Bugs_ relation field for _UserStory_ type. And setup relation arity as one-to-many. So you can relate several bugs to one userstory.

In your case as _Reference Docs_ field is a collection, so the result lookup field will be a collection itself. That is why only relations will be available in Field’s list.

As a workaround you may create a formula field like this:  
`[Reference Docs].Join([your url field], ",")`

This will be a text field with all urls from related _Reference Docs_, separated by comma.

---

<div class="post-metadata">

**Author:** ![sohee](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sohee](https://community.fibery.io/u/sohee)\
**Post date:** [July 15, 2021, 11:42am UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/4 "2021-07-15T11:42:19Z")

</div>

Thanks for taking time to explain the current expected behavior.

With your explanation, I recheck and saw what do you mean. I do have an array text in one cell of the `Reference Docs` as `relation-type` field.

I appreciate your workaround suggestion. It works. Though the url won’t be clickable since it’s a `text` 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:** [July 15, 2021, 11:59am UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/5 "2021-07-15T11:59:35Z")

</div>

Actually, when you create the formula according to Sergey, you can choose for the result to be Text, Email or URL. If you choose URL, and if a Fund Fees entity only points to a single Recovery Docs entity, the result of the formula will be a single clickable URL 🙂

---

<div class="post-metadata">

**Author:** ![sohee](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@sohee](https://community.fibery.io/u/sohee)\
**Post date:** [July 15, 2021, 12:09pm UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/6 "2021-07-15T12:09:18Z")

</div>

Yes. understood.  
With Sergey’s explanation, I found out that there is one field in `Fund Fees` type, currently pointing to 2 fields of `Reference Docs` type.  
So I decide that it’s much simpler if I change the relation between `Reference Docs` type and `Fund Fees` type from `m:n` to `1:n`. From this point, I can continue to use `Lookup` field as expected. Though, the tradeoff is that I have to change my underlying workflow logic between these 2 types.

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [January 23, 2023, 5:01pm UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/7 "2023-01-23T17:01:01Z")

</div>

I know there are several threads about the ability to create a collection of primitive fields. Is this a part of the roadmap?

---

<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:** [January 23, 2023, 5:10pm UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/8 "2023-01-23T17:10:19Z")

</div>

There’s nothing planned in the short- to medium-term to support collections/arrays of primitives.  
The current workaround (using an extra database) is not ideal, but at the moment, an improvement on this is lower priority than other features.

---

<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:** [April 29, 2025, 11:20am UTC](https://community.fibery.io/t/lookup-point-to-a-url-type-field/1799/9 "2025-04-29T11:20:50Z")

</div>


