Asked a question 4 months ago

How do I generate a UUID/GUID in a SemQL formula and/or in an Enricher so I can use it as a default in a record attribute (this is not for a PRIMARY key generated by Semarchy for an entity...I want to populate a field during record authoring).


I am going to answer my own question here. The solution was to declare the extensions.uuid_generate_v4() function ALREADY required by Semarchy as a custom database function. Then I invoke that in an enricher with a 'None" scope and fire that enricher on Form load...essentially creating "default" functionality where there was none.


Matthew Dahlman SEMARCHY TEAM
Declaring the function as you did is a good idea. (It's optional, and without declaring it you'll simply get a warning.) Then the rest of your steps are indeed the critical part. Nicely done.