You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Concatenate Three Fields from a Table

posted on January 16, 2018

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.

0 0
replied on January 16, 2018 Show version history

You should try adding another column to your table and concatenating each row of the table first using the Index([ColumnVariable], Row()) formula. Once you have each row concatenated, then you can concatenate just that new column to get the format you're looking for. 

1 0
replied on January 16, 2018

Thanks! Will try this tomorrow. Working on an emergent project for the moment.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.