async function getDynamicJobTable(p) {
  //if one exists, render a dynamic table
  let params = p || '';
  let m;
  let previewEnabled = false;
  let searchTag = '';
  let output = '';
  if(p.includes('{{job}}')) {
    searchTag = '{{job}}';
  } else if (p.includes('{{invoice}}')) {
    searchTag = '{{invoice}}';
  }
  
  if(searchTag=='') {
    return params; 
  }

  const regex = new RegExp(searchTag, 'gm');
  while ((m = regex.exec(params)) !== null) {
    // This is necessary to avoid infinite loops with zero-width matches
    if (m.index === regex.lastIndex) {
        regex.lastIndex++;
    }
    
    if(job != null) {
      let data = {
        rows:job
      };
      let searchable = false;
      output = '<div style="width:100%;overflow-x:scroll;position:relative;"><form name="jobForm" id="jobForm" autocomplete="off">';
      for (let row = 0;row<data.rows.length;row++) {
        if(row==0 || data.rows[row].hasOwnProperty('newBlock') && data.rows[row].newBlock == true) {
          if(row>0) {
            output +='</table>';
            if(data.rows[row].hasOwnProperty('pageBreak') && data.rows[row].pageBreak == true) {
              output +='<div style="page-break-after:always;page-break-inside:avoid;display:block;"></div>';
            }
          }
          output += '<table class="table table-borderless jobtable">';
        }

        if(data.rows[row].hasOwnProperty('titles') && data.rows[row].titles != null ) {
          if(data.rows[row].hasOwnProperty('hideTitlesOnSearch') && data.rows[row].hideTitlesOnSearch == true) {
            output += '<tr class="hideTitlesOnSearch">';
          } else {
            output += '<tr>';
          }
          for(let t=0;t<data.rows[row].titles.length;t++) {
            if(data.rows[row].hasOwnProperty('cols') && data.rows[row].cols[t].hasOwnProperty('fieldType') && data.rows[row].cols[t].fieldType!='hidden') {
              let align = 'left';
              if(data.rows[row].hasOwnProperty('cols') && data.rows[row].cols !=null) {
                //get alignment from cols
                if(data.rows[row].cols[t].hasOwnProperty('align') && data.rows[row].cols[t].align !=null) {
                  align = data.rows[row].cols[t].align;
                } else if(data.rows[row].cols[t].dataType == 'list') {
                  align = 'left';
                } else if(data.rows[row].cols[t].dataType == 'date') {
                  align = 'left';
                } else if(data.rows[row].cols[t].dataType == 'text') {
                  align = 'left';
                } else if(data.rows[row].cols[t].dataType == 'boolean') {
                  align = 'center';
                } else if(data.rows[row].cols[t].dataType == 'decimal') {
                  align = 'right';
                } else if(data.rows[row].cols[t].dataType == 'integer') {
                  align = 'right';
                }
              }

              output += '<td nowrap style="text-align:' + align + '"><b><i>' + data.rows[row].titles[t] + '</i></b></td>';
            } else {
              output += '<td style="display:none;"></td>';
            }
          }
          output +='</tr>';
        }

        if(!data.rows[row].hasOwnProperty('cols') || data.rows[row].cols == null) {
          data.rows[row].cols = [{"ordinal":1,"id":"dummy","fieldType":"display","dataType":"text","value":""}];
        }

        let colCount = 0;
        if(data.rows[row].hasOwnProperty('cols') && data.rows[row].cols != null) {
          for(let col = 0;col<data.rows[row].cols.length;col++) {
            if(data.rows[row].cols[col].dataType != 'hidden') {
              colCount++;
            }
          }
        } else {
          alert('Data Error - No Columns in Row');
        }

        if(data.rows[row].hasOwnProperty('heading') && data.rows[row].heading != null) {
          if(data.rows[row].hasOwnProperty('hideHeadingOnSearch') && data.rows[row].hideHeadingOnSearch == true) {
            output += '<tr class="hideHeadingOnSearch">';
          } else {
            output += '<tr>';
          }
          output += '<th colspan="' + colCount.toString() + '" style="font-size:x-large">' + data.rows[row].heading + '</th></tr>';
        }

        if(data.rows[row].hasOwnProperty('subHeading') && data.rows[row].subHeading != null) {
          if(data.rows[row].hasOwnProperty('hideHeadingOnSearch') && data.rows[row].hideHeadingOnSearch == true) {
            output += '<tr class="hideHeadingOnSearch">';
          } else {
            output += '<tr>';
          }
          output += '<th colspan="' + colCount.toString() + '" style="font-size:medium">' + data.rows[row].subHeading + '</th></tr>';
        }

        output += '<tr id="jobRow-' + row.toString() + '"';
        //add filter tag 
        let filter = '';
        for(let col = 0;col<data.rows[row].cols.length;col++) {
          if(data.rows[row].cols[col].hasOwnProperty('searchable') && data.rows[row].cols[col].searchable==true) {
            filter += data.rows[row].cols[col].value + '|';
          }
        }
        let classStr = "";
        if(filter!='') {
          classStr = 'searchRow ';
          output += ' data-search="' + filter + '"';
          searchable = true; 
        }
        
        if(data.rows[row].hasOwnProperty('hideRowOnSearch') && data.rows[row].hideRowOnSearch) {
          classStr += 'hideRowOnSearch ';
        }

        if(data.rows[row].hasOwnProperty('previewField') && data.rows[row].previewField > '') {
          previewEnabled = true;
          classStr += 'previewRow ';
          output += ' data-previewfield="' + data.rows[row].previewField + '"';
        } else {
          classStr += 'hideRowOnPreview ';
        }
        
        if(classStr!="") {
          output += ' class="' + classStr + '" ';
        }

        output += '>';
        for(let col = 0;col<data.rows[row].cols.length;col++) {
          let hidden = data.rows[row].cols[col].fieldType == 'hidden';
          let width = "";
          let align = "";
          if(data.rows[row].cols[col].dataType == 'decimal') {
            align = "text-align:right";
          } else if(data.rows[row].cols[col].dataType == 'integer' || data.rows[row].cols[col].dataType == 'boolean') {
            align = "text-align:center; vertical-align:middle;";
          } 
          if(data.rows[row].cols[col].hasOwnProperty('width') && data.rows[row].cols[col].width != null) {
            width = "width:" + data.rows[row].cols[col].width + ';';
          }
          if(data.rows[row].cols[col].hasOwnProperty('align') && data.rows[row].cols[col].align != null) {
            align = "text-align:" + data.rows[row].cols[col].align + ';';
          }

          if(data.rows[row].cols[col].hasOwnProperty('keyField') && data.rows[row].cols[col].keyField == true) {
            output += '<td ';
            if(hidden) {
              output += 'style="display:none;" ';
            } else if(width!='' || align!='') {
              output += 'style="vertical-align:middle;' + width + align + '" ';
            }
            output += 'data-key-' + row.toString() + '="' + data.rows[row].cols[col].value + '">';
          } else {
            if(hidden) {
              output += '<td style="display:none;">'; 
            } else if(width!='' || align!='') {
              output += '<td style="vertical-align:middle;' + width + align + '">';
            } else {
              output += '<td style="vertical-align:middle;">';
            }
          }
          let id = 'field_' + data.rows[row].cols[col].id + '(' + row.toString() + ')' ;
          switch(data.rows[row].cols[col].fieldType) {
            case 'hidden': 
              output += '<input type="hidden" name="' + id + '" id="' + id + '" style="display:none;" class="form-control" value="' + data.rows[row].cols[col].value + '"/>';
              break;
            case 'markdown': 
              output += marked.parse(data.rows[row].cols[col].value);
              break;
            case 'display':
                if(data.rows[row].cols[col].dataType == 'hidden') {
                  output += '<input type="hidden" name="' + id + '" id="' + id + '" style="display:none;" class="form-control" value="' + data.rows[row].cols[col].value + '"/>';
                } else {
                  if(data.rows[row].cols[col].value.includes('{{') && data.rows[row].cols[col].value.includes('}}')) {
                    let align="";
                    if(data.rows[row].cols[col].dataType=='decimal') {
                      align = 'style="text-align:right;" ';
                    } else if(data.rows[row].cols[col].dataType == 'integer') {
                      align = 'style="text-align:center;" ';
                    }
                    output += '<input type="text" ' + align + 'name="' + id + '" id="' + id + '" disabled class="form-control" value="' + data.rows[row].cols[col].value + '"/>';
                  } else {
                    if(data.rows[row].cols[col].dataType=='decimal') {
                      let precision = 2;
                      if(data.rows[row].cols[col].hasOwnProperty('precision')) {
                        precision = parseInt(data.rows[row].cols[col].precision);
                      }
                      output += '<span id="' + id + '">' + parseFloat(data.rows[row].cols[col].value).toFixed(precision) + '</span>';
                    } else {
                      output += '<span id="' + id + '">' + data.rows[row].cols[col].value + '</span>';
                    }
                  }
                }
              break;
            case 'input':
              let disabled ='';
              if(data.rows[row].cols[col].hasOwnProperty('disabled') && data.rows[row].cols[col].disabled==true) {
                disabled=' disabled';
              }
              
              if(data.rows[row].cols[col].dataType=='list') {
                output += '<select name="' + id + '" id="' + id + '" class="form-select job_list" onblur="recalculateJob();" onchange="recalculateJob();">';
                if(data.rows[row].cols[col].hasOwnProperty('data')) {
                  let list = data.rows[row].cols[col].data.split(',');
                  for(let l=0;l<list.length;l++) {
                    var listItems = list[l].split('|');
                    var dataItem = 'value="' + listItems[0] + '"';
                    if(listItems.length>1) {
                      dataItem += ' data-change="' + listItems.slice(1).join('|') + '"';
                    }
                    output += '<option' + (data.rows[row].cols[col].value.split('|')[0] == listItems[0] ? ' selected ' : ' ') + dataItem + '>' + listItems[0] + '</option>';
                  }
                }
                output += '</select>';
              } else if(data.rows[row].cols[col].dataType=='date') {
                let minDate = '';
                if(data.rows[row].cols[col].hasOwnProperty('data')) {
                  let minMax = data.rows[row].cols[col].data.split('|');
                  minDate = ' min="' + minMax[0] + '"';
                  if(minMax.length>1) {
                    minDate += ' max="' + minMax[1] + '"';
                  }
                }
                output += '<input type="date"' + disabled + minDate + ' autocomplete="off" name="' + id + '" id="' + id + '" class="form-control job_date" value="' + data.rows[row].cols[col].value + '" onblur = "recalculateJob();"/>';
              } else if(data.rows[row].cols[col].dataType=='text') {
                let maxLength = '';
                if(data.rows[row].cols[col].hasOwnProperty('maxLength')) {
                  maxLength=' maxlength="' + data.rows[row].cols[col].maxLength + '"';
                }
                output += '<input type="text"' + disabled + maxLength + ' autocomplete="off" name="' + id + '" id="' + id + '" class="form-control job_text" value="' + data.rows[row].cols[col].value + '" onblur = "recalculateJob();"/>';
              } else if(data.rows[row].cols[col].dataType=='integer') {
                output += '<input type="number" placeholder="0"' + disabled + ' autocomplete="off" name="' + id + '" id="' + id + '" class="form-control job_integer" value="' + data.rows[row].cols[col].value + '" onfocus="this.select();" onblur="reFormatFixedDp(this,0);recalculateJob();" />';
              } else if(data.rows[row].cols[col].dataType=='decimal') {
                let precision = 2;
                if(data.rows[row].cols[col].hasOwnProperty('precision')) {
                  precision = parseInt(data.rows[row].cols[col].precision);
                }
                if(precision>0) {
                  let v = data.rows[row].cols[col].value;
                  if(v!='') {
                    v = parseFloat(v).toFixed(precision);
                  }
                  output += '<input type="number"' + disabled + ' placeholder="0.' + '0'.repeat(precision) + '" pattern="^\d*(\.\d{0,' + precision.toString() + '})?$" autocomplete="off" name="' + id + '" id="' + id + '" class="form-control job_decimal" value="' + v + '" onfocus="this.select();" onblur="reFormatFixedDp(this,' + precision.toString() + ');recalculateJob();" />';
                } else {
                  output += '<input type="number" placeholder="0"' + disabled + ' autocomplete="off" name="' + id + '" id="' + id + '"  class="form-control job_decimal" value="' + data.rows[row].cols[col].value + '" onfocus="this.select();" onblur="reFormatFixedDp(this,0);recalculateJob();" />';
                }
              } else if(data.rows[row].cols[col].dataType=='boolean') {
                output += '<input type="checkbox" name="' + id + '" id="' + id + '" autocomplete="off" class="form-check-input" ' + (data.rows[row].cols[col].value==true ? 'checked' : '') + ' onclick="recalculateJob();"/>';
              }
              break;
          }
          
          output += '</td>';
        }
        output +='</tr>';
      }
      
      output += '</table></form></div>';
      
      output = output.replaceAll("icon:star","<i class='bi bi-star-fill'></i>");
      if(searchable==true) { 
        let search = '<div style="width:100%;position:relative;margin-bottom:5px;display:flex;" id="searchBar" class="input-group"><span class="input-group-text" id="basic-addon1"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-search" viewBox="0 0 16 16">';
        search += '<path d="M11.742 10.344a6.5 6.5 0 1 0-1.397 1.398h-.001q.044.06.098.115l3.85 3.85a1 1 0 0 0 1.415-1.414l-3.85-3.85a1 1 0 0 0-.115-.1zM12 6.5a5.5 5.5 0 1 1-11 0 5.5 5.5 0 0 1 11 0"></path>';
        search += '</svg></span>';
        search += '<input type="text" class="form-control" id="searchFilter" placeholder="filter values"/>';
        search += '</div>';
        output = search + output;
      }
      
      if(jobrecord!=null) {
        if(jobrecord.hasOwnProperty('ShowButtons') && jobrecord.ShowButtons.S == "1") {
          output += '<button class="btn btn-success no-print" onclick="getJobAsCSV(\'tab\')">Copy to Clipboard</button> ';
          output += '<button class="btn btn-success no-print" onclick="getJobAsCSV(\'csv\')">Download as CSV</button>';
        }
      }
      setTimeout(function(){refreshStoredData()},0);
      setTimeout(function(){
          $("#searchFilter").on('keyup', function () {
              let value = $(this).val().toLowerCase();
              if(value!='') {
                $(".hideRowOnSearch").hide();
                $(".hideHeadingOnSearch").hide();
                $(".hideTitlesOnSearch").hide();
              } else {
                $(".hideRowOnSearch").show();
                $(".hideHeadingOnSearch").show();
                $(".hideTitlesOnSearch").show();
              }

              $(".searchRow").each(function () {
                  if ($(this).attr('data-search').toLowerCase().search(value) > -1) {
                      $(this).show();
                  } else {
                      $(this).hide();
                  }
              });

              showAllJobTables();
              hideTablesWithHiddenRows();

          });
      },0);
      

      if(jobType == 'receipt') {
        setTimeout(function(){
          d_id('formPreview').style.display = 'none';
          d_id('formSaveProgress').style.display = 'none';
          d_id('formComplete').style.display = 'none';
          d_id('formPayWithCard').style.display = 'none';
        },500);
      } else if(jobType == 'invoice') {
        setTimeout(function(){
          d_id('formPreview').style.display = 'none';
          d_id('formSaveProgress').style.display = 'none';
          d_id('formComplete').style.display = 'none';
          d_id('formPayWithCard').style.display = 'inline-block';
        },500);
      } else {
        if(jobrecord) {
          setTimeout(function(){
            if(previewEnabled) {
              d_id('formPreview').style.display = 'inline-block'
              d_id('formComplete').style.display = 'none';
            } else {
              d_id('formPreview').style.display = 'none'
              d_id('formComplete').style.display = 'inline-block';
            }
            d_id('formSaveProgress').style.display = 'inline-block';
          },500);
        } else {
          setTimeout(function(){
            d_id('formPreview').style.display = 'none';
            d_id('formSaveProgress').style.display = 'none';
            d_id('formComplete').style.display = 'none';
          },500);
      }
        setTimeout(function(){
          d_id('formPayWithCard').style.display = 'none';
        },500);
      }
    } else {
      if(jobtable!='') {
        output = jobtable;   
      } else {
        if(searchTag=='{{job}}') {
          output = '<b>Form not found or already completed</b>';  
        } else {
          output = '<b>Invoice not found</b>';  
        }
      }
      //kill the complete button
      setTimeout(function(){
        d_id('formSaveProgress').style.display = 'none';
        d_id('formPreview').style.display = 'none';
        d_id('formComplete').style.display = 'none';
        d_id('formPayWithCard').style.display = 'none';
      },500);
    }

    params = params.replace(m[0],output);
  }

  return params;
}


