Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [auto-number]

The tag has no usage guidance.

0
votes
1answer
22 views

Auto Number Field Format

I want to make an Auto Number Display Format field that start counting from 1 and not from 0. means {1000}.. I'm getting an error when doing it on the auto number field.. Thanks!
0
votes
1answer
25 views

AutoNumber based on Fiscal Year

I have Autonumber (fiscal year). For example Jan 1 2018. My AutoNumber field will be 180000 . For next Year Jan 1 2019. my autonunber should be 190000.. is this possible ? Thanks for the help
0
votes
0answers
19 views

Auto case number based on a specific record type? [duplicate]

We have around 10 case record types. We have one specific record type for our service cases. We want the cases to be assigned an auto case number whenever a new case is created. We do have a auto ...
0
votes
1answer
71 views

CaseNumber is not visible after case creation

I am having a facing a problem with CaseNumber. I am creating a case object with all the mandatory field in my apex code. Case caseObject = new Case(DBG_Country__c = country, ...
0
votes
1answer
31 views

Issue on creating auto number field

I need to create an auto number field on custom object in packaging org. I'm not able to create it now because it's throwing an error while creating it: you cant able to create auto number field ...
0
votes
1answer
47 views

Best way to track an incrementing number in Salesforce

I'm trying to track an incrementing number in Salesforce with the following caveat: The number should only increment when a Lead or Contact meets certain criteria. This has been working ok with a ...
-1
votes
1answer
43 views

Auto Number Name field dependent on picklist value

I have a Auto Number standard field (Name) of custom object (Term__c) which is to be dependent on custom field Color__c (picklist) of same custom object. For each picklist value, such as "red", "...
0
votes
2answers
29 views

Creating a trigger, that loops through auto number field, checks date and updates specific field to expired

I have an object named EXAM, exams have a unique Autonumber ID that starts from 0 and goes up to 10000. But this auto number is recorded as a TEXT by default. I want to create a loop, that goes in to ...
0
votes
1answer
30 views

Fixing Autonumber Issue

I have an object X which has Standard Name field as autonumber. There are about 10000 records in tht object. Upon checking found out that out of 10000, only 600 records are in autonumber, rest all are ...
2
votes
1answer
120 views

Salesforce change field from non-updateable to updateable

There is a particular scenario where an auto-number field had to be disabled during a certain operation. This example on salesforce is exactly similar to my restore requirement. For this, the field ...
1
vote
2answers
159 views

auto number depending on picklist

is it possible to have a auto number field count only if a specific picklist value is selected? Can this be done with a trigger? Below is my use-case: I have a picklist with different customer types. ...
0
votes
1answer
48 views

Rename Account Detail Label near buttons and Custom auto number field

I want to rename Account Detail to Vendor Detail and not change the tab label. Also, there is auto number field on account, I want to rename it. And I cannot seem to find this field to rename in ...
0
votes
1answer
1k views

Getting the next Auto Number in sequence

I'm operating within the context of a before insert operation, but I'd like to display the current auto number on the creation page. Without the record being inserted into the database it isn't ...
3
votes
1answer
98 views

Migrating Cases between Orgs - preserve/set CaseNumber

As a system field I am unable to set CaseNumber on the default Case object when I do my imports from my legacy Org. I've already created a custom Permissions Set as per and In there I do see Edit ...
2
votes
1answer
387 views

How to set auto-number as external Id

I am not being able to set a Auto-number field as an external Id. I read in a lot of documents that it can be done
0
votes
1answer
60 views

Is it possible to create interface for user to reset auto-number field?

I know that system administrator can reset auto number according to How do I reset/restart an auto number field?.But is it allow to be resetted by user through visualforce?Is it possible to develop it?...
2
votes
3answers
660 views

Deployed autonumber field not populated

I needed an autonumber field in account for an apex class which sends mails to customers. In sandbox I added an autonumber field and checked the option to generate values for existing records/accounts....
1
vote
1answer
858 views

Migrate startingNumber for AutoNumber field using ANT

I am attempting to migrate a Custom Object using Salesforce, and all is well except the Starting Number for a formatted AutoNumber field is not pulled. I have read through the MetaData Guide (below) ...
0
votes
4answers
435 views

ORDER BY Autonumber is not working

In SOQL we are using ORDER BY a auto number field in a parent object. But the order is not proper. For Ascending order we are getting the following output For Descending order we are getting the ...
3
votes
1answer
643 views

Write to an autonumber field or not require entry of text name/id field

So I had a Name field with text and had populated it with Account Names. Upon converting back to an autonumber, all of the existing data had stayed the same and all new records received the ...
5
votes
2answers
869 views

Irregularity in auto numbering

I have been noticing this and it has happened more than once. I have an object and it's name is the standard auto number. When I'm creating the records, after a few records, the auto number seems to ...
10
votes
1answer
239 views

Why does an autonumber sequence get “stuck” when creating records after a @testSetup method?

I ran into this while writing unit tests for my org but I simplified it in a developer account to make sure it would happen there. I have custom object Thing__c. The Name field is autonumber. I wrote ...
2
votes
2answers
137 views

Account Auto-Numbering

I'd like to know how to Auto-Number all Accounts upon creation by User Interface or Data Loader with a unique number. Also, I'd like to include existing Accounts in the initial count, then ...
0
votes
2answers
60 views

Showing the opportunity ID for a new record in standard page layout before record is actually saved

Is it possible to obtain the opportunity (or another standard objects) ID value before the record is saved?
3
votes
1answer
475 views

Can I show an auto number field (or any other unique ID type value) on a new record before it has been saved?

A simple request. I am customising an opportunities object page layout and want to show a UID type value that staff can quote to people. I have this working currently with an auto number field but ...
4
votes
1answer
800 views

Do Unit Tests Increment Auto Number Fields?

I just created a new object with an auto-number name field. Its Starting Number is 0. I ran many unit tests before creating any data, and the true Starting Number I observed is 1420. Is this ...
1
vote
1answer
1k views

How to generate Auto Number Using Apex Class

I have a below requirement - I have two custom objects Product and childproduct. childproduct is a related list (lookup) to Product . When i will create a childproduct i want the name should be ...
0
votes
0answers
78 views

Paragraph Sections and Sub Sections Numbering in Visualforce PDF

Am rendering vfp as PDF. I want to show sections and subsections Numbering dynamically to the paragraph for example 1. First Section 1.1 First Subsection for first section 1.1.1 child for ...
0
votes
1answer
2k views

How to generate auto number using triggers

In my account object, I have a custom field aNo. This should do the same functionality as an auto number. public class incrementHandler{ set <Id> accId; list <Account> aList; ...
1
vote
0answers
37 views

Is it possible to translate an auto generated prefix for an object's name?

Like in the title. I have, for instance, an object that has it's name as an Auto Number. I can assign a prefix for it just fine in English, but what if I wanted to translate my app, and the prefix ...
0
votes
1answer
520 views

Trouble converting an autonumber to text

I have an AutoNumber field in my leads. I'm assigning leads based upon the last digit of that field. Salesforce says the following code has no syntax errors: RIGHT(RoundRobin__c, 1) == text(1) || ...
0
votes
0answers
43 views

Restart a generated field? [duplicate]

My question is quiet simple: I have a custom object which his key field is auto-generate. It has this format: {YYYY}{0000}. So it will be something like this: 20150150, 20150151, ... , 20150199 1th ...
1
vote
1answer
110 views

Auto number field cannot be added into managed package object, any walkaround?

We used to use a ordinary number field to dynamically generate record names in the trigger (because the name is composed of several parts). But now we are considering more about the thread safety. Say ...
0
votes
2answers
518 views

Can I use Javascript to populate a custom auto number field only when a button is clicked?

I am very much a Salesforce newbie (I'll apologise in advance :) ), and need some help with some Javascript in our Professional Edition. I have created a custom auto number field in our Opportunites. ...
0
votes
3answers
162 views

How to use += operator on formula field?

On Delivery note Line Item , I have the field Delivered_Quantity__c ( number type ) and , I 'd like to record the total number of this field for each items . So the idea is I create a new field called ...
2
votes
1answer
268 views

Importing Contracts: What to do with contract number?

I have a customer who is already using Contracts that wants to import a bunch of their old Contracts. One caveat is that the Salesforce auto-number for Contracts is prefixed with the current year, so ...
2
votes
2answers
2k views

How to Reset a Standard Auto Number Field?

Autonumber field increments when test class runs and note that in Spring14 salesforce has released an option not to increment when test class runs. Develop | Apex Test Execution | Options..., ...
3
votes
2answers
2k views

Auto Increment Number Based on Another Field

Our customer number ranges are different for each company we acquire. For example, company A has a customer number range that falls between 100,000-199,999. Company B has a number range that may fall ...
1
vote
0answers
329 views

How to auto-number quote line items 1,2,3… but for each quote?

When I create a quote with say 3 items surely these items appear enumerated as 1,2,3. But then when you create a new quote it keeps going to 4,5,6... Does anyone know how to create a custom flied ...
2
votes
1answer
981 views

Is it possible to populate a field of type Auto Number External ID?

I'm trying to populate a Lookup using External ID which is Auto Number field. It is giving the error: Compile Error: Field is not writeable: Opportunity.Opportunity_Number__c Opportunity_Number__c ...
0
votes
1answer
95 views

Can I used Record ID to determine insert order? Of not what?

We're worried with data volumes that using an AutoNumber may cause overflow problems during the lifetime of the system, so look to the ID as an alternative. (We've been told we may need to scale to a ...
2
votes
2answers
481 views

High frequent sequential generated unique autonumber

I have a requirement where I need a sequential unique autonumber field on opportunity. To me that seemed simple to just the standard Salesforce Autonumber field. This seems to work fine, when we have ...
1
vote
1answer
395 views

Apex trigger not working

I have tried to set the name field of the Volunteer Job object to the case number or an auto increment number and neither seems to be working. I have tried to use a trigger: trigger AddCaseNumber on ...
2
votes
1answer
2k views

When is an autonumber generated?

I have a visualForce page that contains an object which has a autonumber as name. When the user presses save, the object is stored and I want the name to be populated with the name of the object. I'm ...
1
vote
2answers
83 views

Editing my custom Vendor object

So, I'm trying to edit a custom object 'Current or Previous Vendor' page to display name of the actual vendor. As you can see from the screen-shot I've attached in this thread, it's displaying the ...
3
votes
2answers
905 views

How does the field type “Auto Number” calculate?

I'm looking for the formula used by Salesforce on Data Type: Auto Number fields. I assumed it was sequential (increases by 1 from the last number generated), but according to our data, it doesn't ...
5
votes
1answer
543 views

Executing workflow/trigger before autonumeric field is calculated

The scenario is: I have an autonumeric field Perspective_Code__c. I have a text field Original_AC_Code__c. I have an external id text field Opportunity_Code__c. When a record is inserted/updated, I ...
6
votes
1answer
2k views

Can the Auto Number display format reset for each new year

I have created an Auto Number with the following format: {YYYY}/{000}. Is it possible for the number increments {000} to reset to 1 for each new year?
3
votes
1answer
2k views

Auto Number field

I want to update the name field of newly inserted record with auto number field value.But auto number field is showing as null.But when I see the account record I could see the value of auto number ...
1
vote
1answer
553 views

How do I populate two auto-incrementing fields in same Object

I've a trigger on a custom object Object_A__c. Now, I need to populate a receipt number id in a field receipt_id__c. There are two types of receipts X and Y namely. I need to populate the ...