CreateFromExistingJavaScript.html

<script>
  $(function() {
    $('#sidebar-save-button').click(onSaveClick);

    utils.disableButtons();

    clearOptions();
    loadConfig();

    utils.enableButtons();
  });

  function onSaveClick() {
    utils.disableButtons();
    utils.enableLoader();

    var saveOptions = getOptions();

    google.script.run
      .withSuccessHandler(
        function(msg) {
          if(msg){
            console.log(msg);
          }else{
            console.log('Config saved.');
          }
        })
      .withFailureHandler(
        function(msg) {
          utils.failure(msg);
        })
      .createFromExisting(
        saveOptions.sheet_name,
        saveOptions.range_person_name,
        saveOptions.range_timeslot,
        saveOptions.range_timestamp,
        saveOptions.lookup_sheet_name.
        saveOptions.lookup_range_person_name,
        saveOptions.lookup_range_timeslot,
        saveOptions.lookup_range_timestamp,
        saveOptions.lookup_data_retention_days
      );
  }

  function getOptions() {
    return {
      lookup_sheet_name: $('#sidebar-lookup-sheetname').val().trim(),
      lookup_range_person_name: $('#sidebar-lookup-person-name-range').val(),
      lookup_range_timeslot: $('#sidebar-lookup-timeslot-range').val(),
      lookup_range_timestamp: $('#sidebar-lookup-timestamp-range').val(),
      lookup_data_retention_days: $('#sidebar-lookup-data-retention-days').val(),

      sheet_name: $('#sidebar-fillup-sheetname').val(),
      range_person_name: $('#sidebar-fillup-person-name-range').val(),
      range_timeslot: $('#sidebar-fillup-timeslot-range').val(),
      range_timestamp: $('#sidebar-fillup-timestamp-range').val()
    };
  }

  function loadConfig() {
    google.script.run
      .withSuccessHandler(
        function(config) {
          if (config) {
            $('#sidebar-lookup-sheetname').val(config.lookup_sheet_name);
            $('#sidebar-lookup-person-name-range').val(config.lookup_range_person_name);
            $('#sidebar-lookup-timeslot-range').val(config.lookup_range_timeslot);
            $('#sidebar-lookup-timestamp-range').val(config.lookup_range_timestamp);
            $('#sidebar-lookup-data-retention-days').val(config.lookup_data_retention_days);

            $('#sidebar-fillup-sheetname').val(config.sheet_name);
            $('#sidebar-fillup-person-name-range').val(config.range_person_name);
            $('#sidebar-fillup-timeslot-range').val(config.range_timeslot);
            $('#sidebar-fillup-timestamp-range').val(config.range_timestamp);
          } else {
            console.log('unable to load config');
          }
        })
      .withFailureHandler(
        function(msg) {
          utils.failure(msg);
        })
      .readConfigForActiveSheet();
  }

  function clearOptions() {
    $('#sidebar-lookup-sheetname').val('');
    $('#sidebar-lookup-person-name-range').val('');
    $('#sidebar-lookup-timeslot-range').val('');
    $('#sidebar-lookup-timestamp-range').val('');
    $('#sidebar-lookup-data-retention-days').val('');

    $('#sidebar-fillup-sheetname').val('');
    $('#sidebar-fillup-person-name-range').val('');
    $('#sidebar-fillup-timeslot-range').val('');
    $('#sidebar-fillup-timestamp-range').val('');
  }
</script>