How do we do “last item -1” (Last item minus 1) on a date field?
1 Like
I had to look that word up:
pe·nul·ti·mate
pəˈnəltəmət/
adjective
last but one in a series of things; second to the last.
1 Like
old topic, but i had a similar problem. This is my solution:
In a RG I have Previous action date (text), and Next action date (input). I want to move the current action date to show up under Previous action date when I create a new Next action date.
I created a third field in the RG that searches for ‘all actions:count-1’
The previous action has :item# and takes the value from the third field that counts the total number of actions minus one.