Questions tagged [auto-number]
The auto-number tag has no usage guidance.
70
questions
0
votes
1
answer
57
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 ...
0
votes
1
answer
296
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 ...
1
vote
2
answers
247
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 ...
- 83
0
votes
1
answer
80
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 ...
2
votes
0
answers
129
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-...
- 21
0
votes
2
answers
205
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 ...
- 3,210
0
votes
1
answer
516
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
- 87
0
votes
1
answer
181
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.
- 1,331
0
votes
2
answers
708
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
- 101
3
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 ...
- 8,788
0
votes
2
answers
845
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 ...
- 195
0
votes
1
answer
315
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 ...
- 61
1
vote
1
answer
143
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 ...
- 361
0
votes
1
answer
255
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) ...
- 19
3
votes
1
answer
532
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 ...
user56320
0
votes
1
answer
394
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.
...
- 55
0
votes
1
answer
57
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
1
answer
589
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!
- 1,053
1
vote
1
answer
525
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
- 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 ...
- 57
0
votes
1
answer
1k
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, ...
- 1,175
0
votes
1
answer
189
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 ...
- 11
0
votes
1
answer
216
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,236
-1
votes
1
answer
349
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", "...
- 1
0
votes
2
answers
46
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 ...
- 151
0
votes
1
answer
174
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 ...
- 381
2
votes
1
answer
818
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,089
1
vote
2
answers
342
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
1
answer
102
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 ...
- 11
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 ...
user24634
4
votes
1
answer
630
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 ...
- 145
2
votes
1
answer
908
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
- 371
0
votes
1
answer
83
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,502
3
votes
3
answers
3k
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....
- 475
1
vote
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) ...
- 113
0
votes
4
answers
1k
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 ...
- 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 ...
- 1,600
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 ...
- 672
10
votes
1
answer
594
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 ...
- 610
2
votes
2
answers
217
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 ...
- 213
0
votes
2
answers
136
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?
- 261
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 ...
- 261
5
votes
1
answer
2k
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 ...
- 147k
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 ...
- 1,620
0
votes
0
answers
128
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
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;
...
- 672
1
vote
0
answers
124
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 ...
- 11.8k
0
votes
1
answer
1k
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) || ...
- 463
0
votes
0
answers
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 ...
- 143
1
vote
1
answer
276
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 ...
- 12.9k