Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to get the last known value of a textfield in a textbox.
What I've got: records with data regarding different persons (1 record for every month and person). My selection is always 1 person, in the most recent record/month i've got a field which tells me that it is the most recent record for this person (_Lastmonth = 1, all other records for that person have _Lastmonth = 0). What I'm trying to get is the value of last known working loction (fieldname = Facts.Location).
In records
Record - Employee - _LastMonth - Facts.Location
1 - A - 0 - Amsterdam
2 - A - 0 - London
3 - A - 0 - Hong Kong
4 - A - 1 - Almere
What I like to get in my textbox = "Almere"
I've tried combination with ({$<_LastMonth={1}>}Facts.Location), but got no result.
Has anyone an idea?
Best regards,
Raimund Leussink
Try =only({$<_LastMonth={1}>}Facts.Location)
Note that this will only work if there's only one record where _LastMonth is 1. So you have to make a selection first if you have more employees. That's what you say you do so the expression should work in your scenario.
Try =only({$<_LastMonth={1}>}Facts.Location)
Note that this will only work if there's only one record where _LastMonth is 1. So you have to make a selection first if you have more employees. That's what you say you do so the expression should work in your scenario.
Thanks for the fast reply