rivet Posted April 1, 2016 Share Posted April 1, 2016 (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 April 1, 2016 by rivet Link to comment Share on other sites More sharing options...
rwoods Posted April 1, 2016 Share Posted April 1, 2016 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2945 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 accountSign in
Already have an account? Sign in here.
Sign In Now