PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Merge multiple field entries into new field

  1. I need to create a form which has three fields, but when submissions are downloaded as a CSV, those three fields get merged into a fourth field for the purposes of printing them onto labels. For example, the list of submissions might look something like this:

    Name 1: First Person
    Name 2: Second Person
    Town: Townsville
    Label: <NAME1> and <NAME2> live in <TOWN>

    I hope that gives enough of an idea of what I'm trying to achieve. Is that possible with Gravity Forms and, if so, how do I do it? Or is is something that's only achievable via a spreadsheet formula, once the raw CSV has been exported?

    Thanks.

    Posted 11 years ago on Wednesday January 16, 2013 | Permalink
  2. You can use the gform_pre_submission_filter to combine all 3 fields into one field, then store that combined field in the entry. http://www.gravityhelp.com/documentation/page/Gform_pre_submission_filter

    We did something similar to that, here: http://www.gravityhelp.com/forums/topic/using-user-registration-dynamic-drop-downs-capture-one-value-from-multiple-list

    Posted 11 years ago on Wednesday January 16, 2013 | Permalink
  3. Hi Chris,

    Thanks for your help. I'm no PHP expert, but I'll give that a go next week (work needs signing off by client first) and see how far I get. I'll post another message here if I need to borrow any more of your brain! :o)

    Tim

    Posted 11 years ago on Wednesday January 16, 2013 | Permalink
  4. No problem. Let us know if you need more help.

    Posted 11 years ago on Wednesday January 16, 2013 | Permalink