{"id":126,"date":"2020-09-24T12:08:47","date_gmt":"2020-09-24T05:08:47","guid":{"rendered":"http:\/\/blog.jandi.com\/vn\/?p=126"},"modified":"2020-09-25T15:14:28","modified_gmt":"2020-09-25T08:14:28","slug":"quan-ly-cham-cong-bang-jandi","status":"publish","type":"post","link":"https:\/\/blog.jandi.com\/vn\/2020\/09\/quan-ly-cham-cong-bang-jandi\/","title":{"rendered":"Qu\u1ea3n l\u00fd ch\u1ea5m c\u00f4ng b\u1eb1ng JANDI"},"content":{"rendered":"

T\u00f4i c\u00f3 th\u1ec3 xu\u1ea5t tin nh\u1eafn JANDI c\u1ee7a m\u00ecnh kh\u00f4ng?
\n<\/b><\/p><\/blockquote>\n

Ch\u00fang t\u00f4i nh\u1eadn \u0111\u01b0\u1ee3c c\u00e2u h\u1ecfi n\u00e0y r\u1ea5t nhi\u1ec1u. May m\u1eafn thay, m\u1ed9t trong nh\u1eefng ng\u01b0\u1eddi d\u00f9ng JANDI c\u1ee7a ch\u00fang t\u00f4i \u0111\u00e3 chia s\u1ebb c\u00e2u tr\u1ea3 l\u1eddi!<\/p>\n

\u0110\u00e2y l\u00e0 m\u1ed9t v\u00ed d\u1ee5 v\u1ec1 xu\u1ea5t th\u00f4ng b\u00e1o tr\u00ean JANDI: Chia s\u1ebb th\u00f4ng b\u00e1o JANDI l\u00ean Google B\u1ea3ng t\u00ednh ngay l\u1eadp t\u1ee9c. B\u1eb1ng c\u00e1ch n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ghi ch\u00fa l\u1ea1i khi b\u1ea1n \u0111\u1ebfn v\u00e0 r\u1eddi kh\u1ecfi v\u0103n ph\u00f2ng m\u1ed7i ng\u00e0y.<\/p>\n

<Ghi l\u1ea1i Gi\u1edd l\u00e0m vi\u1ec7c tr\u00ean Google Trang t\u00ednh qua JANDI>
\n<\/b><\/p>\n

\"\"<\/p>\n

1. C\u00e1ch thi\u1ebft l\u1eadp B\u1ea3ng t\u00ednh Google (Google Spreadsheet)<\/strong><\/h3>\n

1-1)\u00a0 T\u1ea1o B\u1ea3ng t\u00ednh Google m\u1edbi v\u00e0 \u0111i t\u1edbi [Tools – C\u00f4ng c\u1ee5] – [Script Editor- Tr\u00ecnh ch\u1ec9nh s\u1eeda t\u1eadp l\u1ec7nh]<\/b><\/p>\n

\"\"<\/p>\n

 <\/p>\n

1-2) X\u00f3a t\u1ea5t c\u1ea3 n\u1ed9i dung tr\u01b0\u1edbc \u0111\u00f3 v\u00e0 nh\u1eadp m\u00e3 sau.
\n<\/b><\/p>\n

\/\/See JANDI Post and Record on Google Sheet<\/b>\r\nvar XLS_SHEET_NAME = \"Sheet1\";\r\nvar XLS_SCRIPT_PROP = PropertiesService.getScriptProperties();\r\n\r\nfunction doPost(e) {\r\nvar sheet = SpreadsheetApp.getActiveSheet();\r\nvar jsonString = e.postData.getDataAsString();\r\nvar jsonData = JSON.parse(jsonString);\r\nvar requestString = jsonData.data;\r\nvar today = new Date();\r\nvar name = requestString.split('\"')[1]\/\/Note: Use separators to export information (e.g. Name, Period)<\/b>\r\nvar period = requestString.split('^')[1]\r\n\r\nsheet.appendRow([today, requestString, name]);\/\/Add in the order entered in the last row. \r\n\/\/If you do not need the name and period using the separator, you can delete it.<\/b>\r\n}\r\n\r\nfunction doGet() {\r\n}\r\n\r\nfunction setup() {\r\nvar doc = SpreadsheetApp.getActiveSpreadsheet();\r\nXLS_SCRIPT_PROP.setProperty(\"key\", doc.getId());\r\n}<\/pre>\n
 <\/p>\n
