ConfiForms MultiSelect into multiple rows

Question

Hi,

I have a form, which alows the entry of a multiselect field.
Something like: | Key | Value | Multi1, 2, 3 |

I would need this multiselect field in another tableView to be displayed as single rows.

Can someone help me out?

Davin Studer · Answer

Seriously! Um ... yeah, I guess that is way better. I totally forgot about that macro ... I way over engineered it.

Alex Medved _ConfiForms_ · Answer

Probably you can just use the ConfiForms TableView Merger macro and set the parameter to "flatten entries"

Davin Studer · Answer

After thinking about it a bit there is a way to show it as a table on a page. You can get the URL for the flattened CSV file from the method above. It would look like this ... https://{your server}/ajax/confiforms/export.action?t=flatten.csv&pageId={your page id}&fd={your form name}%3A{your page id ... again}&fields={field 1}%2C{field 2}%2C{field 3}%2C{field n+1}&filter= From there you could use a user macro that I wrote a couple of years ago to display the CSV as a table. The user macro code is below. Also there is and example screenshot of what it looks like. The top table is the TableView macro and the bottom table is the flattened CSV version of that table displayed via the user macro. CSV Table User Macro Code Macro Name: csv_table Macro Title: CSV Table Macro Body Processing: No macro body Template ## Developed by: Davin Studer ## Date created: 05/07/2014 ## @param CSVName:title=CSV File|type=string|required=false|desc=If the CSV is attached to a page use this field. ## @param Page:title=Page Title|type=confluence-content|required=false|desc=If not specified, the current page is used. ## @param CSVURL:title=CSV URL|type=string|required=false|desc=If the CSV is not attached to a page but is accessible via URL use this field. ## @param TopHeader:title=Top Header Row|type=boolean|required=false|default=false|desc=Check if the top row should be a header row? ########################################################################### ## These are used for getting around velocity issues when writing jQuery ## ########################################################################### #set($d = '$') #set($p = '#') #set($error = "") #if($paramCSVName && $paramCSVName != "" && $paramCSVURL && $paramCSVURL) #set($error = $error + "

Use either the CSV File field or the CSV URL field. Not both.

") #end ############################## ## Create a unique id value ## ############################## #set( $id=$action.dateFormatter.calendar.timeInMillis ) #if( $paramPage && $paramPage != "" ) ########################## ## Get the page manager ## ########################## #set( $containerManagerClass=$content.class.forName('com.atlassian.spring.container.ContainerManager') ) #set( $getInstanceMethod=$containerManagerClass.getDeclaredMethod('getInstance',null) ) #set( $containerManager=$getInstanceMethod.invoke(null,null) ) #set( $containerContext=$containerManager.containerContext ) #set( $pageManager=$containerContext.getComponent('pageManager') ) ########################## ## Find the page ## ########################## #set( $parts = $paramPage.split(":") ) #set( $i = 0 ) #set( $len = 0 ) #set( $key = "" ) #set( $name = "" ) ##Having trouble finding out the length/size of $parts ... brute force it #foreach( $part in $parts ) #set( $len = $len + 1 ) #end #if( $len == 1 ) #set( $key = $content.spaceKey ) #set( $name = $paramPage ) #else #foreach( $part in $parts ) #if( $i == 0 ) #set( $key = $part ) #set( $i = $i + 1 ) #else #set( $name = $part ) #end #end #end #set( $tempcontent = "" ) #if( $pageManager ) #set( $tempcontent = $pageManager.getPage($key, $name) ) #end #if( $tempcontent && $tempcontent != "" ) #set( $content = $tempcontent ) #else The page "$paramPage" was not found in this space. #set( $content = "" ) #end #end #set( $attachments = $attachmentManager.getLatestVersionsOfAttachments($content) ) ############################################################################ ## Could not find a method to sort the $attachments in Alphabetical order ## ## Must sort them myself ... bubble sort ## ############################################################################ #set( $size = $attachments.size() ) #foreach( $junk in $attachments ) #set( $count = -1 ) #foreach( $line in $attachments ) #set( $count = $count + 1 ) #if( $velocityCount < $size ) #if( $line.getTitle().compareToIgnoreCase($attachments.get($velocityCount).getTitle()) > 0 ) #set( $tmp = $attachments.get($velocityCount) ) #set( $junk = $attachments.set($velocityCount, $line) ) #set( $junk = $attachments.set($count, $tmp) ) #end #end #end #end #if($paramCSVURL && $paramCSVURL != "") #set($csvURL = $paramCSVURL) #else #set( $baseUrl = $action.getGlobalSettings().getBaseUrl() ) #foreach( $attachment in $attachments ) #if( $attachment.getTitle().toLowerCase() == $paramCSVName.toLowerCase() ) #set( $url = $attachment.getDownloadPathWithoutVersion() ) #end #end #set($csvURL = ${baseUrl} + ${url}) #end ######################################################################### ## This will only run on the macro properties dialog. It will add a ## ## dropdown to select a CSV file. ## ######################################################################### ######################################################################### ## End ## ######################################################################### ########################## ## Render the CSV table ## ########################## #if($error && $error != "") $error #else #if((${url} && ${url} != "") || ($paramCSVURL && $paramCSVURL != "")) #end

#end