- 1 288
- 354 242
Primo Management
Приєднався 17 чер 2019
ลืมรหัสผ่าน Windows 11 แก้ง่ายนิดเดียว ไม่ต้องใช้โปรแกรม [Reference]
ua-cam.com/video/i21C6v0rFCs/v-deo.html
share/v/18X31of4Dc/
share/v/18X31of4Dc/
Переглядів: 16
Відео
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 เพื่อกรอกข้อมูล
โปรแกรม สปสช. (nhso) สำหรับองค์การการปกครองส่วนท้องถิ่น (อปท.)
Переглядів 514 годин тому
www.nhso.go.th/downloads?type=3
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
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
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
I accidentally deleted my fingerprint as admin. How to fix this problem. I can no longer have access
@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...
<?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); } ?>
composer require phpoffice/phpspreadsheet
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}); }
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 }
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 รายละเอียด
I dont get it sorry...❤
@@Chezzydavesupportersubtohim789 Mirror Bridge 🌉 ✨️
Oh ok cool! 😁 I liked the video by the way!!
@MihaelaNastevska-e1n Thanks 😊
🥰
Ne sub btw!
i love you man
@reev3s Cheers 🍻
DDR3 Rams are dirt cheap
@justjugwar Thanks so much for your comment 😊
No link provided in description
@@Harsa-j1l ua-cam.com/play/PLmrTMUhqzS3j981TZtNm31FVFkFHKvpaC.html&si=h_08CM86JDJDvser
@primomgt1 site not working
@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.
Please send original link
@@Harsa-j1l ua-cam.com/play/PLmrTMUhqzS3j981TZtNm31FVFkFHKvpaC.html&si=9EgOvpXyUi-r1LqM
Site Not working
@Harsa-j1l Follow the original link in the description #1
shit video. waste time
Does it always have to be plugged in?
@okoyestephanie6546 Sure, because it hasn't a battery stand alone inside.
ติดต่อไลน์ไอดี you.temp
ทดลองใช้งาน youmgt.rf.gd/pos24.2
ติดต่อไลน์ไอดี you.temp
ทดลองใช้งาน youmgt.rf.gd/pos24.2
ติดต่อไลน์ไอดี you.temp
ทดลองใช้งาน youmgt.rf.gd/pos24.2
Thank you sir
@@rhythmgarg175 Go-ahead 😁
Sir appserv is working but xampp is not working it is showing error "error establishing a database connection" How do I fix this ?
@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.
shopee.co.th/comdee2you
heelo where to get this game
@@dariusquan6076 Search in Google "Soul Edge ePSXe Emulator PC Windows"
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. 😊
@himalakacb You're welcome 😊
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); }
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); }
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); } } }
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}); }
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 }
//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) }
How to reset? No admin user
@@AyuDewiningrumRahmawan For my machine, it has a hole beside. I can use a pin to dig it for reset.
then how to open it?
@@ghalynovandri7266 Between phone and computer connect with USB/Type C cable first.
How do you upload empoyee data?
@khairyzainal Use USB Port to upload .txt file of employee data into the machine.
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?
@@HiltonPereira Sorry, I don't understand your language in question.
this is fake machine i am use signed In only but not Signed Out Option
@@Dino_Panda_Rexal Thank you for your comment. I'm not sure about your machine. Please find another solution in Google or ChatGPT.
in video show signed In but where is the Signed Out Option?
@@Dino_Panda_Rexal After sign in, it will switch to sign out option.
too fast
@JohnCastiglione-p6u You can decrease speed on UA-cam screen.
Hello, i just wanted to ask how to edit the login time?
@@angeladatu2839 Go to SETUP function, with this can edit anything.
Man, il sub to you with all my like 20 acc when i get on pc.
@@iamin9688 Thank you so much 😁
Thank you man!! You saved me <3 gg
@@iamin9688 Cheers 🍻
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.
@@k.chriscaldwell4141 Thank you so much for your shared knowledge... so appreciated.
can you give me a copy of bin file of megaman 8?
@@elbertsamuelmiranda1246 Please see and learn from my this clip: ua-cam.com/video/9VPF3pi4xMk/v-deo.htmlsi=lsR55Hy4-T2oQ15g
What was even the point of this
@susanseymour8789 See the "Know How" link in the description.
thank you ...working ...i recover my access db password .
Enjoy 😁
why is it always signed in but doesn't have signed out
@@lazarus4188 Sorry, I don't understand your question.
@@primomgt1 everytime we put our finger only signed in
@@primomgt1 there's no signed out
@@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?
@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.
jaise muje morng me 9:20 ke andr sabhi staff ki attendence set krna h uske liye kya krna hoga
@@manishjaiswal7456 Sorry, I don't understand your language.
tu linck ya no sirve
@@briancidtrejo626 Thank you...
ขาย เท่าไหร่ครับ
@@PansakPoppond 5.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