Sep 30, 2016 03:43 AM
Hi,
I’m trying to create multiple new records with auto-numbers using the “fill handle” as described here:
Though you can manually copy and paste multiple cells, you can swiftly copy and paste the values of one or more adjacent cells using the fill handle. To use the fill handle simply select the cell...
My sequence has a custom name followed by a sequential number such as “Product 1”, “Product 2”, “Product 3”… etc. Using the fill handle to drag down I want it to create Product 4, 5, 6 and continue the sequence, but it only creates copies of Product 1, 2, 3 repeated for as many cells as I drag down. How can I continue this sequence without having to type it/change it every time?
Thanks.
Sep 30, 2016 12:05 PM
Hi Mark,
The Fill Handle Auto-Numbering only works for numeric fields (Number, Currency, Percent), not for text fields.
In order to get the behavior you want, you could:
Oct 01, 2016 11:33 AM
Try having a hidden autonumber column and concatenating it with "Product "