Restricting Specific fields without reducing rest of the data

AB18 — Tue, 16 Nov 2021 13:42:34 GMT

Hi All,

I have a below requirement which is unlike Section Access and below is the Data

Region	Sports Name	Price USD	Sport Value USD
ASIA	Basketball	455000	76000000
ASIA	Carrom	650000	250000000
Central Europe	FootBall	1631250	400000000
Central Europe	Swimming	115915.6862	27562800
PACIFIC	Soccer	303661.41	110400000
PACIFIC	Hide and Seek	358800	69000000
UK	High Jump	123690	92340000
UK	Cycling	145200	40691640
US	Running	458999	485765
US	Boxing	129756	48202714

Now requirement is- if user belongs to ASIA and Central Europe then he will be able to see data as below

Only Sport Name and Region Column should be restricted for him while rest of the data should appear as is

Region	Sports Name	Price USD	Sport Value USD
ASIA	Basketball	455000	76000000
ASIA	Carrom	650000	250000000
Central Europe	FootBall	1631250	400000000
Central Europe	Swimming	115915.6862	27562800
		303661.41	110400000
		358800	69000000
		123690	92340000
		145200	40691640
		458999	485765
		129756	48202714

Below are the users regions of access

ACCESS	NTNAME	USER	Name	USERTYPE	REGION
ADMIN	1	1	Kathrine	INTERNAL	*
ADMIN	2	2	Joe	INTERNAL	*
USER	3	3	AB	INTERNAL	*
USER	4	4	Deep	INTERNAL	ASIA
USER	5	5	Shristi	INTERNAL	ASIA
USER	4	4	Deep	INTERNAL	Central Europe

I like to implement the same in back end as I have reduced data for this query but my dashboard has data in GBs with multiple sheets. I am even open for a solution which I can implement on UI as well.

Will really appreciate your help and thanks in advance for the same

Thanks,

Abhijeet

topic Restricting Specific fields without reducing rest of the data in App Development

Restricting Specific fields without reducing rest of the data