Sorting Records based on Account Name

[Daniel Frank]

Hey there,

New to the forums. I'm looking forward to learning from all of you.

 

Now to the issue:

I'm trying to sort records based on an Account Name within a layout.

 

For example, my current layout: Notice the multiples.

 

 

I would like to change it so Account Name is displayed only once. Multiple records would be shown on the next page.

(so after 1 year, I won't have to scroll through a thousand records)

 

Sort of like this:

 

 

 

Or this:

 

• Adam
  • May 18, 2013
  • May 19, 2013
• Admin
  • May 19, 2013
  • May 23, 2013
• test bot
  • April 20, 2013
  • April 21, 2013
  • May 19, 2013 ..etc

Haven't had any luck so far. Please let me know if you have any suggestions.

 

My very best, and thank you.

[doughemi]

A layout with subsummary parts  will do the job.  Your first example would be built without a body part in the layout, your second, with.

 

See http://help.filemaker.com/app/answers/detail/a_id/6198/~/simple-example-of-a-subsummary-report

 

[Daniel Frank]

Hi mate, thanks for the reply. Haven't had any luck with that.

 

I ought to have called it a "Members List" which leads to the respective user's profile.

The account named are pulled from user's that have created records. Duplicates would need to be removed so each name is only mentioned once.

 

e.g. "Member List"

Adam ---> Adam's Profile Page

Frank ---> Frank's Profile Page

John ---> ...

Karen --> ...

 

In effect, it is no different than http://fmforums.com/forum/members

 

Much thanks,

Daniel

[doughemi]

Like this?

 

Accounts.fmp12.zip

 

[Daniel Frank]

Beautiful! A God send! Thank you!

[Daniel Frank]

So let's say I have a whole bunch of records made on various dates (May 20, May 21, etc.)

 

Right now, I'm looking at a record which was created on May 20.

I want to click a button and see a list of all the records made on May 20.

 

But... if I'm in a record that was created on May 21, I want to click the same button to find all the records made on May 21.

 

[[Click a button --> find all records made on the same day as the record I'm in]] (in layout form)

 

Hope y'all can help me. Thanks.

[doughemi]

Create a new Table Occurrence of your table.   Relate it to your table by YourTable::CreationDate = NewTO::CreationDate. 

Create a copy of your current layout.  On the copy, create a portal to NewTO with whatever fields you want to see.

Create a button on your original layout with the button action being GoToLayout["NewLayout"].  On the new layout, create a button that will return to the original layout.

[Lee Smith]

Automatic message

This topic has been moved from "Conditional Formatting" to "Finding & Searching".