# Screen Value to Relation column in Airtable

**URL:** <https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605>\
**Category:** Ask for Help\
**Created:** [April 17, 2023, 4:49am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605 "2023-04-17T04:49:28Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 17, 2023, 4:49am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/1 "2023-04-17T04:49:28Z")

</div>

Hello,

I am creating an app from Airtable wherein Linked column is set up in Airtable which is being shown as Relation column in Glide.

I have two tables. Master Product and Items (child to Master product). While at detailed screen of Master Product, I have a form which can add Items to Master Product. I want Screen Value (“Master Product Name”) to write to relation column. But it does no allow. And I am also not thinking of any other way to do it.

 ![Untitled](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3501c5db36fd28530fb5e528a4c912d1ef7bb41.png)

Another way I thought to create text field in airtable and write this value to it but then I am not sure how would it link the record.

Any guidance will be appreciated.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 18, 2023, 12:53am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/2 "2023-04-18T00:53:57Z")

</div>

Wouldn’t you have access to the “screen columns” if “Master Product Name” is one that is on the “details” screen under that form?

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 18, 2023, 1:41pm UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/3 "2023-04-18T13:41:24Z")

</div>

Thank you for reply. Screen value is visible but destination column (which is relation column) is not visible in the list. You can see at right side. It shows only basic columns.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 18, 2023, 11:42pm UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/4 "2023-04-18T23:42:36Z")

</div>

Ah, I don’t have knowledge about this to give further advice. I thought I only see the option to write to a “linked column” is through a choice component, or am I wrong?

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 19, 2023, 1:19am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/5 "2023-04-19T01:19:04Z")

</div>

That is correct, it’s the only option. But problem is each user is assigned against each client. So client should be automatically selected.

Do you find any trick wherein I add a choice component which by default selects the client name from user table without being visible to user who is submitting the form? May be using filter etc.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 19, 2023, 1:27am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/6 "2023-04-19T01:27:14Z")

</div>

If you can have a default value, then you can simply set the visibility to when “value” is empty. It will never be true.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 19, 2023, 1:31am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/7 "2023-04-19T01:31:02Z")

</div>

Thank you. I will try that. Using Airtable for Glide is really restricting at many points.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 19, 2023, 1:37am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/8 "2023-04-19T01:37:57Z")

</div>

@ThinhDinh one more question. Is there any way we can have multi-step form in form element? I believe Custom form having user specific column (when user is signedin) will cost more updates.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 19, 2023, 2:26am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/9 "2023-04-19T02:26:35Z")

</div>

> [@Pratik\_Shah](#):
>
> Do you find any trick wherein I add a choice component which by default selects the client name from user table without being visible to user who is submitting the form? May be using filter etc.

Hi @ThinhDinh Somehow, I could filter the choice component to only show name of Client which is linked with Sign-in user. How to make sure, it is by default selected? Since the choice component is writing to relation column, it does not have an option for default value.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 19, 2023, 11:19pm UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/10 "2023-04-19T23:19:33Z")

</div>

> [@Pratik\_Shah](#):
>
> @ThinhDinh one more question. Is there any way we can have multi-step form in form element? I believe Custom form having user specific column (when user is signedin) will cost more updates.

I don’t think there’s a solution. You would still have to set a value somewhere to control the step visibilities.

> [@Pratik\_Shah](#):
>
> Somehow, I could filter the choice component to only show name of Client which is linked with Sign-in user. How to make sure, it is by default selected?

So the choice component’s default don’t let you choose from a column value?

> [@Pratik\_Shah](#):
>
> Since the choice component is writing to relation column, it does not have an option for default value.

If this is the case then I don’t have any good recommendations.

---

<div class="post-metadata">

**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\
**Post date:** [April 20, 2023, 2:58am UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/11 "2023-04-20T02:58:35Z")

</div>

Thank you @ThinhDinh for responses. I explored the community more and found that these are all limitations when I use airtable.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 20, 2023, 11:52pm UTC](https://community.glideapps.com/t/screen-value-to-relation-column-in-airtable/60605/12 "2023-04-20T23:52:14Z")

</div>

Ah, that’s a shame. Hopefully the Airtable API might let Glide do more things in near future. Personally I haven’t used Airtable much.
