Jump to content
Sign in to follow this  

Gathering Information from List Layouts?

Recommended Posts

I'm totally new at this filemaker thing, and am having a little trouble trying to figure out a way to do what I would like to do:

I fix computers, and I need a way to be able to prioritize whose computers I work on first. The way I figured it out in my head is this:

-Customer brings computer to be repaired

-Enter in Customer's Info

-Customer's computer joins a queue where the computers I've had the longest becomes the ones I work on first.

Now, here's the tricky part that I haven't been able to figure out completely.

There are certain occasions where some customers get priority over other customers.

For example: If a customer comes in and pays a service "Rush" fee, they automatically get the next available spot on my bench, and the appropriate spot in my "queue".

There are a couple of ways I solved a way to implement this.

1. If ( Rush = "Yes"; "a" & queue ; "b" & queue )

e.g., a computer's queue # that has a rush = 'a986357'; one that doesn't = 'b098709'

2. Sort by Rush, then time, then non rush, then time.

OK, now after all of this happens, another layout will automagically tell me which computers I need to work on next. I'm having the most problems with this. I have no idea at ALL how to solve this. Somehow, I need FM to auto-fetch the top 4 (or so) computers in this "queue" list and display them in certain fields.

Is anyone able to help me figure this out? I need help. :) (...AHHHHH!)

(I attached a .pdf to better explain what I'm trying to accomplish)



Edited by Guest

Share this post

Link to post
Share on other sites

That works. :) I honestly don't completely understand the "g_Complete" and what it does. Could you or someone explain this?

Are there any other ways to do it I'm curious?

Share this post

Link to post
Share on other sites

You want your portal to show records from the same table where the field Complete = No. To form the relationship you need a constant that is equal to No. Thus you create a global field and enter No for that field. When using this in the realtionship it limits the portal records to only those where the Complete field = No.

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.