Jump to content

Link to latest date from portal


chapeau_melon
 Share

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

Recommended Posts

Hello,

I can't seem to find how to make a link between the results in a portal and a field outside that portal.

The portal contains dates from a table. These date are ordered. The newest date is up/the oldest beneith.

I want to display 1 (only the most newest) date in a other field not related to the portal.

And for shure, if the portal gets updated, that field must also be update with the youngest date.

Comprendo ;)

Link to comment
Share on other sites

Sort your relationship (not your portal, or not ONLY your portal) by date, descending. Place any related field outside the portal - it will show data from the record with the latest date.

A better arrangement would use auto-entered serial numbers instead of dates - because two records can have the same date.

Another option is to use a calculated field =

Last ( related::value )

This returns the value from the last related record (according to the sort order specified for the relationship).

Link to comment
Share on other sites

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