1T - CSV Creator List to Text

Need help Plugins
1

Hi everyone,

I am using the plugin 1T - CSV Creator (dynamic CSV file) and am trying to allow the user to export data from their repeating group of “defects”.

I have successfully been able to export all fields within the data type but am having issues with exporting fields of type “list”. When I export, the goal is to the list separated by a comma, for example:

csv setup:
Title | Tags

Goal:
Item 1 | 1.1, 1.2, 1.3
Item 2 | 2.1, 2.2, 2.3
Item 3 | 3.1, 3.2, 3.3

Current outcome:

Item 1 | 1.1
Item 2 | 1.2
Item 3 | 1.3

the tags (list) spills over the rows into other items.

The 2 current workflow inputs I have tried:

accessing from repeating group (as like all other workflow inputs):
image

Doing a search:
image
my database structure:

Under Data type Defect:
Tag = List of Tags

Under Data type Tag:
name = text

Any assistance would be much appreciated!

This is actually the LAST piece of the puzzle so I am very excited to finish this.

Please let me know if you require any further information or have any questions to be able to assist.

Thanks!

2

Hey @joelmleguier :wave:

Search for Defects:each item's tag's name or the above one with the repeating group, gives you a list of things, that’s why the plugin treats each thing in the list as separate rows. You should use format as text instead.

Simply, Search for Defects:format as text and in the content part, you will say This Defect's Tag:each item's name and the delimiter will be any unique delimiter (I used || below):
image

Format as text will return a single string though, then, you will split this string by the same unique delimiter to get the list back:
image

Above should give you something like you wish:
image

I hope this helps.

bdk_512x512 @Huseyin from Flusk | Discover the #1 Security and Monitoring Tool for Bubble

3

Absolute lifesaver @flusk, thank you very much!

1 Like