Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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

Recommended Posts

Posted (edited)

I have a portal with a list of dates and I would like a horizontal line to appear on just one row, the record with the closest to Get ( CurrentDate ).  I was trying some get Nth options but no luck.

divider.fmp12.zip

Edited by rivet
Posted

How about this?

 

 

divider.fmp12

I used the

Min()

function to look along a relationship from the portal rows, that matches all other portal rows, and set a flag if the current records differenceFromCurrentDate was the lowest value of all. If not the minimum, then I used the 'Hide this Object when' functionality to hide the line.

It does something slightly undefined if the date entered is later than

Get (CurrentDate)

but that could be easily refined.

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