Get value from previous portal row field
I'm trying to determine a value of a previous portal row field to determine what the value of the current portal row field. I can't seem to use GetNthRecord because it keeps returning a value of 1 - GetRecord always = 1...
Any help is appreciated :)
Presuming that you're operating on an active portal row, you can use the Get ( ActivePortalRowNumber ) function, and subtract 1 to get the previous row. Alternately, you can put the Get ( RecordNumber ) function in an unstored calculation field in the portal table (rather than what I'm presuming is in a script or conditional format calculation), and that should achieve the desired effect.