1-3) Thay \u0111\u1ed5i h\u00e0ng \u0111\u1ea7u ti\u00ean th\u00e0nh t\u00ean trang t\u00ednh v\u00e0 l\u01b0u (Ctrl + S).<\/b><\/p>\n
\"\"<\/p>\n
 <\/p>\n
1-4) Ch\u1ecdn setup and \u25ba run.<\/b><\/p>\n
\"\"<\/p>\n
1-5)\u00a0 Ch\u1ecdn [Deploy as a Web App].\u00a0<\/b><\/p>\n
\"\"<\/p>\n
    \n
  1. T\u1ea1o m\u1edbi (Create New):<\/strong> Nh\u1eadp b\u1ea5t k\u1ef3 th\u1ee9 g\u00ec b\u1ea1n mu\u1ed1n (Sau khi l\u01b0u, ghi b\u1eb1ng s\u1ed1). N\u1ebfu b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda sau \u0111\u00f3, h\u00e3y lu\u00f4n ch\u1ecdn ‘T\u1ea1o m\u1edbi’ \u0111\u1ec3 ph\u1ea3n \u00e1nh c\u00e1c thay \u0111\u1ed5i.<\/li>\n
  2. T\u00f4i (t\u00e0i kho\u1ea3n email c\u1ee7a t\u00f4i) <\/strong>: Ch\u1ec9 \u0111\u1ecbnh T\u00f4i (Me) l\u00e0m tr\u00ecnh \u0111i\u1ec1u khi\u1ec3n \u1ee9ng d\u1ee5ng (App driver).<\/li>\n
  3.  B\u1ea5t k\u1ef3 ai, k\u1ec3 c\u1ea3 \u1ea9n danh (Anyone, even anonymous) <\/strong>: \u0110\u1ea3m b\u1ea3o m\u1edf d\u1eef li\u1ec7u \u0111\u1ec3 b\u1ea5t k\u1ef3 ai c\u0169ng c\u00f3 th\u1ec3 truy c\u1eadp.<\/li>\n<\/ol>\n
    \"\"<\/a>\"\" \"\"<\/p>\n
    1-6) Sao ch\u00e9p URL \u1ee9ng d\u1ee5ng web hi\u1ec7n t\u1ea1i<\/b><\/p>\n
    \"\"<\/p>\n
    C\u00e0i \u0111\u1eb7t Google Trang t\u00ednh c\u1ee7a b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t! Quay l\u1ea1i JANDI n\u00e0o.<\/p>\n
     <\/p>\n
    2. T\u1ea1o m\u1ed9t Outgoing Webhook trong\u00a0 JANDI Connect<\/strong><\/h3>\n
    2-1) Ch\u1ecdn bi\u1ec3u t\u01b0\u1ee3ng JANDI Connect trong ch\u1ee7 \u0111\u1ec1 b\u1ea1n mu\u1ed1n k\u1ebft n\u1ed1i v\u1edbi Google Sheet. Sau \u0111\u00f3 ch\u1ecdn [Th\u00eam t\u00edch h\u1ee3p -Add Integration] \u0111\u1ec3 v\u00e0o Outgoing Webhook.\u00a0<\/b>\"\"<\/a><\/p>\n
    \"\"<\/p>\n
    2-2) Ch\u1ecdn [Th\u00eam t\u00edch h\u1ee3p – Save Integration] \u0111\u1ec3 ho\u00e0n t\u1ea5t\u00a0 JANDI Connect.<\/b><\/p>\n