Tabbed Table and Controlled Access Sections - Help!

I have a tabbed table set up with 21 tabs, left align. I also have a Controlled Access section on each tab, with a Readers field, and am trying to hide the tab to non-Readers. Currently, when a non-reader clicks on a tab they should not be able to see, the tab displays, but doesn’t let them edit. I would like the section to close and remain closed for non-readers…

I would also like to hide the remaining tabs that are not being used. Any ideas?

Any knowledge would be greatly appreciated.

Thanks,

-Chris

Subject: Tabbed Table and Controlled Access Sections - Help!!

Hi, Chris. If you place Readers fields on the document, those Readers fields apply to the entire document, not just the individual tabs on the table. You can’t create a Readers field that only applies to a specific tab.

I haven’t tackled something as ambitious as 21 tabs, but I have done 3 or 4 tabs at time. How I managed to hide each tab was by using the text’s Hide/When properties. If you make sure that all text paragraphs hide under the same condition, it will hide the entire tab.

I suggest you replace your Readers field (assuming you have one on each tab) with Names fields. Then map your Hide/When formula to that Names field. My own preference is to use the following formula statement, though I realize there other approaches to this like the @IsNotMember function.

!( @Name( [Abbreviate] ; @UserNamesList ) *= @Name( [Abbreviate] ; fieldName : userRoles : anythingElseYouWantToCompare ) )

This formaula will check whether a user’s list of names (an array of names and roles) matches any value in your field (e.g. fieldName), specified user roles in the database (e.g. userRoles), or any other special comparisons you want. (I’ve provided an example with 3 sets of comarison to the right, but you could just compare the fieldName if you so choose.)

The Not (!) negates the returning result so that if the user is not in this list of names, it will hide from them correctly.

The asterix (*) and equal (=) signs collectively is a permuted equal operator, which matches every possible combination of values between the two sides of the equation.

Hope this does the trick for you, and good luck!

-RAM

Subject: Oh, one more thing…

I forgot to mention, but you will have problems if any of your tabs include Rich Text fields. Rich Text fields with Hide/When properties on the design side don’t refresh neatly like other fields.

A work around is to place the Rich Text field into a subform, then insert the subform onto your tab as a computed subform. The computed formula then simulates the same code you would have used in the hide/when statement, but results in the name of the subform.

-RAM

Subject: Tabbed Table and Controlled Access Sections - Help!!

If all of the text in a table row is not visible (and that’s all the text in all of the cells; if anything at all in any cell in the row is visible, the whole row is visible, even though they may all look empty), the entire row will be hidden. In tabbed tables, this means the tab won’t be visible either. What you’ll need to do is to select each row in turn, call up the text properties, and put in some hide-when conditions that will hide the text when the user isn’t authorized to see it.