Jump to content
Sign in to follow this  

find and sort based on groupname

Recommended Posts

i have a timesheet database for employees...

I would like the employees to only have access to their own records and also for filemaker to only list their records and sort based on date.

There are 9 employees and i have assigned each to a group and have made the appropriate passwords for them...

however, i have not been able to figure out how to create a script that will find and sort based on their groupname? It is my impression that the find command performs the last find you did and you cannot set it to perform 9 different searches in one script?

for instance...if i have an employee field...

i would like to say...

groupname is Robert and Employee field is RM then find and sort based RM

groupname is Adam and Employee field is AW then find and sort based on AW

groupname is Gary and Employee field is GB then find and sort based on GB


any help would be appreciated...


Share this post

Link to post
Share on other sites

While I would use some sort of lookup to do this the following should work,

Enter Find Mode

Insert Calculated Result [ Employee, Case(Status( CurrentGroups) = "Robert","RM",Status( CurrentGroups) = "Adam","AW",

Status( CurrentGroups) = "Gary","GB","") ]

[ Select entire contents ]

Perform Find

Sort [ Sort Order: xxx (Ascending) ]

[ Restore sort order, No dialog ]

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.