Auto Generate Code for Key Column without UNIQUEID()

[stephenrich]

Dear Appsheeters,

Is it possible for us to create a custom generated ID for a key column, that depends on the Transaction Date, for example I want to create a Sales Quotation Number with custom format like this 

SQ-2024-0001, where I need to grab the SQ Date for creating the Year Number within the SQ No.

I managed to do it, but, I cannot regenerate the initial value every time i change the SQ Date, 

is it possible to reset the Initial Value before saving? I know that initial value of a key column doesnt have the "Reset on Edit" feature.