Jump to content

"Splitting" a portal


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

Recommended Posts

Not sure if this one belongs here or in the Portal Forum....

I have a portal on my layout showing 20 rows, which is the maximum number of related records. For design reasons, I want to "split" the portal, i.e. have two portals showing 10 records each. Now obviously if I just put another portal on the layout, it'll show the same related records as in the first portal. Is there a calc I can use to get the 2nd portal to show the records from row 11 onwards from the 1st portal?

Something like "GetPortalRow" - which I don't think exists?

I don't want to use a scroll bar, as I want the records visible at all times so that the user is able to click on any one of the portal rows and then go to the related record. Any ideas please?

Link to comment
Share on other sites

Simply define in your master an value list "PortalList" as use only related values (from your original relationship) from field recordID (if you don't have it define it as serial number text for ex ID001 ect)

Now, allways your master file, define an unstored calc:

restOfPortal=Right(ValueListItems(Status(CurrentFileName),"PortalList"),Count(YourOriginalRelationship::recordID)-10)

Finally define the second relationship using field restOfPortal in your master file and recordID in related file.

Put the second portal beside the original one.

Dj smirk.gif

Link to comment
Share on other sites

This is an excellent tip, but it will be necessary to use the 'RightWords' function, not the 'Right' function, or else it will not work as expected.

I'm sure that is what Dj had in mind! wink.gif

Link to comment
Share on other sites

This topic is 7808 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.