luffyfilemaker007

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:

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;

Outcomes