Primo Management
Primo Management
  • 1 288
  • 354 242

Відео

Setup PHP Composer on AppServ | Example 2
Переглядів 414 годин тому
getcomposer.org/download/ www.devdit.com/post/204/วิธีติดตั้ง-composer-เพื่อบริการจัดการ-library-php#gsc.tab=0 www.devdit.com/post/2864/วิธีติดตั้ง-phpspreadsheet-ด้วย-composer#gsc.tab=0
Setup PHP Composer on AppServ | Example 1
Переглядів 1414 годин тому
getcomposer.org/download/ www.devdit.com/post/204/วิธีติดตั้ง-composer-เพื่อบริการจัดการ-library-php#gsc.tab=0 www.devdit.com/post/2864/วิธีติดตั้ง-phpspreadsheet-ด้วย-composer#gsc.tab=0
Adjust Excel Layout during Print Preview
Переглядів 414 годин тому
Adjust Excel Layout during Print Preview
Generative AI Teachable Machine | Example 2
Переглядів 314 годин тому
teachablemachine.withgoogle.com/
Generative AI Teachable Machine | Example 1
Переглядів 614 годин тому
teachablemachine.withgoogle.com/
How to use RSD Booking Management
Переглядів 814 годин тому
Admin 8bd2c5rf07vsd1hjvnypgq.on.drv.tw/rsd_project/rsd_booking_management/ User docs.google.com/forms/d/e/1FAIpQLSfL07uLnWk22tXYnr0IwrnBpMD_fjGAsll_p_5uoNN_p1mIOg/viewform
Convert HTML to PDF Online. Save Webpage to PDF for keep in local.
Переглядів 614 годин тому
www.ilovepdf.com/html-to-pdf www.sejda.com/html-to-pdf html2pdf.com/ pdfcrowd.com/html-to-pdf/ cloudconvert.com/html-to-pdf
"please generate PHP code for autofill online form by use data from excel template to fill out"
Переглядів 414 годин тому
โปรดสร้างโค้ด PHP เพื่อกรอกแบบฟอร์มออนไลน์โดยอัตโนมัติโดยใช้ข้อมูลจากเทมเพลต Excel เพื่อกรอกข้อมูล
Let Canva make website
Переглядів 614 годин тому
Let Canva make website
The Noodle - Made from Canva
Переглядів 214 годин тому
The Noodle - Made from Canva
Let Canva make video
Переглядів 814 годин тому
Let Canva make video
Create Comic Strip with ChatGPT
Переглядів 214 годин тому
Create Comic Strip with ChatGPT
Generate Form through Prompt | GPT Google Form Builder (Chrome Extensions)
Переглядів 314 годин тому
chromewebstore.google.com/detail/gpt-google-form-builder/kjglafdhoohlhlicoklkgjffiedneeem วิธีการสร้าง Google Form ด้วย ChatGPT ง่ายๆ ในไม่กี่ขั้นตอน! ua-cam.com/video/frkw0NXq5v8/v-deo.html
Create Google Forms by ChatGPT | Form Builder Plus for GPT
Переглядів 1214 годин тому
Create Google Forms by ChatGPT | Form Builder Plus for GPT
Canva create QR Code link (No Ads)
Переглядів 914 годин тому
Canva create QR Code link (No Ads)
Make a song about anything | SUNO
Переглядів 414 годин тому
Make a song about anything | SUNO
Google Lens - Search what you see and convert image to text
Переглядів 114 годин тому
Google Lens - Search what you see and convert image to text
Tools for human imagination. Generative AI create image to video. | Runway
Переглядів 814 годин тому
Tools for human imagination. Generative AI create image to video. | Runway
AI Video Generator - Text To Video and Image To Video | Imagine Art
Переглядів 414 годин тому
AI Video Generator - Text To Video and Image To Video | Imagine Art
Generative AI create text to image | Microsoft Bing, Canva, Adobe Firefly
Переглядів 1914 годин тому
Generative AI create text to image | Microsoft Bing, Canva, Adobe Firefly
Turn text into video by Luma AI | Muhammad Ali
Переглядів 1014 годин тому
Turn text into video by Luma AI | Muhammad Ali
Unlock your creativity with Luma AI Video Generator. | Dream Machine
Переглядів 514 годин тому
Unlock your creativity with Luma AI Video Generator. | Dream Machine
Beautiful websites. No design or coding skills required. Powered by AI. | Gamma AI
Переглядів 714 годин тому
Beautiful websites. No design or coding skills required. Powered by AI. | Gamma AI
Beautiful presentations. No design or coding skills required. Powered by AI. | Gamma AI
Переглядів 1114 годин тому
Beautiful presentations. No design or coding skills required. Powered by AI. | Gamma AI
PKRU Generative AI Training #2
Переглядів 4День тому
PKRU Generative AI Training #2
PKRU Generative AI Training #1
Переглядів 8День тому
PKRU Generative AI Training #1
Google Form & Sheet | Show my location by GPS
Переглядів 35День тому
Google Form & Sheet | Show my location by GPS
Disabled Windows Defender Smartscreen on Windows 10
Переглядів 1314 днів тому
Disabled Windows Defender Smartscreen on Windows 10

