AnsweredAssumed Answered

Generating a unique project number

Question asked by otterbob on Sep 26, 2017
Latest reply on Sep 27, 2017 by otterbob

I want to generate a "project identifier" in a text field based on several fields of information on the current record.

I'm using "Insert Calculated Result"

Year of (DateReported) District is a 3 Character text, Facility is two character text, then the actual record number.

Year ( Projects::Date_Reported ) + "-" + Projects::District + "-" + Projects::Facility + "-" + Projects::Projects_PK.

Perhaps I'm expecting too much but the only thing that loads in the target field is numbers. The dashes and the text do not. The target field is text. I'm stumped.

Outcomes