Built Template Column From Lookup or Relation Column?

[al3xrods]

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:)

[kyleheney]

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.

[Anton_Rumyantsev]

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

[kyleheney]

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.

[Anton_Rumyantsev]

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

[kyleheney]

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

[Anton_Rumyantsev]

exactly like you said. i have different columns for each

[kyleheney]

Looks good. Is there still a problem?

[Anton_Rumyantsev]

yes =(

[kyleheney]

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.

[Anton_Rumyantsev]

oh, thank you!