function refreshStoredData() {
  if(jobsaved) {
    for(let i=0;i<jobsaved.rows.length;i++) {
      let key = jobsaved.rows[i].key;
      for(let n=0;n<jobsaved.rows[i].cols.length;n++) {
        let ordinal = jobsaved.rows[i].ordinal;
        if(d_id('field_' + jobsaved.rows[i].cols[n].id + '(' +  (ordinal).toFixed(0) + ')').type == 'checkbox') {
          d_id('field_' + jobsaved.rows[i].cols[n].id + '(' +  (ordinal).toFixed(0) + ')').checked = jobsaved.rows[i].cols[n].value;        
        } else {
          d_id('field_' + jobsaved.rows[i].cols[n].id + '(' +  (ordinal).toFixed(0) + ')').value = jobsaved.rows[i].cols[n].value;        
        }
      }
    }
  }
  setTimeout(function(){recalculateJob()},0);
}



function recalculateJob() {
    let data = {rows:job};
    
    for (let row = 0;row<data.rows.length;row++) {
      for(let col = 0;col<data.rows[row].cols.length;col++) {
        let id = 'field_' + data.rows[row].cols[col].id + '(' + row.toString() + ')' ;
        switch(data.rows[row].cols[col].fieldType) {
          case 'input':
            if(data.rows[row].cols[col].dataType=='boolean') {
              data.rows[row].cols[col].value = d_id(id).checked;
            } else if(data.rows[row].cols[col].dataType == 'list') {
              if(d_id(id).selectedOptions[0].getAttribute('data-change') != null) {
                var valArray = d_id(id).selectedOptions[0].getAttribute('data-change').split('|');
                for(var v=0;v<valArray.length;v++) {
                  var vals = valArray[v].split('=');
                  for(let n = 0;n<data.rows[row].cols.length;n++) {
                    if(data.rows[row].cols[n].id == vals[0]) {
                      data.rows[row].cols[n].value = vals[1];
                    }
                  }
                }
              }
              data.rows[row].cols[col].value = d_id(id).value;
            } else {
              data.rows[row].cols[col].value = d_id(id).value;
            }
            break;
        }
      }
    }


    for (let row = 0;row<data.rows.length;row++) {
      data.rows[row].valid=true;
      for(let col = 0;col<data.rows[row].cols.length;col++) {
        let id = 'field_' + data.rows[row].cols[col].id + '(' + row.toString() + ')' ;
        switch(data.rows[row].cols[col].fieldType) {
          case 'hidden':
          case 'display':
            if(data.rows[row].cols[col].value.includes('{{') && data.rows[row].cols[col].value.includes('}}')) {
              //we have a calculation
              let evalString = data.rows[row].cols[col].value;
              
              //loop through the columns and replace any variables with their values
              for(let evalCol = 0;evalCol<data.rows[row].cols.length;evalCol++){
                if(evalCol<col) {
                  let evalColVal = data.rows[row].cols[evalCol].value.toString();
                  //if the destination is numeric, make sure to clense any inputs
                  if(data.rows[row].cols[col].dataType == 'integer' || data.rows[row].cols[col].dataType == 'decimal') {
                    evalColVal = evalColVal.replace(/[^0-9.]/g,'');
                  }
                  
                  if(evalColVal == 'false' || evalColVal == '') {
                    evalColVal = '0';
                  } else if(evalColVal == 'true') {
                    evalColVal = '1';
                  }
                  evalString=evalString.replace('{{'+data.rows[row].cols[evalCol].id+'}}',evalColVal);
                }
              }
              //look for sum
              if(evalString.includes('{{SUM:')) {
                let sumValue = 0.0;
                let sumField = evalString.replace('{{SUM:','').replace('}}','');
                let precision = 2;
                if(data.rows[row].cols[col].hasOwnProperty('precision')) {
                  precision = parseFloat(data.rows[row].cols[col].precision);
                }
                //now loop through all rows
                for(let allRows=0;allRows<data.rows.length;allRows++) {
                  for(let allCols=0;allCols<data.rows[allRows].cols.length;allCols++) {
                    if(data.rows[allRows].cols[allCols].id.toLowerCase() == sumField.toLowerCase()) {
                      sumValue += parseFloat(d_id('field_' + data.rows[allRows].cols[allCols].id + '(' + allRows.toString() + ')').value.replace(/[^0-9.]/g,''));
                    }
                  }
                }
                //evalString=evalString.replace('{{SUM:' + sumField + '}}',sumValue.toFixed(precision));
                //d_id(id).value=parseFloat(eval(evalString).toString()).toFixed(precision);
                d_id(id).value=sumValue.toFixed(precision);
              } else {
                d_id(id).value=eval(evalString).toString();
              }
  
              //now set the current validation state for the cell based on the rule
              if(data.rows[row].cols[col].hasOwnProperty('validation') && data.rows[row].cols[col].validation !=null) {
                if(eval('(' + evalString + ')' + data.rows[row].cols[col].validation)) {
                  data.rows[row].cols[col].valid=true;
                } else {
                  data.rows[row].cols[col].valid=false;
                  data.rows[row].valid=false;
                }
              }
            } else {
              let id = 'field_' + data.rows[row].cols[col].id + '(' + row.toString() + ')' ;
              if(data.rows[row].cols[col].fieldType =='display') {
                if(data.rows[row].cols[col].value.replaceAll('icon:star','<i class="bi bi-star-fill"></i>') != d_id(id).innerHTML) {
                  d_id(id).innerHTML = data.rows[row].cols[col].value.replaceAll('icon:star','<i class="bi bi-star-fill"></i>');
                }
              } else {
                if(data.rows[row].cols[col].value != d_id(id).value) {
                  d_id(id).value = data.rows[row].cols[col].value;
                }
              }
            }
            break;
          case 'input':
              if(data.rows[row].cols[col].hasOwnProperty('validation') && data.rows[row].cols[col].validation !=null) {
                if(data.rows[row].cols[col].dataType=='integer' || data.rows[row].cols[col].dataType=='decimal' || data.rows[row].cols[col].dataType=='boolean') {
                  let val = data.rows[row].cols[col].value.toString();
                  if(val == 'false' || val == '') {
                    val = '0';
                  } else if(val == 'true') {
                    val = '1';
                  }
                  val = val.replace(/[^0-9.]/g,'');
                  if(eval('(' + val + ')' + data.rows[row].cols[col].validation)) {
                    data.rows[row].cols[col].valid=true;
                  } else {
                    data.rows[row].cols[col].valid=false;
                    data.rows[row].valid=false;
                  }
                } else if(data.rows[row].cols[col].dataType=='text') {
                  //test regex in validation
                  if(RegExp(data.rows[row].cols[col].validation, 'g').test(data.rows[row].cols[col].value)) {
                    data.rows[row].cols[col].valid=true;
                  } else {
                    data.rows[row].cols[col].valid=false;
                    data.rows[row].valid=false;
                  }
                } else if(data.rows[row].cols[col].dataType=='date') {
                  //test regex in validation
                  if(RegExp(data.rows[row].cols[col].validation, 'g').test(data.rows[row].cols[col].value)) {
                    data.rows[row].cols[col].valid=true;
                  } else {
                    data.rows[row].cols[col].valid=false;
                    data.rows[row].valid=false;
                  }
                }
              }
            break;
        }
      }
    }
    let valid=true;
    for (let row = 0;row<data.rows.length;row++) {
      if(data.rows[row].valid==false) {
        d_id("jobRow-" + row.toString()).style.border="2px solid red";
        valid=false;
      } else {
        d_id("jobRow-" + row.toString()).style.border="";
      }
    }
    
    if(valid==true && jobrecord!=null) {
      if(jobrecord.hasOwnProperty('MinRequiredFields') && jobrecord.MinRequiredFields!=null) {
        if(jobrecord.MinRequiredFields.hasOwnProperty('S') && (jobrecord.MinRequiredFields.S || '') !='') {
          let minRequiredFields = jobrecord.MinRequiredFields.S.split(',');
          valid = false;
          for(let f=0;f<minRequiredFields.length;f++) {
            for (let row = 0;row<data.rows.length;row++) {
              if(data.rows[row].hasOwnProperty('cols')) {
                for(let col=0;col<data.rows[row].cols.length;col++) {
                  if(data.rows[row].cols[col].id.toLowerCase()==minRequiredFields[f].toLowerCase()) {
                    
                    switch(data.rows[row].cols[col].dataType) {
                      case 'integer':
                      case 'decimal':
                        if(data.rows[row].cols[col].value!='' && parseFloat(data.rows[row].cols[col].value)>0) {
                          valid = true; 
                        }
                        break;
                      default:
                        if(data.rows[row].cols[col].value!='') {
                          valid = true; 
                        }
                    }
                  }
                }
              }
            }
          }    
        }
      }
    }
    
    if(valid) {
      d_id('formComplete').disabled = '';
      d_id('formSaveProgress').disabled = '';
      d_id('formPreview').disabled = '';
    } else {
      d_id('formComplete').disabled = 'disabled';
      d_id('formSaveProgress').disabled = 'disabled';
      d_id('formPreview').disabled = 'disabled';
    }

    job = data.rows;
}