КОМЕНТАРІ

  • @DIACARE-e4g
    @DIACARE-e4g 14 годин тому

    I accidentally deleted my fingerprint as admin. How to fix this problem. I can no longer have access

    • @primomgt1
      @primomgt1 14 годин тому

      @DIACARE-e4g Sorry, I don't know how to solve this case. Try to reset your machine for resume default from the factory. If it doesn't work, please contact your seller...

  • @primomgt1
    @primomgt1 6 днів тому

    <?php require 'vendor/autoload.php'; // Load PhpSpreadsheet library use PhpOffice\PhpSpreadsheet\IOFactory; // Path to the Excel file $excelFilePath = 'data.xlsx'; try { // Load the Excel file $spreadsheet = IOFactory::load($excelFilePath); $worksheet = $spreadsheet->getActiveSheet(); // Get the data as an array $rows = $worksheet->toArray(); // Extract headers (assume the first row contains column names) $headers = $rows[0]; unset($rows[0]); // Remove header row // Loop through rows and prepare data for autofill foreach ($rows as $row) { $formData = array_combine($headers, $row); // Simulate filling out an online form // Example: sending a POST request with form data to a URL $url = 'example.com/submit_form'; // Change this to your form's URL $response = sendPostRequest($url, $formData); echo "Form submitted for: " . $formData['Name'] . " (Response: $response) "; } } catch (Exception $e) { echo "Error: " . $e->getMessage(); } /** * Send a POST request to a URL with form data * * @param string $url * @param array $data * @return string */ function sendPostRequest($url, $data) { $options = [ 'http' => [ 'header' => "Content-type: application/x-www-form-urlencoded ", 'method' => 'POST', 'content' => http_build_query($data), ], ]; $context = stream_context_create($options); return file_get_contents($url, false, $context); } ?>

  • @primomgt1
    @primomgt1 6 днів тому

    composer require phpoffice/phpspreadsheet

  • @primomgt1
    @primomgt1 17 днів тому

    function mail_line_calendar() { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById("xxx"); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name //App Script of Google Sheet //var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); //var dataSheet = spreadSheet.getActiveSheet(); var lastRow = dataSheet.getLastRow(); var id = dataSheet.getRange(lastRow,2).getValue(); var name = dataSheet.getRange(lastRow,3).getValue(); var phone_number = dataSheet.getRange(lastRow,4).getValue(); var reservation = dataSheet.getRange(lastRow,5).getValue(); var start_date = dataSheet.getRange(lastRow,6).getValue(); var stop_date = dataSheet.getRange(lastRow,7).getValue(); var description = dataSheet.getRange(lastRow,8).getValue(); var mail = "xxx"; //Logger.log(start_date); //Logger.log(stop_date); var mail_subject = reservation+" | "+start_date+" - "+stop_date; var skeleton = "ID : %s "+ "Name : %s "+ "PhoneNumber : %s "+ "Reservation : %s "+ "Start Date : %s "+ "Stop Date : %s "+ "Description : %s "; var mail_text = Utilities.formatString(skeleton,id,name,phone_number,reservation,start_date,stop_date,description); MailApp.sendEmail(mail,mail_subject,mail_text); //Library NotifyApp //1vXbZfRP-7AqwqV7k0fGAnVjCe34pYyI2WdZBJw1Y8U0_DuEbo5fN32P9 //let token = ""; //LINE Token //NotifyApp.sendNotify(token,mail_text); var calendar = CalendarApp.getCalendarById("xxx"); //Google Calendar ID var titles = (reservation); var descriptions = mail_text; calendar.createEvent(titles,start_date,stop_date,{description:descriptions}); }

  • @primomgt1
    @primomgt1 17 днів тому

    function onFormSubmit(event) { record_array = []; var form = FormApp.openById("xxx"); //Google Form ID var formResponses = form.getResponses(); var formCount = formResponses.length; var formResponse = formResponses[formCount-1]; var itemResponses = formResponse.getItemResponses(); for(var i=0; i<itemResponses.length; i++) { var itemResponse = itemResponses[i]; var title = itemResponse.getItem().getTitle(); var answer = itemResponse.getResponse(); Logger.log(title); Logger.log(answer); record_array.push(answer); } AddRecord(record_array[0],record_array[1],record_array[2],record_array[3],record_array[4],record_array[5]); } function AddRecord(data1,data2,data3,data4,data5,data6) //Name,PhoneNumber,Reservation,StartDate,StopDate,Description { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById("xxx"); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name //App Script of Google Sheet //var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); //var dataSheet = spreadSheet.getActiveSheet(); var data0 = Utilities.formatDate(new Date(),"GMT+7","yyyyMMddhhmmss"); //yyyy-MM-dd hh:mm:ss.SSS dataSheet.appendRow([new Date(),data0,data1,data2,data3,data4,data5,data6]); //Add Record //var i = 2; //Set //dataSheet.getRange("A"+i).setValue([data1]); //Insert in Specific Cell //dataSheet.getRange(i,3).setValue([data1]); //Insert in Specific Cell }

  • @primomgt1
    @primomgt1 17 днів тому

    rsd_booking_management RSD Booking Management ระบบจัดการการจอง rsd_notify_alert RSD Notify Alert ระบบแจ้งเตือน Now ID Name PhoneNumber Reservation StartDate StopDate Description 1 Now 2 ID 3 Name ชื่อ-สกุล 4 PhoneNumber หมายเลขโทรศัพท์ 5 Reservation การจอง ห้องประชุมสภา ชั้น 5 ห้องประชุม ชั้น 3 ห้องประชุมเล็ก ข้างห้องปลัดฯ ชั้น 2 6 StartDate วัน-เวลา เริ่มต้น 7 StopDate วัน-เวลา สิ้นสุด 8 Description รายละเอียด

  • @Chezzydavesupportersubtohim789
    @Chezzydavesupportersubtohim789 18 днів тому

    I dont get it sorry...❤

  • @reev3s
    @reev3s 19 днів тому

    i love you man

    • @primomgt1
      @primomgt1 19 днів тому

      @reev3s Cheers 🍻

  • @justjugwar
    @justjugwar 19 днів тому

    DDR3 Rams are dirt cheap

    • @primomgt1
      @primomgt1 19 днів тому

      @justjugwar Thanks so much for your comment 😊

  • @Harsa-j1l
    @Harsa-j1l 19 днів тому

    No link provided in description

    • @primomgt1
      @primomgt1 19 днів тому

      @@Harsa-j1l ua-cam.com/play/PLmrTMUhqzS3j981TZtNm31FVFkFHKvpaC.html&si=h_08CM86JDJDvser

    • @Harsa-j1l
      @Harsa-j1l 19 днів тому

      @primomgt1 site not working

    • @primomgt1
      @primomgt1 19 днів тому

      @Harsa-j1l Hmm... 1. Refresh Ctrl+F5 and try again 2. Try in another web browser e.g. Chrome, Edge, Firefox, Opera If still not working, try again in another computer.

  • @Harsa-j1l
    @Harsa-j1l 19 днів тому

    Please send original link

    • @primomgt1
      @primomgt1 19 днів тому

      @@Harsa-j1l ua-cam.com/play/PLmrTMUhqzS3j981TZtNm31FVFkFHKvpaC.html&si=9EgOvpXyUi-r1LqM

  • @Harsa-j1l
    @Harsa-j1l 19 днів тому

    Site Not working

    • @primomgt1
      @primomgt1 19 днів тому

      @Harsa-j1l Follow the original link in the description #1

  • @VERSACity-22
    @VERSACity-22 24 дні тому

    shit video. waste time

  • @okoyestephanie6546
    @okoyestephanie6546 Місяць тому

    Does it always have to be plugged in?

    • @primomgt1
      @primomgt1 Місяць тому

      @okoyestephanie6546 Sure, because it hasn't a battery stand alone inside.

  • @primomgt1
    @primomgt1 Місяць тому

    ติดต่อไลน์ไอดี you.temp

  • @primomgt1
    @primomgt1 Місяць тому

    ทดลองใช้งาน youmgt.rf.gd/pos24.2

  • @primomgt1
    @primomgt1 Місяць тому

    ติดต่อไลน์ไอดี you.temp

  • @primomgt1
    @primomgt1 Місяць тому

    ทดลองใช้งาน youmgt.rf.gd/pos24.2

  • @primomgt1
    @primomgt1 Місяць тому

    ติดต่อไลน์ไอดี you.temp

  • @primomgt1
    @primomgt1 Місяць тому

    ทดลองใช้งาน youmgt.rf.gd/pos24.2

  • @rhythmgarg175
    @rhythmgarg175 Місяць тому

    Thank you sir

    • @primomgt1
      @primomgt1 Місяць тому

      @@rhythmgarg175 Go-ahead 😁

    • @rhythmgarg175
      @rhythmgarg175 Місяць тому

      Sir appserv is working but xampp is not working it is showing error "error establishing a database connection" How do I fix this ?

    • @primomgt1
      @primomgt1 Місяць тому

      @rhythmgarg175 Hmm... I did this video on Windows 10. Please watch it again slowly and follow me step-by-step in deep detail. If it is still not working, search another solution in Google.

  • @primomgt1
    @primomgt1 Місяць тому

    shopee.co.th/comdee2you

  • @dariusquan6076
    @dariusquan6076 Місяць тому

    heelo where to get this game

    • @primomgt1
      @primomgt1 Місяць тому

      @@dariusquan6076 Search in Google "Soul Edge ePSXe Emulator PC Windows"

  • @himalakacb
    @himalakacb Місяць тому

    thanks a lot. i was about to die with the issue. now it's solved instead of re instaling windows with your guiding. thanks again. 😊

    • @primomgt1
      @primomgt1 Місяць тому

      @himalakacb You're welcome 😊

  • @primomgt1
    @primomgt1 2 місяці тому

    Reservation Now | ID | StartDate | StopDate | Description | Mail | Photo ---------- function onFormSubmit(event) { record_array = []; var form = FormApp.openById(""); //Google Form ID var formResponses = form.getResponses(); var formCount = formResponses.length; var formResponse = formResponses[formCount-1]; var itemResponses = formResponse.getItemResponses(); for(var i=0; i<itemResponses.length; i++) { var itemResponse = itemResponses[i]; var title = itemResponse.getItem().getTitle(); var answer = itemResponse.getResponse(); Logger.log(title); Logger.log(answer); record_array.push(answer); } AddRecord(record_array[0],record_array[1],record_array[2],record_array[3],record_array[4]); } function AddRecord(data1,data2,data3,data4,data5) { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name //App Script of Google Sheet //var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); //var dataSheet = spreadSheet.getActiveSheet(); var data0 = Utilities.formatDate(new Date(),"GMT+7","yyyyMMddhhmmss"); //yyyy-MM-dd hh:mm:ss.SSS dataSheet.appendRow([new Date(),data0,data1,data2,data3,data4,data5]); //Add Record //var i = 2; //Set //dataSheet.getRange("A"+i).setValue([data1]); //Insert in Specific Cell //dataSheet.getRange(i,3).setValue([data1]); //Insert in Specific Cell //App Script of Google Form var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name var lastRow = dataSheet.getLastRow(); var start_date = new Date(dataSheet.getRange(lastRow,3).getValue()); var stop_date = new Date(dataSheet.getRange(lastRow,4).getValue()); var description = dataSheet.getRange(lastRow,5).getValue(); var mail = dataSheet.getRange(lastRow,6).getValue(); Logger.log(start_date); Logger.log(stop_date); Logger.log(description); Logger.log(mail); var mail_subject = "This mail is sent to you on "+new Date(); var skeleton = "Start Date : %s "+ "Stop Date : %s "+ "Detail : %s "; var mail_text = Utilities.formatString(skeleton,start_date,stop_date,description); MailApp.sendEmail(mail,mail_subject,mail_text); //Library NotifyApp //1vXbZfRP-7AqwqV7k0fGAnVjCe34pYyI2WdZBJw1Y8U0_DuEbo5fN32P9 let token = ""; //LINE Token NotifyApp.sendNotify(token,mail_text); var calendar = CalendarApp.getCalendarById(""); //Google Calendar ID var titles = (description); var descriptions = mail_text; calendar.createEvent(titles,start_date,stop_date,{description:descriptions}); //Library PdfService //1iePjnglUzelAuJJb-QykRcUUWYBSKiNGUWVljnNe03G9zWzSUGIRWLXa let sheetId = "" //Google Sheet ID let sheetName = "" //Sheet Name let tmpFileId = "" //Google Slide ID let pdfFolder = DriveApp.getFoldersByName("PDF_Folder").next() //Create new folder "PDF_Folder" let templateFile = DriveApp.getFileById(tmpFileId) let data =PdfService.initData(sheetId,sheetName) //extend with ,3 -> run row 3 | ,2,5 -> run row 2 to row 5 | blank -> run last row only //let data =PdfService.initData(sheetId,sheetName,2,lastRow) //run row 2 to last row let option = { pdfFolder: pdfFolder, templateFile: templateFile, data: data, image_column: ["รูป"], fileName: ["ชื่อ","สกุล"] } PdfService.createPDFFromSlide(option) } ---------- Management Select | Keyword | StartDate | StopDate | Description | Mail Update Description by ID Update all by row Clear by row Delete by row Delete all function onFormSubmit(event) { record_array = []; var form = FormApp.openById(""); //Google Form ID var formResponses = form.getResponses(); var formCount = formResponses.length; var formResponse = formResponses[formCount-1]; var itemResponses = formResponse.getItemResponses(); for(var i=0; i<itemResponses.length; i++) { var itemResponse = itemResponses[i]; var title = itemResponse.getItem().getTitle(); var answer = itemResponse.getResponse(); Logger.log(title); Logger.log(answer); record_array.push(answer); } AddRecord(record_array[0],record_array[1],record_array[2],record_array[3],record_array[4],record_array[5]); } function AddRecord(data1,data2,data3,data4,data5,data6) { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name var lastRow = dataSheet.getLastRow(); if(data1 == "Update Description by ID") { for(var i=2; i<=lastRow; i++) //Start Row { if(dataSheet.getRange(i,2).getValue() == data2) //Find "xxx" in [Row i][Column 2] { dataSheet.getRange("E"+i).setValue([data5]); } } } if(data1 == "Update all by row") { dataSheet.getRange("C"+data2).setValue([data3]); dataSheet.getRange("D"+data2).setValue([data4]); dataSheet.getRange("E"+data2).setValue([data5]); dataSheet.getRange("F"+data2).setValue([data6]); } if(data1 == "Clear by row") { dataSheet.getRange("A"+data2+":F"+data2).clear(); } if(data1 == "Delete by row") { dataSheet.deleteRow(data2); } if(data1 == "Delete all") { for(var i=2; i<=lastRow; i++) { dataSheet.deleteRow(i); } } } ---------- function showData() { //App Script of Google Form //var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID //var dataSheet = spreadSheet.getSheetByName(""); //Sheet Name //App Script of Google Sheet var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); var dataSheet = spreadSheet.getActiveSheet(); var lastRow = dataSheet.getLastRow(); var lastColumn = dataSheet.getLastColumn(); var currentRow = SpreadsheetApp.getActiveSheet().getActiveCell().getRow(); Logger.log("Last Row : "+lastRow); Logger.log("Last Column : "+lastColumn); Logger.log("Current Row : "+currentRow); var data1 = dataSheet.getRange(2,3).getValue(); var data2 = dataSheet.getRange(lastRow,1).getValue(); var data3 = dataSheet.getRange(lastRow,lastColumn).getValue(); Logger.log("Data 1 : "+data1); Logger.log("Data 2 : "+data2); Logger.log("Data 3 : "+data3); }

  • @primomgt1
    @primomgt1 2 місяці тому

    reservation now | id | start_date | stop_date | detail | mail function onFormSubmit(event) { record_array = []; var form = FormApp.openById(""); //Google Form ID var formResponses = form.getResponses(); var formCount = formResponses.length; var formResponse = formResponses[formCount-1]; var itemResponses = formResponse.getItemResponses(); for(var i=0; i<itemResponses.length; i++) { var itemResponse = itemResponses[i]; var title = itemResponse.getItem().getTitle(); var answer = itemResponse.getResponse(); Logger.log(title); Logger.log(answer); record_array.push(answer); } AddRecord(record_array[0],record_array[1],record_array[2],record_array[3]); } function AddRecord(data1,data2,data3,data4) //start_date,stop_date,detail,mail { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name //App Script of Google Sheet //var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); //var dataSheet = spreadSheet.getActiveSheet(); var lastRow = dataSheet.getLastRow(); var data0 = Utilities.formatDate(new Date(),"GMT+7","yyyyMMddhhmmss"); //yyyy-MM-dd hh:mm:ss.SSS dataSheet.appendRow([new Date(),data0,data1,data2,data3,data4]); //Add Record //var i = 2; //Set //dataSheet.getRange("A"+i).setValue([data1]); //Insert in Specific Cell //dataSheet.getRange(i,3).setValue([data1]); //Insert in Specific Cell var start_date = new Date(dataSheet.getRange(lastRow,3).getValue()); var stop_date = new Date(dataSheet.getRange(lastRow,4).getValue()); var detail = dataSheet.getRange(lastRow,5).getValue(); var mail = dataSheet.getRange(lastRow,6).getValue(); Logger.log(start_date); Logger.log(stop_date); Logger.log(detail); Logger.log(mail); var mail_subject = "This mail is sent to you on "+new Date(); var skeleton = "Start Date : %s "+ "Stop Date : %s "+ "Detail : %s "; var mail_text = Utilities.formatString(skeleton,start_date,stop_date,detail); MailApp.sendEmail(mail,mail_subject,mail_text); //Library NotifyApp //1vXbZfRP-7AqwqV7k0fGAnVjCe34pYyI2WdZBJw1Y8U0_DuEbo5fN32P9 //LINE Token //mvBWkdR0m8EDq7CQnKdTZIj3FZLiwPpPNZR6f9RAM5u let token = ""; //LINE Token NotifyApp.sendNotify(token,mail_text); var calendar = CalendarApp.getCalendarById(""); //Google Calendar ID var titles = (detail); var descriptions = mail_text; calendar.createEvent(titles,start_date,stop_date,{description:descriptions}); } function showData() { //App Script of Google Form //var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID //var dataSheet = spreadSheet.getSheetByName(""); //Sheet Name //App Script of Google Sheet var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); var dataSheet = spreadSheet.getActiveSheet(); var lastRow = dataSheet.getLastRow(); var lastColumn = dataSheet.getLastColumn(); var currentRow = SpreadsheetApp.getActiveSheet().getActiveCell().getRow(); Logger.log("Last Row : "+lastRow); Logger.log("Last Column : "+lastColumn); Logger.log("Current Row : "+currentRow); var data1 = dataSheet.getRange(2,3).getValue(); var data2 = dataSheet.getRange(lastRow,1).getValue(); var data3 = dataSheet.getRange(lastRow,lastColumn).getValue(); Logger.log("Data 1 : "+data1); Logger.log("Data 2 : "+data2); Logger.log("Data 3 : "+data3); }

  • @primomgt1
    @primomgt1 2 місяці тому

    management select | keyword | start_date | stop_date | detail | mail update detail by id update all by row clear by row delete by row delete all function onFormSubmit(event) { record_array = []; var form = FormApp.openById(""); //Google Form ID var formResponses = form.getResponses(); var formCount = formResponses.length; var formResponse = formResponses[formCount-1]; var itemResponses = formResponse.getItemResponses(); for(var i=0; i<itemResponses.length; i++) { var itemResponse = itemResponses[i]; var title = itemResponse.getItem().getTitle(); var answer = itemResponse.getResponse(); Logger.log(title); Logger.log(answer); record_array.push(answer); } AddRecord(record_array[0],record_array[1],record_array[2],record_array[3],record_array[4],record_array[5]); } function AddRecord(data1,data2,data3,data4,data5,data6) //select,keyword,start_date,stop_date,detail,mail { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name var lastRow = dataSheet.getLastRow(); if(data1 == "update detail by id") { for(var i=2; i<=lastRow; i++) //Start Row { if(dataSheet.getRange(i,2).getValue() == data2) //Find "xxx" in [Row i][Column 2] { dataSheet.getRange("E"+i).setValue([data5]); } } } if(data1 == "update all by row") { dataSheet.getRange("C"+data2).setValue([data3]); dataSheet.getRange("D"+data2).setValue([data4]); dataSheet.getRange("E"+data2).setValue([data5]); dataSheet.getRange("F"+data2).setValue([data6]); } if(data1 == "clear by row") { dataSheet.getRange("A"+data2+":F"+data2).clear(); } if(data1 == "delete by row") { dataSheet.deleteRow(data2); } if(data1 == "delete all") { for(var i=2; i<=lastRow; i++) { dataSheet.deleteRow(i); } } }

  • @primomgt1
    @primomgt1 2 місяці тому

    notification function mail_line_calendar() { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name //App Script of Google Sheet //var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); //var dataSheet = spreadSheet.getActiveSheet(); var lastRow = dataSheet.getLastRow(); var start_date = new Date(dataSheet.getRange(lastRow,3).getValue()); var stop_date = new Date(dataSheet.getRange(lastRow,4).getValue()); var detail = dataSheet.getRange(lastRow,5).getValue(); var mail = dataSheet.getRange(lastRow,6).getValue(); Logger.log(start_date); Logger.log(stop_date); Logger.log(detail); Logger.log(mail); var mail_subject = "This mail is sent to you on "+new Date(); var skeleton = "Start Date : %s "+ "Stop Date : %s "+ "Detail : %s "; var mail_text = Utilities.formatString(skeleton,start_date,stop_date,detail); MailApp.sendEmail(mail,mail_subject,mail_text); //Library NotifyApp //1vXbZfRP-7AqwqV7k0fGAnVjCe34pYyI2WdZBJw1Y8U0_DuEbo5fN32P9 let token = ""; //LINE Token NotifyApp.sendNotify(token,mail_text); var calendar = CalendarApp.getCalendarById(""); //Google Calendar ID var titles = (detail); var descriptions = mail_text; calendar.createEvent(titles,start_date,stop_date,{description:descriptions}); }

  • @primomgt1
    @primomgt1 2 місяці тому

    reservation now | id | start_date | stop_date | detail | mail function showData() { //App Script of Google Form //var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID //var dataSheet = spreadSheet.getSheetByName(""); //Sheet Name //App Script of Google Sheet var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); var dataSheet = spreadSheet.getActiveSheet(); var lastRow = dataSheet.getLastRow(); var lastColumn = dataSheet.getLastColumn(); var currentRow = SpreadsheetApp.getActiveSheet().getActiveCell().getRow(); Logger.log("Last Row : "+lastRow); Logger.log("Last Column : "+lastColumn); Logger.log("Current Row : "+currentRow); var data1 = dataSheet.getRange(2,3).getValue(); var data2 = dataSheet.getRange(lastRow,1).getValue(); var data3 = dataSheet.getRange(lastRow,lastColumn).getValue(); Logger.log("Data 1 : "+data1); Logger.log("Data 2 : "+data2); Logger.log("Data 3 : "+data3); } function onFormSubmit(event) { record_array = []; var form = FormApp.openById(""); //Google Form ID var formResponses = form.getResponses(); var formCount = formResponses.length; var formResponse = formResponses[formCount-1]; var itemResponses = formResponse.getItemResponses(); for(var i=0; i<itemResponses.length; i++) { var itemResponse = itemResponses[i]; var title = itemResponse.getItem().getTitle(); var answer = itemResponse.getResponse(); Logger.log(title); Logger.log(answer); record_array.push(answer); } AddRecord(record_array[0],record_array[1],record_array[2],record_array[3]); } function AddRecord(data1,data2,data3,data4) //start_date,stop_date,detail,mail { //App Script of Google Form var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID var dataSheet = spreadSheet.getSheetByName("Sheet1"); //Sheet Name //App Script of Google Sheet //var spreadSheet = SpreadsheetApp.getActiveSpreadsheet(); //var dataSheet = spreadSheet.getActiveSheet(); var lastRow = dataSheet.getLastRow(); var data0 = Utilities.formatDate(new Date(),"GMT+7","yyyyMMddhhmmss"); //yyyy-MM-dd hh:mm:ss.SSS dataSheet.appendRow([new Date(),data0,data1,data2,data3,data4]); //Add Record //var i = 2; //Set //dataSheet.getRange("A"+i).setValue([data1]); //Insert in Specific Cell //dataSheet.getRange(i,3).setValue([data1]); //Insert in Specific Cell }

  • @primomgt1
    @primomgt1 2 місяці тому

    //Library //1iePjnglUzelAuJJb-QykRcUUWYBSKiNGUWVljnNe03G9zWzSUGIRWLXa function runPDF(){ //var spreadSheet = SpreadsheetApp.openById(""); //Google Sheet ID //var dataSheet = spreadSheet.getSheetByName(""); //Sheet Name //var lastRow = dataSheet.getLastRow(); let sheetId = '' //Google Sheet ID let sheetName = '' //Sheet Name let tmpFileId = '' //Google Slide ID let pdfFolder = DriveApp.getFoldersByName('pdf_folder').next() //PDF Folder let templateFile = DriveApp.getFileById(tmpFileId) let data =PdfService.initData(sheetId,sheetName) //extend with ,3 -> run row 3 | ,2,5 -> run row 2 to row 5 | blank -> run last row only //let data =PdfService.initData(sheetId,sheetName,2,lastRow) //run row 2 to last row let option = { pdfFolder: pdfFolder, templateFile: templateFile, data: data, image_column: ['รูป'], fileName: ['ชื่อ','สกุล'] } PdfService.createPDFFromSlide(option) }

  • @AyuDewiningrumRahmawan
    @AyuDewiningrumRahmawan 2 місяці тому

    How to reset? No admin user

    • @primomgt1
      @primomgt1 2 місяці тому

      @@AyuDewiningrumRahmawan For my machine, it has a hole beside. I can use a pin to dig it for reset.

  • @ghalynovandri7266
    @ghalynovandri7266 2 місяці тому

    then how to open it?

    • @primomgt1
      @primomgt1 2 місяці тому

      @@ghalynovandri7266 Between phone and computer connect with USB/Type C cable first.

  • @khairyzainal
    @khairyzainal 3 місяці тому

    How do you upload empoyee data?

    • @primomgt1
      @primomgt1 3 місяці тому

      @khairyzainal Use USB Port to upload .txt file of employee data into the machine.

  • @HiltonPereira
    @HiltonPereira 3 місяці тому

    Sabe me dizer se eu ligar um cabo v3 no relógio ponto (ela tem 1 entrada usb + 1 entrada v3) eu consigo alterar as imagens de proteção de tela?

    • @primomgt1
      @primomgt1 3 місяці тому

      @@HiltonPereira Sorry, I don't understand your language in question.

  • @Dino_Panda_Rexal
    @Dino_Panda_Rexal 3 місяці тому

    this is fake machine i am use signed In only but not Signed Out Option

    • @primomgt1
      @primomgt1 3 місяці тому

      @@Dino_Panda_Rexal Thank you for your comment. I'm not sure about your machine. Please find another solution in Google or ChatGPT.

  • @Dino_Panda_Rexal
    @Dino_Panda_Rexal 3 місяці тому

    in video show signed In but where is the Signed Out Option?

    • @primomgt1
      @primomgt1 3 місяці тому

      @@Dino_Panda_Rexal After sign in, it will switch to sign out option.

  • @JohnCastiglione-p6u
    @JohnCastiglione-p6u 3 місяці тому

    too fast

    • @primomgt1
      @primomgt1 3 місяці тому

      @JohnCastiglione-p6u You can decrease speed on UA-cam screen.

  • @angeladatu2839
    @angeladatu2839 4 місяці тому

    Hello, i just wanted to ask how to edit the login time?

    • @primomgt1
      @primomgt1 4 місяці тому

      @@angeladatu2839 Go to SETUP function, with this can edit anything.

  • @iamin9688
    @iamin9688 4 місяці тому

    Man, il sub to you with all my like 20 acc when i get on pc.

    • @primomgt1
      @primomgt1 4 місяці тому

      @@iamin9688 Thank you so much 😁

  • @iamin9688
    @iamin9688 4 місяці тому

    Thank you man!! You saved me <3 gg

    • @primomgt1
      @primomgt1 4 місяці тому

      @@iamin9688 Cheers 🍻

  • @k.chriscaldwell4141
    @k.chriscaldwell4141 4 місяці тому

    Thanks for the video. The USB must be formatted with FAT32. Maybe FAT. NTFS will give a format error. This thing always reports “signed in.” Very confusing.

    • @primomgt1
      @primomgt1 4 місяці тому

      @@k.chriscaldwell4141 Thank you so much for your shared knowledge... so appreciated.

  • @elbertsamuelmiranda1246
    @elbertsamuelmiranda1246 4 місяці тому

    can you give me a copy of bin file of megaman 8?

    • @primomgt1
      @primomgt1 4 місяці тому

      @@elbertsamuelmiranda1246 Please see and learn from my this clip: ua-cam.com/video/9VPF3pi4xMk/v-deo.htmlsi=lsR55Hy4-T2oQ15g

  • @susanseymour8789
    @susanseymour8789 4 місяці тому

    What was even the point of this

    • @primomgt1
      @primomgt1 4 місяці тому

      @susanseymour8789 See the "Know How" link in the description.

  • @computerlaptop-n2h
    @computerlaptop-n2h 4 місяці тому

    thank you ...working ...i recover my access db password .

  • @lazarus4188
    @lazarus4188 4 місяці тому

    why is it always signed in but doesn't have signed out

    • @primomgt1
      @primomgt1 4 місяці тому

      @@lazarus4188 Sorry, I don't understand your question.

    • @lazarus4188
      @lazarus4188 4 місяці тому

      @@primomgt1 everytime we put our finger only signed in

    • @lazarus4188
      @lazarus4188 4 місяці тому

      @@primomgt1 there's no signed out

    • @FatMochiiiii
      @FatMochiiiii 4 місяці тому

      @@primomgt1 Same for me. Whenever I tap to scan my fingerprint, it always says sign in. How do you sign out of it once the shift ends?

    • @primomgt1
      @primomgt1 4 місяці тому

      @FatMochiiiii Sorry, I'm not sure. Normally, it has a hole to pin in and hold about 30 seconds for hard reset. In this way, maybe solve your problem.

  • @manishjaiswal7456
    @manishjaiswal7456 5 місяців тому

    jaise muje morng me 9:20 ke andr sabhi staff ki attendence set krna h uske liye kya krna hoga

    • @primomgt1
      @primomgt1 5 місяців тому

      @@manishjaiswal7456 Sorry, I don't understand your language.

  • @briancidtrejo626
    @briancidtrejo626 5 місяців тому

    tu linck ya no sirve

    • @primomgt1
      @primomgt1 5 місяців тому

      @@briancidtrejo626 Thank you...

  • @PansakPoppond
    @PansakPoppond 5 місяців тому

    ขาย เท่าไหร่ครับ

    • @primomgt1
      @primomgt1 5 місяців тому

      @@PansakPoppond 5.5 แสนครับ

  • @primomgt1
    @primomgt1 5 місяців тому

    I'd like to make sure that "Password protected sharing = On" Control Panel\All Control Panel Items\Network and Sharing Center > Change advanced sharing settings > Password protected sharing = On