Provide Specific access to the Project Team records to Project team alone

[sureshr]

I have a list of users where I would like to provide access to the Project records only to the project users base don their login.

If they are part of the project then it is expected to show only the project records

[TeeSee1]

Check this out

https://intercom.help/appsheet/en/articles/1128148-limiting-users-to-their-own-data

[sureshr]

I would like to show the records of the respective team to its team members
alone.

--

NOTE: Privileged/Confidential Information may be contained in this
message. If you are not the addressee indicated in this message (or
responsible for delivery of the message to such person), you may not copy
or deliver this message to anyone. In such case, you should destroy this
message and kindly notify the sender by reply email. All opinions,
conclusions and other information expressed in this message not of an
official nature shall not be deemed as given or endorsed by SPH Media Trust
or any of its subsidiaries unless otherwise indicated by an authorised
representative independent of this message.

SPH Media Limited

Co Regn
No.: 202120748H

[graham_howe]

Can you provide a bit more info like the table structures? The answer is likely to be a slice or security filter using an IN() expression but we won't know for sure until we see how users are linked to projects.

[sureshr]

The survey table has Team Name, Survey details, Survey User Email ID

Team Table has Team Name and member name, Member Email ID

When users access the Survey then i would I]like to show the records of their team they belong

[graham_howe]

Try the following for a slice of the Survey table

IN(
  [Team Name], 
  SELECT(
    Team[Team Name], 
    [Member Email ID] = USEREMAIL()
  )
)

[sureshr]

Thanks for sharing however help me how I can proceed without a hard coding team name in the filter. It supposes to check the user's email and if he/she belongs to the team then it shows only the team records.