Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

find and sort based on groupname

December 31, 200124 yr

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

etc.

any help would be appreciated...

thanks