AnsweredAssumed Answered

Activate the Sort command in Table-View, without activating the Table View submenu commands.

Question asked by rickmerl on Oct 9, 2017
Latest reply on Oct 19, 2017 by rickmerl

Activate the Sort command in Table-View, without activating the Table View submenu commands in the Context Menu

 

FM Version : Pro Adv 15

Dev Platform : Mac OS X 10.10.5

 

Layout Name : APD

Views affected : Field View Only

Privilege Set : Staff-User (read write data entry, with delete and Print)

 

BLUE: Showing what I want to achieve.

RED: Showing what I don’t want.

 

ISSUE/S

When in Table-View (logged in as Staff-User):

A) I want the user to be able to “Sort” (Ascending or Descending) via the Column Title Arrow.

B) I don’t want the user to have access to the “Table View” sub-menu commands (“Modify”, “Reset”, “Edit Properties”) that appear in the context menu.

 

Setup Step - Custom Menu Set

I created a Custom Menu Set (Staff-Menu), and included the “Records” Sort Records and UnSort commands (deleting the other commands “Record” menu set).

 

Setup Step - Include Custom Menu Set in Start-Up Script

I added the following into my startup script… (which works ok):

 

If   [ Get ( CurrentPrivilegeSetName ) = “[Full Access]” ]

Install Menu Set [ “[Standard FileMaker Menus]” ]

Else

     Install Menu Set [ “Staff=Menu”] ; Use as file default ]

End If

 

Setup Step - Create a Privilege Set for ’Staff-User”

In Privileges: (manage > security > privilege sets) Staff-User:

 

Setup Step - Setup Privilege setting for ’Staff-User’ (Setup 1)

In Privileges: (manage > security > privilege sets) Staff-User:

 

Records      : Create, edit, and delete in all tables

Layouts       : All view only

Value Lists  : All View only

Scripts        : All executable only

 

Available Menu Commands: Editing Only

 

Setup Step - Setup Privilege setting for ’Staff-User’ (Setup 2)

In Privileges: (manage > security > privilege sets) Staff-User:

 

Records      : Create, edit, and delete in all tables

Layouts       : All view only

Value Lists  : All View only

Scripts        : All executable only

 

Available Menu Commands: All

 

 

Result when logged in as Staff-User (using Privilege setup 1)

1. The ‘Records’ menu is available, snd shows “Sort Records” and “UnSort” in grey’d out (not selectable) mode.

 

When selecting an Arrow beside a Column Title, the context menu appears, and:

2. Shows “Ascending” and “Descending” in grey’d out (not selectable) mode.

3. Shows the “Table View” submenu, with all submenu options in grey’d out (not selectable) mode.

 

 

Result when logged in as Staff-User (using Privilege setup 2)

1. The ‘Records’ menu is available, and shows “Sort Records” and “UnSort” as available to the user.

 

When selecting an Arrow beside a Column Title, the context menu appears, and:

2. Shows “Ascending” and “Descending” as available to the user.

3. Shows the “Table View” submenu, and makes “Modify”, “Reset” and “Edit Properties” available to the user.

 

 

Neither of the above results acceptable. If I give the user access to sorting via the arrow beside the Column Title (which is a must have), I am forced to give the user access to the Table View Sub-commands (which is absolutely not an option).

 

As far as the Menu (Records) appearing in the Menu area, It is unessasary, and I would prefer it not to appear, as my need is very simple.

* Allow the user to Sort columns via the Title Name Arrow, via the context menu Ascending / Descending options.

* Deactivate the Table View (“Modify”, “Reset” and “Edit Properties”) commands in the context menu.

 

Is there a simple solution to this?

Outcomes