How to define delimiter/separator on Smart Multi-Select field in ConfiForms

[Daniel Schimanek]

Hello,

I’ve been following this great tutorial to create several multi select fields with a lot of entries from a spreadsheet: https://community.atlassian.com/t5/Confluence-questions/How-to-generate-a-confiforms-macro-multi-select-list-from-a-csv/qaq-p/1948555

So I do have one main confiforms form that uses multiple Smart Multi-Select fields referencing to further confiforms (as decribed above).

The referencing and multiple selectio works great!

Now I need to export the main confiforms database as csv with a specific delimiter “|,|” for the entries of the Smart Multi-Select fields. Unfortunately I was not able to set them up or find another workaround, although trying hard using virtual functions etc. 

At the “normal” multi-select field I am able to set the delimiter/separator as desired.

 Is there any solution to this issue?

Thanks, Daniel

[Alex Medved _ConfiForms_]

Hi

Welcome to this community @Daniel Schimanek  

You can customize your export via https://wiki.vertuna.com/display/CONFIFORMS/Data+Export+tricks+and+hints#DataExporttricksandhints-CustomisingexportsviaConfiFormsViews

And you can transform the values as you like, I believe something like this should be possible (not sure how the smart field itself is named, but let's assume it is called "smartfield")

smartfield.transform(GR1.append(|).prepend(|))

Alex

[Daniel Schimanek]

Hi @Alex Medved _ConfiForms_ ,

thanks so much for your quick reply!

Your solution works fine, except that I do not get a "," between the two "|" but a "space".

Here's a screenshot from the xls export:

Any suggestion how to change the actual delimiter to ","?

Thanks, Daniel