Results 1 to 8 of 8

Thread: need a custom field with auto-increment

  1. #1
    mmirandag is offline Senior Member
    Join Date
    Dec 2009
    Posts
    47

    Exclamation need a custom field with auto-increment

    Hello all!

    I already created a custom field for lead module, but, it has to auto increment and must be displayed without format (ie: 1234567890 and not 1,234,567,890).
    I´ll appreciate any ideas or suggestions about solving this issue!

  2. #2
    mmirandag is offline Senior Member
    Join Date
    Dec 2009
    Posts
    47

    Talking Re: need a custom field with auto-increment

    ooops... forgot the environment I´m working with :

    Running SugarCE 5.5.0,

    cPanel Version 11.24.5-STABLE;cPanel Build 38506
    Apache version 2.2.14 (Unix)
    PHP version 5.2.11
    MySQL version 5.0.85-community
    Architecture x86_64
    Operating system Linux

  3. #3
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: need a custom field with auto-increment

    Have a look at this thread. for auto increment fields.
    To remove formatting edit the custom field on Studio and set the attribute 'disable_num_format' to true.

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  4. #4
    mmirandag is offline Senior Member
    Join Date
    Dec 2009
    Posts
    47

    Default Re: need a custom field with auto-increment

    Hi André !

    thanks a lot for you answer, however, I can´t find the attribute 'disable_num_format' .
    I went into iStudio -> Leads -> Fields. Then clicked on my custom field "file_no_c" , and this is what a see:

    Data Type: Decimal
    Field Name: file_no_c
    Display Label:
    System Label:
    Help Text:
    Comment Text:
    Default Value:
    Max Size:
    Precision:
    Required Field:
    Audit:
    Importable: Yes No Required
    Duplicate Merge: Disabled Enabled

  5. #5
    andopes's Avatar
    andopes is offline A Sugar Hero | Help Forum Moderator
    Join Date
    Jul 2006
    Location
    São Paulo - Brazil
    Posts
    8,335

    Default Re: need a custom field with auto-increment

    That is weird!
    You should be able to see the option "Disable Format".

    Cheers
    André Lopes
    DevToolKit / Project of the Month - June 2009
    Lampada Global Services- Open Source Solutions
    Avenida Ipiranga, 318
    Bloco B - CJ 1602
    São Paulo, SP 01046-010
    Brazil
    Office: +55 11 3237-3110
    Mobile: +55 11 7636-5859
    e-mail: andre@lampadaglobal.com

    Lampada Global delivers offshore software development and support services to customers around the world.
    Lampada is proud to be a SugarCRM Gold Partner, revolutionizing Customer Relationship Management.

    I DO NOT answer questions through PM and Email. If you need some help post your question into SugarForum.

  6. #6
    blitz2190 is offline Senior Member
    Join Date
    Jul 2009
    Posts
    105

    Default Re: need a custom field with auto-increment

    you can add the field andopes said in the custom vardefs and it should work
    PHP Code:
    'disable_num_format' => true

  7. #7
    mmirandag is offline Senior Member
    Join Date
    Dec 2009
    Posts
    47

    Default Re: need a custom field with auto-increment

    Hi Andre and Blitz2190!

    I get the same view of the field using Firefox ver 3.5.7 and IE ver 8.0.6001. Perhaps is like this in SugarCE ver 5.5.0.

    .I'll do some reading in the developer guide in order to go into coding and try Blitz2190 suggestion!.

    I´ll share the outcome of it!

    Thanks a lot to both of you!

  8. #8
    mmirandag is offline Senior Member
    Join Date
    Dec 2009
    Posts
    47

    Default Re: need a custom field with auto-increment

    Hi!

    I found the mistake: I selected "decimar" instead of "integer"... changing this, makes the "format" message appear and works fine.

    Thanks all for your help!!!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. auto increment value in field
    By pearsondan99 in forum Developer Help
    Replies: 18
    Last Post: 2009-06-26, 04:18 PM
  2. auto-increment id
    By jcb23 in forum Help
    Replies: 4
    Last Post: 2009-03-23, 02:44 PM
  3. Auto Increment Integer Field
    By Spy123 in forum Developer Help
    Replies: 0
    Last Post: 2007-01-24, 10:02 AM
  4. Replies: 0
    Last Post: 2006-03-06, 07:41 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •