Jump to content

Sorting and navigating related records


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

Recommended Posts

A parent file shows a portal. I want a script in the portal line that finds related child records ( easy enough with Go To Related Records ), but I want this set of records to be sorted in the same way as in the portal and the current record to be the one that was clicked in the portal.

I get the found set OK but only in creation order. If I do a subsequent sort, I end up in the first record, not the one that triggered the script.

This would be useful as I often want to scroll though records in a defined order but starting at a predetermined point.

Thanks in anticipation,

Andrew Bruno

Link to comment
Share on other sites

Create another relationship based upon a global field in you main file. When you initially click on a record to select it, capture its recordID (or whatever you use for the portal relationship in the related file) in the global. After you setup the proper found set and sort it in the related file, use this new relationship with a Go to Related Record() script step without the "Show only related records" option.

-bd

Link to comment
Share on other sites

This topic is 7281 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
 Share

×
×
  • Create New...

Important Information

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