Permit bypass of error 1046 for Auto-Number sys-fields

[aricke42]

Currently, auto-number sys fields return errorcode 1046 when trying to update. I can’t seem to find an existing bypass on the API using ‘strict’ or ‘overrideValidation’ properties of the cell.

Would have a few meaningful use-cases for updating the field. So far I have a few uses in mind that I would implement right away:

1. Ignore use of the Auto-Sys counter all-together. I have a quick API script to “Group By” and establish the Parent-Child relationship based on choosing which drop-down field to leverage the sheet. This adds the parent rows based on the picklist and automatically relocates all other rows to the proper parent based on the row’s value in the field. However, on a sheet with auto-number sys-fields, this will run-away with the counter the more frequently it is used.
2. Dynamic Prefix or Suffix. Your own RAID template from IT-PMO Accelerator is a good example, right now they are all R-###, but there is no use of the ‘A’, ‘I’, ‘D’.
3. "Correct" the value to align with another value from a different sheet. I have a few cases where I would like to preserve the “ID” value generated outside of the sheet when I bring a Row over to this sheet using the Auto-Number field.