PDF Conjurer Pushing Data

[jeffrey.j.obrien]

Hi,

I am using PDF Conjurer to output a report. One of my table columns has usernames. Each record could have multiple usernames on each line item. Whenever I have a record with more than 2 users, PDF conjurer pushes the user data down onto the next row. The result is my users are all misaligned with the record.

Does @vini_brito or anyone else know how I can resolve this?

Thanks
J

[vini_brito]

That’s possibly because the lists are flattened inside the plugin, when I get the chance to look into it with details I’ll let you know.
For now, try converting the list of texts into a single text, it will help you.

In the future I may place a yes/no field to change this behavior optionally (:

[jeffrey.j.obrien]

Any idea how I would do that? Is it a combination of options or do I need another funtion like Regex?

I tried all the options I could see but I still get the users across multiple lines:

Thanks,
Jeff

[vini_brito]

Use the “join with” operator right after making it a list of text.
I’ll be like this: Search for User’s name join with ,

(Join with comma)

@jeffrey.j.obrien

[jeffrey.j.obrien]

Hey Vini,

I couldn’t get that working. I tried a bunch of join with combinations:

1. I tried trying the search a bunch of ways:
   

   

2. But I always get the error:
   

   

Any help in solving this much appreciated. My app is:

Bubble Editor - Version6

The workflow is 8 - Upcoming step 16:

Thanks
Jeff

[vini_brito]

Create the error message again so I can inspect it, it’s currently empty.
I imagine that this will help: Place the “join with” not in the end result, which is a list of lists, but in each item’s list.
So each item will pass its list in a consolidated, “joint with”, manner.

[jeffrey.j.obrien]

Ok. The error is back in.

I also added a second column called Assigned Users 2 to pull the assigned user data from the repeating group.

[vini_brito]

You have more “names” rows because that’s the data you pass in.
Check into the debugger what’s being passed in that field when you get the extra names.
The list is just bigger.

[jeffrey.j.obrien]

There is 2 records - you’ll see in the sixth column body…

[vini_brito]

But how can there be two records if the field is type “text” and not “List of texts”?

[jeffrey.j.obrien]

The datbase object is a list of users. So one job could have multiple users assigned to it.

[vini_brito]

But you’re passing the field “User’s Full name”, that’s a single text field, so you’re passing a list of that.
If that list has 5 names, then you’ll get 5 items in the table.
Try the following:
Pass the “join with ,” value, which will become a single text, with the “add” operator to a custom state of the type “list of texts” in any element you want to in the page.
That way you’ll have all the names joined into a single text and then have that text become a list with only one item in it.

Pass that list with only one text item in it to the field “Seventh column body” in PDF Conjurer.

Let me know how it goes!

[jeffrey.j.obrien]

This is a tough one…

I added the state which is called “list of users” but it is a list of texts, to the pop-up element but I cannot get to the ADD operator. It’s not an option…

[jeffrey.j.obrien]

Actually. I reread your text and I think I did that wrong. But I still cannot get to the ADD operator.

[vini_brito]

Set that in the state first.
Element’s state (which is a list) add RG Upcoming… join with ,

It’ll look like this
Popup 8 - Upcoming w…'s List of Users add RG Upcoming… join with ,