async function getJobAsCSV(csvortab) {
    let delim = '\t';
    if(csvortab == 'csv') {
      delim = ',';
    }

    let csv = '';
    let data = {rows:job};
    for (let r= 0;r<data.rows.length;r++) {
      let line ='';

      if(data.rows[r].hasOwnProperty('titles') && data.rows[r].titles != null) {
        if(data.rows[r].hasOwnProperty('hideTitlesOnExport') && data.rows[r].hideTitlesOnExport == true) {
          //don't output the line        
        } else {
          for(let t=0;t<data.rows[r].titles.length;t++) {
            //if(data.rows[r].titles[t] != '') {
              line += data.rows[r].titles[t] + delim;
            //}
          }
          csv += line.substr(0,line.length-1) + '\r\n';
          line ='';      
        }
      }

      if(data.rows[r].hasOwnProperty('hideRowOnExport') && data.rows[r].hideRowOnExport == true) {
        //don't output the line        
      } else {
        for(let col=0;col<data.rows[r].cols.length;col++) {
            if(data.rows[r].cols[col].value.toString().includes('{{') && data.rows[r].cols[col].value.toString().includes('}}')) {
              //we have a calculation
              let evalString = data.rows[r].cols[col].value;
              //loop through the columns and replace any variables with their values
              for(let evalCol = 0;evalCol<data.rows[r].cols.length;evalCol++){
                if(evalCol<col) {
                  let evalColVal = data.rows[r].cols[evalCol].value.toString();
                  if(evalColVal == 'false' || evalColVal == '') {
                    evalColVal = '0';
                  } else if(evalColVal == 'true') {
                    evalColVal = '1';
                  }
                  evalString=evalString.replace('{{'+data.rows[r].cols[evalCol].id+'}}',evalColVal.replace(/[^0-9.]/g,''));
                }
              }
              line += '"' + eval(evalString).toString().replace('"','""') + '"' + delim;
            } else {
              switch (data.rows[r].cols[col].dataType) {
                case 'text':
                  line += '"' + data.rows[r].cols[col].value.replace('"','""') + '"' + delim;
                  break;
                case 'date':
                  line += '"' + data.rows[r].cols[col].value.replace('"','""') + '"' + delim;
                  break;
                case 'boolean':
                  line += data.rows[r].cols[col].value == true ? '"X"' + delim : '""' + delim;
                  break;
                case 'integer':
                  line += data.rows[r].cols[col].value + delim;
                  break;
                case 'decimal':
                  line += data.rows[r].cols[col].value + delim;
                  break;
              }
            }
        }
        csv += line.substr(0,line.length-1) + '\r\n';
      }    
    }
    
    if(csvortab == 'tab') {
      try {
        await navigator.clipboard.writeText(csv);
        console.log('Content copied to clipboard');
      } catch (err) {
        console.error('Failed to copy: ', err);
      }
    } else {
      //download file as csv
      d_id('textDownloadCSV').value = btoa(encodeURI(csv)); 
      document.downloadFormCSV.submit();
    }

}


