Eric, Sorry for the slow response, this message got buried in the holiday sales rush!
If I understand correctly, you are wanting to update an auto entering serial number when you finish importing data after an update/restore from backup, whatever, correct? If so, this is totally do-able using the Set Next Serial Value script command. Your script should look something like this: Sort Records [field] ascending ##Go to the last record to get the highest Serial Value Go to Record/Request/Page [Last] ##Set the Auto Enter serial value to the next number (adjust the +1 to whatever auto-enter sequence you use) Set Next Serial Value [$field + 1] Hope that helps, Rick ------------------------------ Rick O'Quinn Division of Marketing & Communications Operations Manager Hodgson Oil Building 286 Oconee Steet, Suite 200N Athens, GA 30602 p: 706-542-8085 <tel:7065428085> e: [email protected] w: mc.uga.edu <http://mc.uga.edu/> <https://www.facebook.com/uga.edu> <https://twitter.com/universityofga> <https://www.instagram.com/universityofga/> <https://www.linkedin.com/edu/school?id=18190> <https://www.youtube.com/uga> <https://www.snapchat.com/add/university-ga> On 11/21/18, 6:00 PM, "FileMaker Pro Discussions on behalf of FMPRO-L automatic digest system" <[email protected] on behalf of [email protected]> wrote: There are 2 messages totaling 60 lines in this issue. Topics of the day: 1. how changing the starting nuber in an automatic input (2) ---------------------------------------------------------------------- Date: Wed, 21 Nov 2018 17:54:10 +0000 From: Rowland Carson <[email protected]> Subject: Re: how changing the starting nuber in an automatic input On 2018-11-20, at 22:36, Eric Van Deputte <[email protected]> wrote: > supposing transferring data from one file to another empty identical (but upgraded) file. > > Using which scriptline(s) should I be able to make a specific number (in fact the highest number already been put into a "$field") > > the new starting number of an autolmatic inputfiled ? Eric - I’m not sure if there is a way to do it by scripting (have never thought about this question!). Obviously if you have to do this several times, scripting is the right approach. But if you are only doing it once, I would check the starting number required from the original file of data, then before importing the data to the empty file, change the field definition in the empty file so that the starting number of the auto-enter field corresponds to that. Hope this helps. in friendship Rowland | Rowland Carson ... that's Rowland with a 'w' ... | <[email protected]> http://www.rowlandcarson.org.uk | Skype, Twitter: rowland_carson Facebook: Rowland Carson ------------------------------ Date: Wed, 21 Nov 2018 19:38:57 +0100 From: Eric Van Deputte <[email protected]> Subject: Re: how changing the starting nuber in an automatic input [Message contains invalid MIME fields or encoding and could not be processed] ------------------------------ End of FMPRO-L Digest - 20 Nov 2018 to 21 Nov 2018 (#2018-4) ************************************************************
