App Script

const sheetName = 'input'
const scriptProp = PropertiesService.getScriptProperties()

function intialSetup () {
 const activeSpreadsheet = SpreadsheetApp.getActiveSpreadsheet()
 scriptProp.setProperty('key', activeSpreadsheet.getId())
}

function doPost (e) {
 const lock = LockService.getScriptLock()
 lock.tryLock(10000)

try {
   const doc = SpreadsheetApp.openById(scriptProp.getProperty('key'))
   const sheet = doc.getSheetByName(sheetName)

const headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0]
   const nextRow = sheet.getLastRow()

const newRow = headers.map(function(header) {
     return header === 'Date' ? new Date() : e.parameter[header]
   })

sheet.getRange(nextRow, 1, 1, newRow.length).setValues([newRow])

return ContentService
     .createTextOutput(JSON.stringify({ 'result': 'success', 'row': nextRow }))
     .setMimeType(ContentService.MimeType.JSON)
 }

catch (e) {
   return ContentService
     .createTextOutput(JSON.stringify({ 'result': 'error', 'error': e }))
     .setMimeType(ContentService.MimeType.JSON)
 }

finally {
   lock.releaseLock()
 }
}

HTML Code

<p style="display:none;">
WEB COUNT
</p>

<input id="date" name="Date"/>
<input id="time" name="Time" />
<input id="source" name="Source" />
<button id="webcount" type="submit" name="submit" class="btnSubmit btn-block">Submit</button>
</form>

const scriptURL = 'https://script.google.com/macros/s/AKfycbyXvpITPtt02c82POi2a0jIdG3gKSMC5uEqq_DAM0mkH7KoJ6vhEr2-GvMQaWwGAzGX7g/exec'

const form = document.forms['google-sheet']
          
            form.addEventListener('submit', e => {
              e.preventDefault()
              fetch(scriptURL, { method: 'POST', body: new FormData(form)})
         
            })
            
            
</script>

setInterval(run,1);

function run(){
document.getElementById("time").value=new Date().toLocaleTimeString();
document.getElementById("date").value=new Date().toDateString();
document.getElementById("source").value= window.location.href;
}

setTimeout(()=> {document.getElementById("webcount").click();},1000);

</script>

BETA : Web to Sheet

App Script

HTML Code

Loading...