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

    Script - Increment first record field value by 1 after sort

    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:

      999;

      990;

      970;

      540;

      230

      12

      ...

       

      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;