Jump to content
Sign in to follow this  
Wayne Irvine

Serial numbers

Recommended Posts

I want to start at 1 for the next quarter, but it is currently 13 days before the end of this quarter. Logically I could start auto-enter serial at -13 and incrememtn by 1. So the first record would be -13, then -12 etc.

Doesn't seem to like it. First record is -13, second is -14.

Is this a bug, a feature, or known behaviour?

Share this post


Link to post
Share on other sites

By design.  It treats the "-" as a dash and will increment in the number that comes after.

Share this post


Link to post
Share on other sites
3 minutes ago, Wim Decorte said:

 It treats the "-" as a dash

This is to enable you to use serial "numbers" such as "ABC-0001".

 

48 minutes ago, Wayne Irvine said:

it is currently 13 days before the end of this quarter. Logically I could start auto-enter serial at -13 and incrememtn by 1.

Logically, it makes sense only if you create exactly one record each day. So perhaps you could use the date as a unique identifier? Or pre-create the 13 records until the start of the quarter? In any case, these identifier should be meaningless, so starting a quarter at #14 should not matter.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • By Richard Fincher
      My production Filemaker Server 14 running on Mac OS X 10.11 El Capitan (Not Mac OS X Server) has been running fine for a year since I last installed the Thawte SSL Certificate.  After renewing the certifate this year, I've tried various different methods of importing the new certificate, which came with an intermediate certificate, but I can't seem to get the intermediate certificate installed.  I've been mostly using something like:
      sudo fmsadmin certificate import --keyfile /Users/richardfincher/Desktop/GBROOMX36-4X/private.key /Users/richardfincher//Desktop/GBROOMX36-4X/ssl_certificate.crt
       
      I've also tried importing it through the web control panel.  It was necessary to remove the old private key thus.:
      sudo rm /Library/FileMaker\ Server/CStore/serverKey.pem
      After it is (apparently) installed, I usually restart with :
      sudo fmsadmin restart adminserver
      although a few times I have rebooted the server (not a VM)
       
      Any thoughts welcome....
       
      Oh, one thing is, a year ago it might have been still on Mac OS X 10.8.5 Mountain Lion, which was the previous OS before I upgraded it.
    • By Qam Qam
      hello every one 
      there is a way to send SMS without any plugins , 
      there is a teacher named (guy setvens) who have course on udemy to explain it , problem is its paid , i i cant afford it 
      any one knows how to do it 
      please 
      i have bought 10000 SMS with api form sms provider 
      but i dont know how to use it without plugins 
       
    • By Qam Qam
      Hello every one 
      i want to mention multiple filed in the email 
      like agent name 
      created by 
      and date of creation 
      to be sent to the manger 
      now i can only send one field  in the email 




    • By Qam Qam
      Hello everyone ,
      this is my 1st post in this helpful website 
      thank you guys ive learned a lot 
       
      iam working on recruiting software for my office 
      its simple 
      my issue now that i want to set simple days count down timer 
      for example if my client requested his procedure finish in 60 days or 90 days 
      i want to know left days in a list so i can give pioirty 
      so i used the following 
      GetAsNumber ( Contract_End_Date - Get ( CurrentDate ) )      
      which appears in the remaining days filed 
      it worked fine for me 
      the issue is 
      it remains  frozen , next day its the same value like yesterday 
       
      sorry for my bad English '
       
      please help me 
      thank you 

    • By DR. ALI BAHAR
      Dear All,
      I have tried to access the SQL database, through the ODBC, as a data source in the online filemaker solution but I am not successful , i don't know if i am missing something ?
      can any one help in this regard ?
      Thanks in advance.
      Regards
      Mr. Ali Bahar
      Pakistan.
  • Who Viewed the Topic

    11 members have viewed this topic:
    Robert Mota Hawks  V!ncent  gczychi  arni  Lee Smith  fillmore  Ron Cates  Fitch  Lola  OlgerDiekstra  rwoods 
×

Important Information

By using this site, you agree to our Terms of Use.