I have the following table where I need to concatenate the last three columns into the "Notes" field to be saved to Laserfiche:
I created a hidden field to concatenate Doc ID-Document #-Rev.:
But all I got was:
Instead of "CALC-11252-0200-01; DWG-11064-30-20-02; SPEC-NUH32PTH1-0105-01" which is what I was hoping for. So I decided to try a formula and got:
Again, close, but not helpful. Received an error that the notes field is not large enough to support the data I'm trying to save.
I've seen some posts associated with concatenation using java, but was hoping there was an easier way.