# Matching Names with Responses

**URL:** <https://community.glideapps.com/t/matching-names-with-responses/70780>\
**Category:** Ask for Help\
**Created:** [February 13, 2024, 12:12pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780 "2024-02-13T12:12:49Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [February 13, 2024, 12:12pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/1 "2024-02-13T12:12:49Z")

</div>

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a1edaeef288ff8b3edba0c26ce4cf84a60b155d.jpeg "Listed Phone Numbers") ](https://www.youtube.com/watch?v=1wLOk2_Brug)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 13, 2024, 12:29pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/2 "2024-02-13T12:29:44Z")

</div>

You need to first create a (single) relation column in your Users table, that matches the users email address with the same value in the other table. Then change your Lookup column so that it selects the yes/no response via the relation column.

---

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [February 13, 2024, 5:28pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/3 "2024-02-13T17:28:36Z")

</div>

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c70bc1b812dd1324dc61e3d4d1c00116d66dbb3e.jpeg "Continue With SMS") ](https://www.youtube.com/watch?v=cNsN0Vf8dLU)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 13, 2024, 5:33pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/4 "2024-02-13T17:33:45Z")

</div>

See below:

 ![CleanShot 2024-02-14 at 01.31.08@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f54255387252f2b237be98e32313664a9e0fd7df.jpeg)

You are using the value from the User Profile row, which means you will see the same value for every user - it will be whatever value corresponds to that of the “signed in” user.

You need to change that to reference the “Match for Phone” column directly, rather than via the User Profile row.

---

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [February 13, 2024, 5:55pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/5 "2024-02-13T17:55:50Z")

</div>

Should I be using a Lookup in the User table?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 13, 2024, 6:00pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/6 "2024-02-13T18:00:06Z")

</div>

The lookup is fine, you just need to reference it correctly as I described above.

---

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [February 13, 2024, 6:12pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/7 "2024-02-13T18:12:09Z")

</div>

When I reference the Yes/No field it gives me a combination of yes and nos

---

<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:** [February 13, 2024, 6:35pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/8 "2024-02-13T18:35:13Z")

</div>

Make sure you are using the single relation that @Darren_Murphy mentioned above.

> [@Danger! my head Explode](https://community.glideapps.com/t/danger-my-head-explode/70598/25):
>

---

<div class="post-metadata">

**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\
**Post date:** [February 13, 2024, 6:40pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/9 "2024-02-13T18:40:30Z")

</div>

Is that different from “Single Value”?

---

<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:** [February 13, 2024, 6:56pm UTC](https://community.glideapps.com/t/matching-names-with-responses/70780/10 "2024-02-13T18:56:32Z")

</div>

Depends. Are you using a Single Value against a relation in place of a lookup column? Or are you using Single Value → Whole Row in place of a single relation? Regardless in your case, I would recommend a single relation (relation with multiple checkbox unchecked) and point your lookup column to that relation.
