7 Replies Latest reply on Mar 21, 2017 5:25 AM by luffyfilemaker007

    Script - Increment first record field value by 1 after sort


      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;