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

Question

Question

Merge Columns for Reports

asked on April 24, 2020

I have a user who wants to know the following:

They have a forms process that saves information to a repository, there are spanish and english options and they have their own fields for each. When creating reports in Laserfiche:

"We don't want to filter out and then create another report to filter out Eng fields. We do not want two reports. We want one report with both English and Spanish fields. Presently we download the report in excel and then merge Eng and Span columns. Is there a way to merge columns in Laserfiche?"

0 0

Replies

replied on April 27, 2020

One thing you can try is to treat the English fields as the "main" fields you will be reporting on. When the form is set to English, the English fields show up and the data will be entered in them. When the form is set to Spanish, the Spanish fields show up and the English fields are hidden. For this case, you can change the field rules to "Save data when the fields are hidden" and set a formula to =SpanishField. That way, when Spanish speakers are filling out the Spanish fields, it is also filling out the hidden English fields as well, and that data will be saved on submission. Then the reports can be built on just the English fields. 

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

Sign in to reply to this post.