My use case is that I would like to create a combined unique number for non-conformance reports.  Since a non-conformance can occur in one of three areas (Safety, Environment, Quality) I want to designate them using the following format:  E-year-unique number (i.e. E-2018-123).

I generated a unique number using the stored procedure information in the help files and want to use the year field and the unique number to populate the Non-Conformance No field.

I found the post https://answers.laserfiche.com/questions/88860/How-do-I-copy-data-from-one-field-into-another#repliestomain regarding using the formulas in the advanced field settings to assign content from one field to another on the same form, but this only allows me to set the field to one of the two values (either year OR unique number) without the preceding 'S-'.

Looking for a way to create field content from two fields + static content.  Please advise, thanks.