Op 26/11/2018 om 14:16 schreef Rick O'Quinn:
> 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: [log in to unmask]
> 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" <[log in to unmask] on behalf of [log in to unmask]> 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 <[log in to unmask]>
> Subject: Re: how changing the starting nuber in an automatic input
>
> On 2018-11-20, at 22:36, Eric Van Deputte <[log in to unmask]> 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' ...
> | <[log in to unmask]> 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 <[log in to unmask]>
> 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)
> ************************************************************
>
>
Hi,
That indeed did the trick !
Thanks anyway !
--
mvg
--------
Dr. Eric Van Deputte dvm
1750 Lennik
[log in to unmask]
[log in to unmask]
www.vwin.be
phone +32(0)2 523 32 95
gsm: +32(0)475 34 80 36
---
Dit e-mailbericht is gecontroleerd op virussen met Avast antivirussoftware.
https://www.avast.com/antivirus
|
