Hi Aaron,

In this case, it does look like JavaScript would probably be the easiest option.

When the form is submitted, we can use a script to iterate through the cells in the table, and check to see what each value is. If the value is "Work", we can find the row label (the specific action item) and the column label (the room). Then, we just need to concatenate these and write the phrase into a "Work Jobs" multi-line field. If the value is "Sundry_Debt," we can do the same thing, but write the resulting value into a "Sundry Debt Jobs" multi-line field.

I've included a JavaScript sample below, that should help you get started here. If you want to use it in your own form, you should replace #q4 with the ID for your table, #q7 with the ID for the Work Jobs multi-line field, and #q8 with the ID for the Sundry Debt Jobs multi-line field. I should also note that this script assumes the cells are all single line fields; if you are using a different field type, you'll need to update the script accordingly.

$(document).ready(function() {

  //Compile Job Card when the form is submitted
  $('.Submit').click(function(){
    
    //iterate through the cells
    $('#q4 tr td input').each(function() {
      var phrase = "";
      
      //handle "Work" items
      if ($(this).val() == "Work"){
        
        //get the action
          var WorkAction = $(this).closest('tr').find('td.col0').text();
        phrase += WorkAction + " in ";
        
          //get the room
        var WorkRoom = $(this).closest('td').find('.cf-col-label').text();
        console.log(WorkRoom);
        phrase += WorkRoom + ". ";
        
          //add the list to the hidden text box
        $('#q7 textarea').val($('#q7 textarea').val() + phrase);
      }
      
      //Handle "Sundry_Debt" items
      else if ($(this).val() == "Sundry_Debt"){
        
        //get the action
          var SundryAction = $(this).closest('tr').find('td.col0').text();
        phrase += SundryAction + " in ";
      
          //get the room
        var SundryRoom = $(this).closest('td').find('.cf-col-label').text();
        phrase += SundryRoom + ". ";
      
        //add the list to the hidden text box
        $('#q8 textarea').val($('#q8 textarea').val() + phrase);
        }
    });
  });
});

I hope this helps!