[Listed Phone Numbers]

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.

See below: [CleanShot 2024-02-14 at 01.31.08@2x] 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 di…

Should I be using a Lookup in the User table?

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

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

Make sure you are using the single relation that @Darren_Murphy mentioned above. [image] Danger! my head Explode Ask for Help [Screenshot_20240207-164201~2]

Is that different from “Single Value”?

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 t…

Matching Names with Responses

Ask for Help

Jeff_Hager February 13, 2024, 6:35pm 8

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

Topic		Replies	Views
Lookup column based on a user specific relation Ask for Help	1	252	March 29, 2021
Built Template Column From Lookup or Relation Column? Ask for Help	11	2118	January 12, 2024
User_relation using first name, not email? Ask for Help	5	321	March 28, 2021
Lookup problem Ask for Help	3	253	January 17, 2024
How do I get another column value by using Lookup? Ask for Help	5	533	February 9, 2022

Matching Names with Responses

Related topics