Solved

Autp record number problem

Posted on 2004-08-23
11
296 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
  • 3
  • 2
  • 2
  • +1
11 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 125 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
 
LVL 19

Expert Comment

by:billmercer
Comment Utility

>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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Expert Comment

by:hainaux
Comment Utility
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
Comment Utility
I like my answer. Pity the asker doesnt care.
/prifre
0
 
LVL 28

Expert Comment

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

Expert Comment

by:billmercer
Comment Utility
No objection from me...
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

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…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now