I am new to Filemaker and am looking for a specific Script.
For some reason I would like to be able to get the value of a record after a sort.
I would ilke to have this value to be the first one that appear on top of the list. And then I would like to increment this value by 1 thru the Script too.
I can make the button and the sort but I don't know how to properly extract the value of the first field of my record and then increment by one.
For exemple: Sort all values from highest to lowest Number_Field:
And I would like the script to pick 999 which is on top and increment by one which would be 1000.
Any idea ?
Looking forward to your help;