Built Template Column From Lookup or Relation Column?

Hello !
Does anyone knows any workaround the fact that it is impossible to make a template column from a lookup or relation column ? Thank you:)

You should be able to use a Lookup that is generated from a single relation.

A relation is not a single β€œvalue” but rather a related row from another sheet.

Similarly, a Lookup from a multiple relation is bringing back multiple values, so a template wouldn’t know which values to include.

3 Likes

I have a problem with only 1 relation. But in title it didnt shows

If you’re trying to lookup the person’s name, select that column in your lookup. It seems like you’re pulling in their email and not their name.

1 Like

yes i try to pull email and telephone from user’s sheet. the relations by name

You’ll need multiple lookup columns to pull in which ever fields you need.

exactly like you said. i have different columns for each

Looks good. Is there still a problem?

yes =(

Do you have Row Owners enabled on your User Profile table? If you do, users can only view their own information, even if it’s displayed through a relation. If you don’t need all user profile information protected/secured, remove the Row Owner from the email column and that should fix your issue.

3 Likes

oh, thank you!

1 Like