Questions tagged [auto-number]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

Is there a way to change the 'Auto Number' Name of Standard Objects?

We are using Salesforce Maps to schedule Visits to Retail Stores. We've noticed that the Visit records that are created are using an Auto Number as the Name, giving values such as "00000564"...
user avatar
0 votes
0 answers
102 views

Dynamic Custom Object Name auto number formatting

I have a requirement when creating a Custom Object to dynamically have the Name (when auto-number) prefix changed based on Record Type. It looks like it can't be modified in a trigger and I don't see ...
mackmama's user avatar
  • 669
0 votes
1 answer
274 views

Name field - Formula fields

I got to explain well the scenario. I have a custom obj with 10 different Records Types. I want the name field (which at the moment is an autonumumber with the following format {YYYY}{MM}{DD}{0}) to ...
JACOPO PARISI's user avatar
0 votes
1 answer
471 views

Duplicate Autonumber(Custom) gets created, when different user creates the records at same time

We are creating a custom autonumber in the custom invoice object. For this, we used the Before insert event in the apex trigger. So the user will generate bulk invoices based on the term for all the ...
Johny Aar1's user avatar
1 vote
2 answers
359 views

Cannot deploy or update autonumber field

I just hit a very strange issue when trying to deploy my sources today. We have an autonumber field on Lead (format: {YYYY}-{0000000000}; starting number: 1000), that already exists in my sandbox. But ...
Cissou's user avatar
  • 83
0 votes
1 answer
182 views

Restore Auto-Number on Managed Object

In our managed package, we have a custom object where the Name field is an auto number We're using a flow to create records of that custom object In our trial source org, somebody tested that flow and ...
Sebastian Lechner's user avatar
2 votes
0 answers
199 views

Setting one autonumber that will sync to all (related) objects [closed]

We have decided we want all Leads, Opportunities, Quotes and a few custom objects to inherit the same autonumber so that it is easy to see related objects just by the number. Leads should get an LD-...
Tom's user avatar
  • 21
0 votes
2 answers
308 views

Migrate Quote with Quote Number from one Salesforce Org to another

I'm migrating Quote record of one salesforce instance to another Salesforce instance. The Quote number in source org is in Q-{MM}{YY}-{0000} format. I have changed the quote format in my target ...
salesforce Developer's user avatar
0 votes
1 answer
718 views

Change Name field on lead object to auto-number - is this possible?

I was trying to change the field type on the lead object to an auto-number but it doesn't seem I can as there is no option to do so - does anyone know if this is possible? Thanks
patriciajlim's user avatar
0 votes
1 answer
307 views

Trying to change object ID from Name to Automatic Number

I am getting an error when trying to change a custom object's unique field from a Name to Auto #. I made sure that all the current Names are #'s.
Michele Kleinhomer's user avatar
0 votes
2 answers
937 views

Why use autonumber as external id [closed]

I can't figure out why use autonumber as External ID. There is some case when must be used an auto number as ExternalID? Thanks
DevOps85's user avatar
5 votes
1 answer
2k views

When is an Auto Number value generate

I need to use an Auto Number field to set the value of the Name field to a composite value of AUTO_NUMBER - NAME - DOB I've got an Auto_Number__c field and a before insert trigger which gets the max ...
Robs's user avatar
  • 9,177
0 votes
2 answers
1k views

Different formats of auto number Name field

If we have a custom object with Name as AutoNumber and 3 record types, say 'A', 'B' and 'C', is it possible to set Name field's value based on its record type? For example, if I try to create a record ...
Suhasini's user avatar
  • 307
0 votes
1 answer
426 views

Autonumber with custom setting

I have a custom setting to numerate the opps by year. When an opp is insert, it fires a trigger that call to the method 'renombrarOppEmpresa'. I look for the record of the custom setting per year, I ...
Chandlerbeen's user avatar
1 vote
1 answer
164 views

Auto-numbering for Self-Lookup Hierarchy of Records

Context: I have an Object named Objective__c which has a lookup field to itself named "Parent Objective". I also have a field named "Level" which has 4 types of levels. Using these 2 fields, a user ...
JustinF's user avatar
  • 403
0 votes
1 answer
320 views

Auto Number in Quote [duplicate]

I want to create 2 diferente autonumbers on Quote for two diferent Record Types. It is possible to do this action on Process Builder with the Condition PriorValue? E create 2 new Field (type number) ...
João Gonzaga's user avatar
3 votes
1 answer
639 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 ...
user avatar
0 votes
1 answer
458 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. ...
Ankur ---'s user avatar
0 votes
1 answer
59 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 ...
user69095's user avatar
0 votes
1 answer
791 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!
Salvation's user avatar
  • 1,137
1 vote
1 answer
637 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
King's user avatar
  • 37
0 votes
0 answers
96 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 ...
TonySF's user avatar
  • 67
0 votes
1 answer
2k 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, ...
Madhurima's user avatar
  • 1,265
0 votes
1 answer
229 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 ...
Velu's user avatar
  • 11
0 votes
1 answer
242 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 ...
McD's user avatar
  • 1,246
-1 votes
1 answer
401 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", "...
ABCD's user avatar
  • 1
0 votes
2 answers
66 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 ...
Niveth Kumar's user avatar
0 votes
1 answer
281 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 ...
user2542953's user avatar
2 votes
1 answer
1k 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 ...
dmachop's user avatar
  • 1,089
1 vote
2 answers
356 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. ...
Ralf Wittenberger's user avatar
0 votes
1 answer
109 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 ...
user46457's user avatar
1 vote
1 answer
4k 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 ...
user avatar
4 votes
1 answer
751 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 ...
Recct's user avatar
  • 145
2 votes
1 answer
951 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
Rimii's user avatar
  • 371
0 votes
1 answer
86 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?...
unidha's user avatar
  • 2,542
3 votes
3 answers
4k 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....
Obi_77's user avatar
  • 475
2 votes
1 answer
3k 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) ...
Micah's user avatar
  • 123
0 votes
4 answers
2k 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 ...
SANN3's user avatar
  • 351
3 votes
1 answer
2k 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 ...
tjcinnamon's user avatar
  • 1,620
5 votes
2 answers
2k 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 ...
User2529's user avatar
  • 701
10 votes
1 answer
674 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 ...
Pedro Otero's user avatar
2 votes
2 answers
334 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 ...
Tamim J's user avatar
  • 213
0 votes
2 answers
160 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?
AdamJones's user avatar
  • 259
3 votes
1 answer
1k 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 ...
AdamJones's user avatar
  • 259
5 votes
1 answer
3k 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 ...
Adrian Larson's user avatar
  • 149k
1 vote
1 answer
3k 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 ...
sfdc_to_learn's user avatar
0 votes
0 answers
142 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 ...
mohammed azarudeen's user avatar
0 votes
1 answer
3k 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; ...
User2529's user avatar
  • 701
1 vote
0 answers
146 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 ...
Renato Oliveira's user avatar
0 votes
1 answer
2k 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) || ...
AKor's user avatar
  • 463