Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Display number of records found


Danniel Pizatto
 Share

Recommended Posts

Hi everyone!

 

I work at a repair shop and we use a Filemaker database to manage customers, equipments, service orders.

 

I'm working on version two of the database and i'd like to add a feature that display the number of records accordingly to its status.

 

For example: when the technician arrives, he will see how much equipment are awaiting for his diagnosis. Or the person responsible to call the customers, see how much orders has a status "contact customer"

 

The Service orders database has a field called "status" and the quantity will be displayed in another table, called "start point".

 

I tried to make a search around the forum but not quite sucesfull.

 

Thanks in advance and sorry if I do not explain my situation clearly

Link to comment
Share on other sites

The best suggestion I can think of is for you to make one or several new relationships using global fields on the master file. Here is a start.

 

1. Create a global field Named "Contact Customer" and Type in "Contact Customer" into the field.

2. Create a relationship matching this field to the status field on the other table.

3. Create a new calculation field with the following formula:

Count(Relationshiname::StatusField)

4. This will give you the total records. You can now even add a portal to allow the user to go to each related record to get contact information if they need it.

 

I hope this is helpful.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

 Share



×
×
  • Create New...

Important Information

Terms of Use