Or another approch Next to the card field, just create another field with fomula and enter this formula
So automatically create the required value and new entry also will assign automatically and retrieve the new col value alone.. V.Simple
Result
