Name summery

[forgedbyfire]

My problem is I have a list of records and I want to create basically a alphabetic summery field that I can then us to illuminate a tech's name.

I basically have a list view of my records for that day that have the the techs I have assigned to them. I then would like to illuminate a simple label using conditional formatting to indicate that a tech has been put on a list that way no one is forgotten. I have can light 1 to 2 names at a time if you are on the record that contains the name you are looking for but ignores all other tickets. I would like to simply compile a list of all techs in a summery and then use conditional formatting to check and see if the name is on it. It is just a simple way for me to visually make sure every one on my list is assigned. Ultimately If I could make the label change as the employees change that would be ideal, but I have no problem creating them and deleting them as the come.

Mikebrown.pdf

[Søren Dyhr]

Why not use Excel for this eyeballing business? Filemaker is a relational database and the flatness exposed isn't particular flattering : , and assignments to tasks does usually require 3-4 tables to facilitate it. I usually lead developers to this template:

http://www.nightwing.com.au/FileMaker/demos7/demo705.html

--sd

[forgedbyfire]

My overall question is: is it possible to conditionally check all records being browsed.

[comment]

I don't really follow your description or the pdf, but perhaps something like this can help:

EmployeeTasks.fp7.zip

[forgedbyfire]

I need a very similar solution to what you have provided. But, instead if having a special layout that I could go to, I would like to view the unused people in the layout I assigned them in.

For example. If I were to take your layout tasks and view as list, and add a header, I would then add the Labels Adam, Betty, Cecil, David, and eve. Then as you are assigning the tasks, if Betty and Cecil are not assigned that day their names are highlighted to let you know they are not used.

Employee_tasks.pdf

[comment]

Like this?

EmployeeTasks2.fp7.zip

[forgedbyfire]

I apologize for my long delay in getting back. I recently had some knee surgery and the meds limit my ability to do very many logical things.

Both suggestions are great! I have really pushed to incorporate either one into my database. But I get stuck trying to jump in and incorporate either one. Can you make a suggestion.

The guest account has full access.

The place I am trying to put your suggestion is in the layout Dave's book II. You will see the label Mike brown. That is the label I am trying to light up. I would like to illuminate the label versus using a portal due some idiosyncrasies we have here in my company. I.E. If the database doesn't look exactly like the paper version of information the workers reject the changes and revert back to hard paper.

Thank you again for all of your help. I greatly appreciate your time and effort.

Pool_Tron_database_Clone.zip

[comment]

I am sorry, but there's no way I could understand your file in a reasonable amount of time. I suggest you use my file to understand the technique - once you do, you should have no problem implementing it in yours.

[forgedbyfire]

Ok thank you.