function processJob(includeOrdinal) {
  
    let data = {rows:job};
    let output = {
      "rows":[]
    };
    if(jobrecord) {
      output.reference = jobrecord.Reference.S;
      output.id = jobrecord.JobID.S;
      if(jobrecord.hasOwnProperty('Tag')) {
        output.tag = jobrecord.Tag.S;
      } else { 
        output.tag = '';
      }
      
    }
    
    for (let r= 0;r<data.rows.length;r++) {
      let row = {
        "cols":[]
      };
      if(includeOrdinal) {
        row.ordinal = r;
      }
      row.key = '';
      row.keyName = '';
      for(let col=0;col<data.rows[r].cols.length;col++) {
        if(data.rows[r].cols[col].hasOwnProperty('keyField') && data.rows[r].cols[col].keyField==true) {        
          row.key=data.rows[r].cols[col].value;
          row.keyName=data.rows[r].cols[col].id;
        } 
        if(data.rows[r].cols[col].fieldType=='input') {
          if(data.rows[r].cols[col].dataType == 'boolean') {
            let val = document.getElementById('field_' + data.rows[r].cols[col].id + '(' + r.toString() + ')').checked;
            row.cols.push({
              "id":data.rows[r].cols[col].id,
              "value":val});
          } else if(data.rows[r].cols[col].dataType == 'decimal') {
            let val = document.getElementById('field_' + data.rows[r].cols[col].id + '(' + r.toString() + ')').value;
            let precision = 2;
            if(data.rows[r].cols[col].hasOwnProperty('precision')) {
              precision = parseInt(data.rows[r].cols[col].precision);
            }
            row.cols.push({
              "id":data.rows[r].cols[col].id,
              "value":(val == '' ? '' : parseFloat(val).toFixed(precision))});
          } else {
            let val = document.getElementById('field_' + data.rows[r].cols[col].id + '(' + r.toString() + ')').value;
            row.cols.push({
              "id":data.rows[r].cols[col].id,
              "value":val});
          }            
        }
      }    
      if(row.cols.length>0) {
        output.rows.push(row);
      }
    }  
    return JSON.stringify(output,null,2);
}

