PerfectForms Forums » Behaviors

Create comma separated list from all rows in a column (not a CSV file)

(2 posts)
  1. I'd like to take all the words shown in all the rows of a column, copy them over to a text input field, and separate them with commas. For example, a column with 4 rows, each row has a person's name. I want the text input to show John, Frank, Ed, Sam. I'm not looking to export the information to a CSV file, I just want it to appear in a text input field this way.

    I've been messing around with the Set Table Rows and Copy Fields commands, going to the first row, copying the row, and moving to the next row to repeat... but it just overwrites anything that was previously in the text input field, instead of making a list. Any suggestions?

    Posted 2 years ago #
  2. ajobling
    Member

    Sounds like you are ok with taking the data from the table row by row, so the issue is overwriting the data that already exists in the Text Input field.
    I suggest that you consider the logic that is as follows:

    Set Field 'Text Input' = 'Text Input' + comma + New Data from table

    That way the new data should be added to whatever is already in the Text Input object.

    Posted 2 years ago #

RSS feed for this topic

Reply

You must log in or register to post.

Contact

1917 Palomar Oaks Way
Suite 160
Carlsbad, CA 92008
866.900.8588

  picture  picture  picture  picture