ADM-201 · Question #282
An administrator has been asked to change the data type of an auto number to a text field. What should the administrator be aware of before changing the field?
The correct answer is A. Existing field values will be deleted. When an administrator changes an Auto Number field to a Text field, all existing Auto Number values for that field on records will be permanently deleted.
Question
An administrator has been asked to change the data type of an auto number to a text field. What should the administrator be aware of before changing the field?
Options
- AExisting field values will be deleted.
- BExisting Auto Number field to Text is prevented.
- CExisting field values will be converted.
- DExisting field values will remain unchanged.
How the community answered
(36 responses)- A86% (31)
- B8% (3)
- C3% (1)
- D3% (1)
Why each option
When an administrator changes an Auto Number field to a Text field, all existing Auto Number values for that field on records will be permanently deleted.
Changing the data type of an Auto Number field to a Text field is a destructive operation; Salesforce explicitly warns that all existing auto-generated numbers in that field on records will be lost and deleted during the conversion.
Salesforce does allow changing an Auto Number field to a Text field, though with a critical data loss warning, so the action is not prevented.
Existing Auto Number values are not converted into text values; they are instead deleted entirely when the field type is changed from Auto Number to Text.
Existing field values will not remain unchanged; they will be deleted, leaving the field blank on existing records.
Concept tested: Data type change impact (Auto Number to Text)
Source: https://help.salesforce.com/s/articleView?id=sf.fields_notes_on_changing_field_types.htm&type=5
Topics
Community Discussion
No community discussion yet for this question.