Confiforms - Multi-Select - Seperator

[Gabe Belknap]

Hi folks, happy Monday.

I am building a form, that has a combination of both Multi-Select and Smart Mulit-Select options.

For the Multi-Select, I am able to determine a parameter between multiple values selected a "|" for example. 

I am not able to find the same option for Smart Multi-Selects, which is a challenge when exporting the data from the form where multiple items were selected from the Smart Multi-Selects.

Any thoughts on how to rectify this issue?

Thanks so much

[Alex Medved _ConfiForms_]

Hi

You will need to craft a custom exporting URL as shown here https://wiki.vertuna.com/display/CONFIFORMS/Data+Export+tricks+and+hints

You can always use the https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions to transform the values you show/export as you like

Alex

[Gabe Belknap]

Thanks Alex.

I have marked the Allow data export on the Form Definition, as well as created a table view macro inside the Form, enabling export.

When i export the data however, it still looks the same. Is there somewhere in the table view macro that i should be defining how to split the fields? I don't see anything obvious, so appreciate the help.

Thanks

[Alex Medved _ConfiForms_]

In the TableView, for example, you can put fields to export in here. And these fields may have virtual functions to transform the values and produce the desired output

[Gabe Belknap]

HI Alex,

Should this macro be within the overall Form Definition that is being used to capture all the data in the form? 

Is there a way to confirm if the fields have a virtual function, as it all looks the same to me unfortunately.

Thanks

[Alex Medved _ConfiForms_]

No... this is a ConfiForms TableView macro.

And is used to show the data from ConfiForms in an HTML table 

See https://wiki.vertuna.com/display/CONFIFORMS/Multiple+ways+to+show+your+form+data+in+Confluence+with+ConfiForms

If you are looking to customize the output of an export from admin UI then this is not possible. You have to create your own "view" over the ConfiForms form data