var freeze = '';
var freezeArray = [];
function previewJob() {

    if(d_id('formPreview').innerHTML=='Edit') {
      d_id('formPreview').innerHTML='Preview &gt;';
      d_id('formPreview').setAttribute("class","btn btn-primary");
      d_id('searchBar').style.display='flex';

      document.getElementById('jobForm').innerHTML = freeze;
      let controls = document.getElementById('jobForm').querySelectorAll(".form-control,.form-select");
  
      for(let i=0; i<controls.length;i++) {
        for(let n=0;n<freezeArray.length;n++) {
          if(freezeArray[n].name == controls[i].name) {
            controls[i].value = freezeArray[n].value;
          }
        }
      }

      d_id('formComplete').style.display = 'none';
      d_id('formSaveProgress').style.display = 'inline-block';
    } else {
      d_id('formPreview').innerHTML='Edit';
      d_id('formPreview').setAttribute("class","btn btn-secondary");
      d_id('formComplete').style.display = 'inline-block';
      d_id('formSaveProgress').style.display = 'none';
      d_id('searchBar').style.display='none';
  
      freeze = document.getElementById('jobForm').innerHTML;
      
      //now gather all the input values.
      let controls = document.getElementById('jobForm').querySelectorAll(".form-control,.form-select");
      freezeArray = [];
      
      for(let i=0; i<controls.length;i++) {
        freezeArray.push({'name':controls[i].name,'value':controls[i].value});
      }
    
      $(".hideRowOnPreview").hide();
      $(".hideHeadingOnSearch").hide();
      $(".hideTitlesOnSearch").hide();
      $(".previewRow").hide();
  
      $(".previewRow").each(function () {
        //get the name if the preview field
        let previewField = this.getAttribute('data-previewfield');
        
        let controlCollection = this.querySelectorAll(".form-control,.form-select");
        let flagShow = false;
        for(let i=0;i<controlCollection.length;i++) {
          let id = controlCollection[i].name;
          
          controlCollection[i].disabled = 'disabled';
          if(id.startsWith('field_' + previewField + '(')) {
            let value = controlCollection[i].value;          
            if(parseFloat(value)>0) {
              flagShow = true;
            }
          }
          
          controlCollection[i].disabled = 'disabled';
        }
        
        if(flagShow==true) {
          $(this).show();
        } else {
          $(this).hide();
        }
      });
  
    hideTablesWithHiddenRows();
    }
}

