Script - Increment first record field value by 1 after sort

Discussion created by luffyfilemaker007 on Mar 17, 2017
Latest reply on Mar 21, 2017 by luffyfilemaker007

Hi everybody,


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;