Need a function that will generate a username value for each user listed in TableCalculated, that will not conflict with any username value that exists in Table_MASTER. The function needs to increment the generated username value by a number (consecutively) until no conflict with any existing value in Table_MASTER.
Example:
Table_MASTER/username field has values: John, John1, John2, John3
TableCalculated/username has value: john
TableCalculated/newusername = FUNCTION ?? This function would ideally generate the value "John4" since it will not conflict with any existing values in Table_Master, and is the next available number to use after John3.