function showAllJobTables() {
    let controls = document.getElementById('jobForm').querySelectorAll("table");
    for(let i=0;i<controls.length;i++) {
      $(controls[i]).show();
    }  
}

function hideTablesWithHiddenRows() {
    //hide any rows which don't have any editable fields in them
    let controls = document.getElementById('jobForm').querySelectorAll("table");
    for(let i=0;i<controls.length;i++) {
      let children = controls[i].querySelectorAll("tr");
      let hideFlag=true;
      for(let c=0;c<children.length;c++) {
        if(children[c].style.display == 'none' || children[c].innerHTML == '') {
          //
        } else {
          hideFlag=false;
        }
      }
      if(hideFlag==true) {
        controls[i].style.display='none';
      }
    }

}


function processJobSimplified() {
  
    let data = {rows:job};
    let output = {};

    for (let r= 0;r<data.rows.length;r++) {
      for(let col=0;col<data.rows[r].cols.length;col++) {
        if(data.rows[r].cols[col].fieldType=='input') {
          if(data.rows[r].cols[col].dataType == 'boolean') {
            let val = document.getElementById('field_' + data.rows[r].cols[col].id + '(' + r.toString() + ')').checked;
            output[data.rows[r].cols[col].id] = val;
          } else {
            let val = document.getElementById('field_' + data.rows[r].cols[col].id + '(' + r.toString() + ')').value;
            output[data.rows[r].cols[col].id] = val;
          }            
        }
      }    
    }  
    return JSON.stringify(output,null,2);
}

async function payInvoice(complete) {
    $("#modalInvoice").modal("show");
    try {
      let user = jobrecord.UserID.S.split('|');
      loadPaymentRequestInvoice(user[0], user[1], jobID, jobrecord.Reference.S );
    } catch(e) {
    }
}

function reFormatFixedDp(self,dp) {
  let val = self.value.replace(/[^0-9\.]/g,'');
  if(val.trim()=='') {
    self.value ='';
  } else {
    self.value = parseFloat(val).toFixed(dp);
  }
}