Jump to content
Sign in to follow this  
Jarvis

FIND CRITERIA> Can this be equal to a field value?

Recommended Posts

Hi!

I am trying to build a solution that requires minimal typing.

I would like this thing to ultimately be touch screen or mouse driven.

I would like to minimize the times we have to access a keyboard.

I have a table that assigns tasks to workers.

The worker is selected from the VALUE LIST: Workers.

The VALUE LIST:Workers uses values from the field WORKER NAME.

As I add a new employee to the company, their data is entered into a record and their name automatically becomes available to assign a task to.

This part so far is quite easy. What I am stumped on is performing a find.

I would like to (more or less) perform a find with the following sequences:

1) Click in a field and select a worker name from the drop down value list:

2) Upon exiting the field, trigger a script that finds all tasks assigned to that worker.

I understand that the exit script trigger will require a plug-in.

What I am hoping to do is have the CRITERIA for the Perform Find Script be automatically entered into the Perform Find request without any more data entry from me.

I want to select the worker name from the value list and have the appropriate assigned tasks listed out.

Assuming I explained myself properly, can anybody help me here?

Thanks,

Jarvis

PS: About ten seconds from now I will probably conclude this has something to do with related records.

Share this post


Link to post
Share on other sites

Your ten seconds are UP! What you're talking about can be done best with related records in a portal. At its most simplest:

Set up your two tables. One with employees, one with tasks. In each table have an EmployeeName field, and use that to join the tables in a relationship. Also, set the relationship to "Allow creation of records in this table via this relationship."

Then set-up your layout based on the employees table, with a portal showing records from the tasks relationship, and with a pop-up menu above it to select the proper employee. Each time you choose a different employee with the pop-up, the records in the portal will change to show just that employee's tasks. And you can create new tasks by typing them directly into the portal.

(If you're constantly assigning similar tasks, you can use pop-ups in the portal to minimize typing.)

Share this post


Link to post
Share on other sites

Additionally, if you have more than one employee assigned to a task, simply enter the employee's names in the Task table's EmployeeName key field and separate they names by a paragraph return. A check boxk fomratted field in the Task table will accomplish this as well.

Share this post


Link to post
Share on other sites

Thanks guys!

I will print this out and give it a whirl later today.

That check box thing is pretty cool.

One of my earlier forays into this effort had task assignment with check lists.

When the guys went to the task (on a columnar type format) they activate a drop down list which then de-selected the check boxes on the originating layout.

If I could just figure out how to remember all these tips......

Jarvis

Share this post


Link to post
Share on other sites

The FM 7 Developers CD comes with an example plugin for triggering a script. Just found out about it yesterday. Seems to be one of those goodies that is not widely know.

Share this post


Link to post
Share on other sites

Ken,

Where did you find the example plug in on the developer CD?

Jarvis

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.

Guest
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.