How to split the data from the Input Table?

  • sheridanins
    Asked on February 19, 2020 at 11:09 AM

    I am filling a Microsoft Word template with the data from my form submissions, but whenever the data from an input table is being entered it is filling out as one block chain with just commas seperating the entries, like so;

    textbox_sample15,textbox_sample16,Adult,textbox_sample17,textbox_sample18,textbox_sample19,Adult,textbox_sample20,textbox_sample21,textbox_sample22,Adult,textbox_sample23,textbox_sample24,textbox_sample25,Adult,textbox_sample26,textbox_sample27,textbox_sample28,Adult,textbox_sample29,textbox_sample30,textbox_sample31,Adult,textbox_sample32,textbox_sample33,textbox_sample34,Adult,textbox_sample35,textbox_sample36,textbox_sample37,Adult,textbox_sample38

    Is there anyway that I can manipulate the data or even apply a format to it?

    Jotform Thread 2170482 Screenshot
  • Kevin Support Team Lead
    Replied on February 19, 2020 at 2:04 PM

    Unfortunately, the data is generated like that by the Input Table element, I'm afraid that there is no way to split the data from the form builder or through the settings. 

    You would need to use a function on your end to split the data, you may do this either on Word directly if there is a function or through the code you're using to create the document.