I really need an new field that displays an auto generated ID.
I don’t want it to be the built in ID number, I need it to be a reference number that ‘concatenates’ (I think that’s the right word??) from a couple of other fields… For example the First 3 letters of the client name plus a date in a 6 digit format…
So, the ID field might look something like this: CLA160420. In this example, The client name is Clarins and the date is 16th April 2020
Can anyone give me an idea of how to achieve this?