Advanced Document Control Log

 

Construction Document Control Log

Below is an embedded Google Sheet with all document control details for easy tracking and updating.

Chatbot Assistant

Use the chatbot below to ask questions about document control processes or request assistance with specific documents.

ChatGPT Document Control Assistant

Chat with ChatGPT for assistance related to construction document control. Enter your query below:

Document Control Reminder Automation

This automation sends reminders for pending or overdue documents based on the "Days Elapsed" field.

Note: This script should be implemented in the Google Sheet's Apps Script environment.

function sendEmailReminders() {

  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Document Control Log');

  const data = sheet.getDataRange().getValues();

  data.forEach(row => {

    const [docID, title, createdDate, updatedDate, assignedTo, status, daysElapsed] = row;

    if (daysElapsed > 30 && status != "Approved") {

      MailApp.sendEmail(assignedTo, "Reminder: Document " + title + " is Overdue", 

        "The document \"" + title + "\" (ID: " + docID + ") is pending for " + daysElapsed + " days.");

    }

  });

}

  

Reminder: This script needs to be set up as a daily trigger in Google Sheets' Apps Script environment.

const openaiApiKey = 'YOUR_OPENAI_API_KEY'; function fetchChatGPTResponse(input) { const url = 'https://api.openai.com/v1/chat/completions'; const payload = JSON.stringify({ model: "gpt-3.5-turbo", messages: [{ role: "user", content: input }] }); const options = { method: 'post', contentType: 'application/json', headers: { Authorization: 'Bearer ' + openaiApiKey }, payload: payload }; const response = UrlFetchApp.fetch(url, options); const json = JSON.parse(response.getContentText()); return json.choices[0].message.content; }