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: [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)
************************************************************
Hi,
That indeed did the trick !
Thanks anyway !
--
mvg
--------
Dr. Eric Van Deputte dvm
1750 Lennik
[email protected]
[email protected]
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
