Solved

Autp record number problem

Posted on 2004-08-23
11
326 Views
Last Modified: 2010-04-27
When I Choose new record, and then I decide to cancel and later on I want to choose new record I gave me extra record number. What script I should use ?  Example will help you to understand better

Example:               Existing record number  =  1000

 [ON CLICK A BUTTON I GET NEW RECORD NUMBER] =   1001

then I decide not to proceed  I choose to cancel /delete

Next day I went back to database and I like to add new record
and the record number should be  1001
                                                                   
But I’m getting record number =  1002

I'm using auto enter serial number with one increment. Some one suggest me to make a script for deletetion when I delete record it should delete record number too , but I'm unable to come up with script.

Please give me complete script

Thanks
 
0
Comment
Question by:gurshaan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
11 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 125 total points
ID: 11878532
hmmm - I use a swedish FileMaker, so the scripts appear swedish...
but the "delete script" should be something like:

1) set next auto serial number(fieldOfSerialnumber,fieldOfSerialnumber-1)
2) delete the record.

BUT - the above will NOT WORK... The reason is that if you have a button, as soon as you create a record, nothing prevents you from browsing to a different record:
Have existing #1000
Add a new, that becomes #1001
you browse to record #500
you remove record #500 - then you would nave no #500, but you would have two #1001.
So you would have to add to the above script - 3) renumber all record numbers so there are no missing ones. And if it is a big database that might take time (sort on record number, then loop through all records and check if there is anyone missing and fix the numbering by moving fields contents so no "holes" exist)

But you would not be able to use Recordnumber to track the last created record.
I think it is better to THINK differently. Use whatever number FileMaker gives and live with the holes.

Or (to get it faster) - When you delete, delete all field contents, EXCEPT for the record number. And When someone wants to enter a new record, show him the "empty" that has been created already. Thereby you always have numbers filled.

An ever easier way is to use the STATUS (RecordNumber) function  - instead of auto-loop-number. Then you'd always have the correct recordnumber.

So the real question is - what do you actually want to use the number for? To just see a record number on a layout, you can write ## as text and that would automatically show the real recordnumber when you print or do preview.

with a smile
/prifre
0
 
LVL 28

Assisted Solution

by:lesouef
lesouef earned 125 total points
ID: 11886126
I use a simple confirmation msg before creation.
For a stronger check,  I ask the user to enter important data in a few global fields, my script test their value, then creates the new record by copying global fields values to the right fields if everything is valid, otherwise back to record creation layout with a warning msg... but I agree with him, is a non continous serie a problem? there are many ways to count fields or have a unique numbering system without auto functions of FM.
0
 
LVL 19

Expert Comment

by:billmercer
ID: 11893028
gurshaan, I didn't see in any of your questions what version of Filemaker you're using. That could affect your possibilities. If you're using 5.0 you won't have the Set Next Serial script step. I think 5.5 was the first version with this feature.

I agree with the others, this is probably not the problem you think it is. If you just want a sequential number series, follow prifre's suggestion and use the status(recordNumber) function.

Think of the autonumber as a record of database activity rather than just a sequence number. This can be useful when troubleshooting. Also, you can deliberately create gaps as a way of tracking when data was entered.

Example: Last year, the records in a table were all in the range 1000 to 40000. After a major change to our policies was made, I increased the autoincrement to 100,000. Now I can tell at a glance which records are from before the change, without having to remember the date the change was made, or add an extra flag to the table.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 19

Expert Comment

by:billmercer
ID: 11893100

>if you have a button, as soon as you create a record, nothing
>prevents you from browsing to a different record:

You could just omit all records before creating the new one. Wouldn't prevent a determined user from screwing up, but it would reduce the chance of careless browsing.
0
 

Expert Comment

by:hainaux
ID: 11929104
Unfortunately my FM is in french but I will try to translate the script I use or that :
1- Sort ( no dialog )
2- Display record (last)
3- Define serial number following ( "Number_Field", "Number_Field+1")
Normally after 1000 you will get 1001 even if you have deleted 1001 previously
Good luck
José
0
 
LVL 9

Expert Comment

by:prifre
ID: 12207211
I like my answer. Pity the asker doesnt care.
/prifre
0
 
LVL 28

Expert Comment

by:lesouef
ID: 12208119
fair, he was the 1st to jump on this one!
0
 
LVL 19

Expert Comment

by:billmercer
ID: 12292700
No objection from me...
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question