How the glide maps users to their particular row other than the user profile sheets?. For Eg I have a investment Portfolio sheet, and i have 10 users, so 10 rows. Then how does the glide knows/maps a user to a particular row, without email id in that sheet, means as soon as the user logs in, the gli…

[image] rahul482: despite having many rows it shows and edits values for the top row only . You must filter the tab level screen by “email” is signed-in user. Otherwise it will always read the first row when you have a details tab layout like this.

If the data is not in your User Profiles table, then you need to include a column that can be used to link each row to a specific user, and then populate that column as each new row is added. This can be anything you want, as long as it’s unique to each user. There are probably two “standard” appro…

@Darren_Murphy is spot on. Another option is to include the user email in the Portfolio sheet and then apply Row Owner security to that column. Now the logged in user will only ever get back Portfolio rows that match their email address. It may or may not be appropriate for you scenario, depending o…

thanks @Darren_Murphy @V88 , after pulling the email ids using lookup, array and rollup what will the email column data type will be will it be email type or text type?

For lookups, it will be the same column type as the original column, meaning if you take back an email column, it will be an email. That’s if you take back a single value from the relation, if you take back multiple values, it will return an array. I assume when you’re asking about an array, you me…

If i form a relation between two tables and using lookup if i extract email column then what will be the data type for the extracted email column.? and i am unable to make the email column extracted using relation and lookup a row owner. i am working on glide sheet. tried extracting email using sin…

[image] rahul482: If i form a relation between two tables and using lookup if i extract email column then what will be the data type for the extracted email column.? It will be an email, providing your relation is a single relation. [image] rahul482: i am working on glide sheet. tried ex…

@ThinhDinh @Darren_Murphy , now I have one User profile google sheet and one Investment profile glide sheet. As shared by Darren in other sheets, i have added a Row Id column and using lookup, then array and single value i have extracted email from the user profile sheet. Now the glide is not recogn…

How the row mapping happens?

Ask for Help

system Closed March 15, 2022, 9:20am 11

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

Topic		Replies	Views
How Can i get data from other sheet without relation and lookup columns Ask for Help	6	888	March 12, 2022
How to send notifications and/or emails to users when using row owners Ask for Help	10	477	September 29, 2023
Challenges applying Row Owner freely, without formulas - thoughts? Ask for Help	10	443	February 23, 2021
🤔 Row Owners vs. User Specific Columns Community Resources tutorial	6	1697	July 4, 2023
Wrong way to get user email from one sheet to populate another? Ask for Help	4	567	December 11, 2020

How the row mapping happens?

Related topics