This video describes how to generate unique numbers in Google spreadsheet using the unique entries such as name, surname, social security number, item description and the timestamp.
Functions that are used and explained are join, join array, left, left array, mid, mid array, timestamps, time and date values as part of arrayforumulas.