Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Actually my scenario is something like that:
I have 5 sheet(A,B,C,D,E) in my application and want to show particular Sheet to particular user.
There is one csv file which having this information:
User, Sheet_name
RR, A
SM, B
RR, C
SW, D
MM, E
TT, ALL
I am using this expression in show sheet condition for each sheet.
Sheet_name ='A' or TAB_NAME='ALL' (For sheet A)
Sheet_name ='B' or TAB_NAME='ALL' (For sheet B)
Sheet_name ='C' or TAB_NAME='ALL' (For sheet B)
Sheet_name ='D' or TAB_NAME='ALL' (For sheet B)
Sheet_name ='E' or TAB_NAME='ALL' (For sheet B)
Its working fine , if each user have single entry in csv file. But if one user have multiple entry for different sheet then it is not working. For example :- User RR having 2 entry in the list for sheet A and sheet C. How can I show both sheet(A and C) to user RR?
I think if i can get all values of sheet_name field without any selection then we can achieve this..
you can use
in each sheet
index(concat(Sheet_name,'|'),'A')>0 or index(concat(Sheet_name,'|'),'ALL')>0
Thanks Iiron, its working fine...., we can use lookup also.