Concat

display concatenated data in a ChronoForms v7 checkbox group.

Overview

The user needed to combine two database fields into a single display option, a function previously handled by a CONCAT statement in CF v6.
In the checkbox group's dynamic options settings, place the two field variables directly in the 'Option Text' field, separated by your desired text, without using a specific concat function.

Answered
ChronoForms v7
jf jformicola 14 Oct, 2022
Does anyone know how to concat in CFV7? I'm trying to duplicate a form created in V6, but am having difficulty. See below, read data feeds a checkbox group and I want the "notes for trainer" displayed next to the "subject"
jf jformicola 14 Oct, 2022
It's not letting upload images. Any advice?

In the "Fields to Retrieve" of the read data in CFV6, I had this

ID
CONCAT(Subject , ' [Notes- ' , Notes_For_Trainer,']'):text
Order1
jf jformicola 11 Nov, 2022
Answer
I ended up working this out by putting the following in the "Option Text" of the "dynamic options" section of the check box group. Basically just put to vars side by side, no need to type concat.

{var:Topics.subject} Notes- {var:Topics.Notes_For_Trainer}
This topic is locked and no more replies can be posted.