rivet Posted April 1, 2016 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
rwoods Posted April 1, 2016 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now