Jump to content

Portal records - "Group By"?


This topic is 7301 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello everyone,

I have a CDML solution that will display a page for a order. Each order has one or more parts that have been ordered and all are listed on this page. If any of the parts have been shipped, the tracking information is displayed, formated like this:

Date.............TrackingNumber...............PartNumber

All tracking info is listed together at the top of the page, each part on it's own line.

If multiple parts from the same order are shipped in the same package, all parts will have the same tracking/date so I would like to only display the tracking/date once per package. So instead of this:

4/1/04.............12345...............555

4/1/04.............12345...............111

4/1/04.............12345...............999

4/2/04.............44453...............222

4/2/04.............44453...............777

I want to display this:

4/1/04.............12345...............555

...................................................111

...................................................999

4/2/04.............44453...............222

...................................................777

The tracking database contains the fields TrackingNumber, OrderNumber, PartNumber, and Date. The portal is based on a relationship linking OrderNumber to OrderNumber

Anyone have any ideas on how to accomplish this? Any suggestions are appreciated, thanks,

FileMaker Version: 6

Platform: Windows XP

Link to comment
Share on other sites

Here is some Javascript to try:

<script>var curr_date = "";

[FMP-Portal:tracking]

if (curr_date == "[FMP-Field:tracking::date]")

{ document.write("<tr><td></td><td></td<td>[FMP-Field:tracking::PartNumber]</td></tr>"); }

else 

{ 

document.write("<tr><td>[FMP-Field:tracking::Date]</td><td>[FMP-Field:tracking::TrackingNumber]</td<td>[FMP-Field:tracking::PartNumber]</td></tr>"); 

curr_date = "[FMP-Field:tracking::Date]"; 

} ; 

[/FMP-Portal]

</script>

All the best.

Garry

Link to comment
Share on other sites

This topic is 7301 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.