Join with multiple fields

Hi there - anyone aware of a way to do a more complex joined with? I would like to do something like "Current Note’s Contributors First Name Last Name joined with ", ".


If I’m understanding you correctly, here’s the solution. You can create this by inputting the dynamic logic for the first name, then add a comma, then input the dynamic logic for the last name:

  • “Current Note’s Contributors First Name” , “Current Note’s Contributors Last Name”

Sorry I guess my explanation wasn’t very clear, there are multiple contributors per note. Example:

[first name] [last name] - 2 separate fields in the database
John Smith
Chris Jacobs
Carl Withers

I want to display it as a single line of text with commas in between like:
John Smith, Chris Jacobs, Carl Withers

Have a look at the Toolbox expression function.

1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.