# Lookup fields not showing up for use in If-Then-Else

**URL:** <https://community.glideapps.com/t/lookup-fields-not-showing-up-for-use-in-if-then-else/55320>\
**Category:** Ask for Help\
**Created:** [December 2, 2022, 1:38am UTC](https://community.glideapps.com/t/lookup-fields-not-showing-up-for-use-in-if-then-else/55320 "2022-12-02T01:38:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robin\_Parkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robin_parkin/32/44913_2.png) [@Robin\_Parkin](https://community.glideapps.com/u/Robin_Parkin)\
**Post date:** [December 2, 2022, 1:38am UTC](https://community.glideapps.com/t/lookup-fields-not-showing-up-for-use-in-if-then-else/55320/1 "2022-12-02T01:38:01Z")

</div>

Hey folks,

I’m trying to create an If\>Then\>Else field for use as part of an RSVP function.

- I have an ‘Events’ table
- I have a ‘Sessions’ table (basically a ‘log’)
- When someone clicks the RSVP button on the event detail screen, a row is added to the Sessions table, and automatically creates a relation with that event. So far, so good.

However, I’d like now to have the RSVP button disappear for that user, and am having difficulty. Here’s where I’m at:

- I have a lookup field in the Sessions table which brings up the row ID for the linked event.
- I’m trying to set up an If\>Then\>Else field in my Sessions table so the linked event’s row ID only appears when the email address for that session = current user. However, when I try to set up the If\>Then\>Else field, this lookup field with the row ID does not appear as an option. Not sure why!

I’m not sure if this is a bug, or if it’s something in the organisation of our sheets that’s mucking things up. Any assistance much appreciated!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 2, 2022, 1:41am UTC](https://community.glideapps.com/t/lookup-fields-not-showing-up-for-use-in-if-then-else/55320/2 "2022-12-02T01:41:41Z")

</div>

Most likely you are using a multiple relation instead of a single relation. This turns the Lookup column into an array instead of a single value. Arrays can contain multiple values, so for that reason, you can’t use them in places that only work with single values.

I recommend just checking if the relation is empty or not. Then you won’t need the lookup column.

---

<div class="post-metadata">

**Author:** ![Robin\_Parkin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robin_parkin/32/44913_2.png) [@Robin\_Parkin](https://community.glideapps.com/u/Robin_Parkin)\
**Post date:** [December 2, 2022, 1:50am UTC](https://community.glideapps.com/t/lookup-fields-not-showing-up-for-use-in-if-then-else/55320/3 "2022-12-02T01:50:29Z")

</div>

Ahh you have cracked it! Thanks so much Jeff; I jumped back into the back end and switched it to a single relation. Problem solved! 😃

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 3, 2022, 1:51am UTC](https://community.glideapps.com/t/lookup-fields-not-showing-up-for-use-in-if-then-else/55320/4 "2022-12-03T01:51:27Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.