Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [auto-number]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3
votes
1answer
75 views

What happens when auto number reaches its pre-set max? [duplicate]

I have a standard field that I have assigned the following Display format "A-{0000}". What happens when it reaches A-9999? I'm not able to find the answer online and I want to make sure it does not ...
0
votes
1answer
54 views

Trigger to make autonumber field on account with format 'ACC-001'

I need to create a trigger that will autopopulate the field created in Account object. The field value will be auto populated using the value like 'ACC-001','ACC-002' everytime an account is created. ...
0
votes
1answer
31 views

generate customized auto number

I wanted to generate number as per region and division like.. I have four regions: Africa, America, Asia, Oceania and divisions are Electrical MEP HVAC Plumbing also, it should consider financial ...
0
votes
1answer
57 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
46 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
28 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
241 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
38 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
58 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
51 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
31 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
36 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
163 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
193 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
52 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 ...
1
vote
1answer
2k 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
136 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
499 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
65 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?...
3
votes
3answers
890 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
1k 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
599 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
862 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
981 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
277 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
149 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
62 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
577 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
1k 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
83 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
45 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
636 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
121 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
554 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
181 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
295 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
349 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
1k 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
96 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
516 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
396 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
87 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
971 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
548 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 ...