I am trying to create a dynamic Outline Entry and View display which is based upon the user being a member of a group which is returned from a lookup.
My formula so far is as follows and isn’t working, does anyone know if this is possible and if so how it can be done please?
I am using an If statement to try and set a temp value to be used as a parameter in the SetViewInfo([SetViewFilter]) command to dynamically display the relevant category in the view.
I hope this make sense! Many thanks for any responses
FaxTemp:=@If(
@IsMember(@DbLookup(“”:“”;“”;“LookupView”;“FAX 575000@YBS”;“EmailGroupLU”);@UserNamesList);“FAX575000@YBS”;
@IsMember(@DbLookup(“”:“”;“”;“LookupView”;“FAX 575002@YBS”;“EmailGroupLU”);@UserNamesList);“FAX575002@YBS”;
@IsMember(@DbLookup(“”:“”;“”;“LookupView”;“FAX575001@YBS”;“EmailGroupLU”);@UserNamesList);“FAX575001@YBS”;
NULL);
@SetTargetFrame(“ContentFrame”);
@Command([OpenView];“CF”);
@SetViewInfo([SetViewFilter];FaxTemp;“SendTo”;1)