{"id":286,"date":"2025-10-29T07:28:37","date_gmt":"2025-10-29T00:28:37","guid":{"rendered":"https:\/\/namns.i234.me\/ns\/?p=286"},"modified":"2026-05-21T09:56:34","modified_gmt":"2026-05-21T02:56:34","slug":"tao-quan-ly-van-ban-ca-nhan-bang-google-sheet-va-appsheet","status":"publish","type":"post","link":"https:\/\/namns.i234.me\/ns\/tao-quan-ly-van-ban-ca-nhan-bang-google-sheet-va-appsheet\/","title":{"rendered":"T\u1ea1o qu\u1ea3n l\u00fd v\u0103n b\u1ea3n c\u00e1 nh\u00e2n b\u1eb1ng google sheet v\u00e0 appsheet"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>\u01afu \u0111i\u1ec3m:\n<ul class=\"wp-block-list\">\n<li>D\u1ec5 tri\u1ec3n khai, ho\u1ea1t \u0111\u1ed9ng t\u1ed1t, \u1ed5n \u0111\u1ecbnh<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Nh\u01b0\u1ee3c \u0111i\u1ec3m:\n<ul class=\"wp-block-list\">\n<li>Appsheet ch\u1ec9 s\u1eed d\u1ee5ng \u0111c t\u1ed1i \u0111a 10 thi\u1ebft b\u1ecb, sau \u0111\u00f3 l\u00e0 ph\u1ea3i tr\u1ea3 ph\u00ed. Nh\u01b0 v\u1eady ch\u1ec9 l\u00e0m cho c\u00e1 nh\u00e2n t\u00ecm ki\u1ebfm t\u00e0i li\u1ec7u &#8211; th\u00ec \u1ed5n.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>N\u1ed9i dung: \n<ul class=\"wp-block-list\">\n<li>Qu\u1ea3n l\u00fd v\u0103n b\u1ea3n \u0111i &#8211; \u0111\u1ebfn &#8211; n\u1ed9i b\u1ed9<\/li>\n\n\n\n<li>Hi\u1ec3n th\u1ecb d\u1ec5 d\u00e0ng<\/li>\n\n\n\n<li>Upload \u0111c tr\u00ean c\u1ea3 di \u0111\u1ed9ng v\u00e0 m\u00e1y t\u00ednh<\/li>\n\n\n\n<li>D\u1ec5 t\u00ecm ki\u1ebfm<\/li>\n\n\n\n<li>C\u00f3 passcode khi nh\u1eadp v\u1edbi t\u00e0i li\u1ec7u \u0111\u1eb7c bi\u1ec7t<\/li>\n\n\n\n<li>&#8230;<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-b40edf4b-c2aa-4dd3-9daf-3c0cd6a60671\" href=\"https:\/\/namns.i234.me\/ns\/wp-content\/uploads\/2025\/10\/qlvb_full_v3_appscript.zip\">qlvb_full_v3_appscript<\/a><a href=\"https:\/\/namns.i234.me\/ns\/wp-content\/uploads\/2025\/10\/qlvb_full_v3_appscript.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-b40edf4b-c2aa-4dd3-9daf-3c0cd6a60671\">Download<\/a><\/div>\n\n\n\n<p>Trong file c\u00f3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>Code.gs<\/code><\/li>\n\n\n\n<li><code>Index.html<\/code><\/li>\n\n\n\n<li><code>README.txt<\/code><\/li>\n<\/ul>\n\n\n\n<p>B\u1ea3n n\u00e0y g\u1ed3m: t\u1ef1 sinh s\u1ed1 \u0111\u1ebfn\/s\u1ed1 \u0111i theo n\u0103m, ph\u00e2n quy\u1ec1n, lu\u1ed3ng x\u1eed l\u00fd, nh\u1eafc h\u1ea1n email, xu\u1ea5t Excel\/PDF, in phi\u1ebfu tr\u00ecnh, nh\u1eadt k\u00fd, danh m\u1ee5c m\u00e0u s\u1eafc, t\u00ecm ki\u1ebfm nhanh, xem file kh\u00f4ng c\u1ea7n t\u1ea3i, chia s\u1ebb link, l\u01b0\u1edbi\/danh s\u00e1ch, c\u1ea5u h\u00ecnh font\/m\u00e0u\/giao di\u1ec7n trong Google Sheet.<\/p>\n\n\n\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-f6905f5c-eaf5-4423-b32f-fe9bc558bb7d\" href=\"https:\/\/namns.i234.me\/ns\/wp-content\/uploads\/2025\/10\/qlvb_full_v4_appscript.zip\">qlvb_full_v4_appscript<\/a><a href=\"https:\/\/namns.i234.me\/ns\/wp-content\/uploads\/2025\/10\/qlvb_full_v4_appscript.zip\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-f6905f5c-eaf5-4423-b32f-fe9bc558bb7d\">Download<\/a><\/div>\n\n\n\n<p>C\u1eacP NH\u1eacT V4 &#8211; T\u00f3m t\u1eaft thay \u0111\u1ed5i:<\/p>\n\n\n\n<p>1) CLICK \u00d4 TH\u1ed0NG K\u00ca \u2192 L\u1eccC DANH S\u00c1CH<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>B\u1ea5m v\u00e0o \u00f4 &#8220;T\u1ed5ng t\u00e0i li\u1ec7u \/ V\u0103n b\u1ea3n \u0111\u1ebfn \/ V\u0103n b\u1ea3n \u0111i \/ H\u1ee3p \u0111\u1ed3ng \/ G\u1ea7n h\u1ebft h\u1ea1n \/ H\u1ebft hi\u1ec7u l\u1ef1c&#8221;<br>s\u1ebd t\u1ef1 l\u1ecdc danh s\u00e1ch t\u01b0\u01a1ng \u1ee9ng, cu\u1ed9n xu\u1ed1ng danh s\u00e1ch, hi\u1ec7n banner &#8220;\u0110ang xem: \u2026&#8221;<\/li>\n\n\n\n<li>B\u1ea5m &#8220;X\u00f3a l\u1ecdc&#8221; ho\u1eb7c \u00f4 &#8220;T\u1ed5ng t\u00e0i li\u1ec7u&#8221; \u0111\u1ec3 xem l\u1ea1i to\u00e0n b\u1ed9.<\/li>\n\n\n\n<li>B\u1ea5m tab &#8220;Danh s\u00e1ch&#8221; c\u0169ng s\u1ebd cu\u1ed9n v\u1ec1 ph\u1ea7n danh s\u00e1ch.<\/li>\n<\/ul>\n\n\n\n<p>2) GIAO DI\u1ec6N RESPONSIVE<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>T\u1ef1 co theo 3 ng\u01b0\u1ee1ng: desktop (>1100px), tablet (700-1100px), mobile (&lt;700px), mobile nh\u1ecf (&lt;380px).<\/li>\n\n\n\n<li>\u00d4 th\u1ed1ng k\u00ea: 6 c\u1ed9t (desktop) \u2192 3 (tablet) \u2192 2 (mobile).<\/li>\n\n\n\n<li>Form, b\u1ed9 l\u1ecdc, n\u00fat thao t\u00e1c t\u1ef1 xu\u1ed1ng d\u00f2ng, kh\u00f4ng tr\u00e0n.<\/li>\n\n\n\n<li>B\u1ea3ng t\u00e0i li\u1ec7u c\u00f3 scroll ngang m\u01b0\u1ee3t tr\u00ean \u0111i\u1ec7n tho\u1ea1i.<\/li>\n<\/ul>\n\n\n\n<p>3) QUY\u1ec0N C\u00d4NG C\u1ed8NG (PUBLIC)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Th\u00eam kh\u00f3a c\u1ea5u h\u00ecnh m\u1edbi trong sheet CAU_HINH:<br>PUBLIC_ACCESS = TRUE \u2192 b\u1ea5t k\u1ef3 ai m\u1edf link webapp \u0111\u1ec1u xem &amp; t\u00ecm ki\u1ebfm \u0111\u01b0\u1ee3c (CH\u1ec8 \u0110\u1eccC).<br>PUBLIC_ACCESS = FALSE \u2192 ch\u1ec9 ng\u01b0\u1eddi c\u00f3 trong sheet NGUOI_DUNG m\u1edbi truy c\u1eadp (m\u1eb7c \u0111\u1ecbnh).<\/li>\n\n\n\n<li>Ng\u01b0\u1eddi d\u00f9ng c\u00f4ng c\u1ed9ng s\u1ebd hi\u1ec3n th\u1ecb nh\u00e3n xanh &#8220;C\u00d4NG C\u1ed8NG &#8211; Ch\u1ebf \u0111\u1ed9 ch\u1ec9 \u0111\u1ecdc&#8221;.<\/li>\n\n\n\n<li>C\u00e1c n\u00fat Th\u00eam \/ S\u1eeda \/ X\u00f3a \/ Xu\u1ea5t Excel\/PDF \/ Nh\u1eafc h\u1ea1n \/ Qu\u1ea3n l\u00fd danh m\u1ee5c s\u1ebd t\u1ef1 \u1ea9n v\u1edbi public.<\/li>\n\n\n\n<li>Khi tri\u1ec3n khai (Deploy): ch\u1ecdn &#8220;Who has access: Anyone&#8221; ho\u1eb7c &#8220;Anyone with the link&#8221;<br>\u0111\u1ec3 kh\u00e1ch b\u00ean ngo\u00e0i t\u1ed5 ch\u1ee9c c\u00f3 th\u1ec3 v\u00e0o. N\u1ebfu ch\u1ec9 trong t\u1ed5 ch\u1ee9c, v\u1eabn c\u1ea7n PUBLIC_ACCESS=TRUE<br>\u0111\u1ec3 c\u00e1c t\u00e0i kho\u1ea3n ch\u01b0a \u0111\u01b0\u1ee3c ph\u00e2n quy\u1ec1n v\u1eabn xem \u0111\u01b0\u1ee3c.<\/li>\n<\/ul>\n\n\n\n<p>C\u00c1CH C\u1eacP NH\u1eacT T\u1eea V3:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>M\u1edf Apps Script c\u1ee7a Sheet hi\u1ec7n t\u1ea1i.<\/li>\n\n\n\n<li>Thay to\u00e0n b\u1ed9 n\u1ed9i dung Code.gs v\u00e0 Index.html b\u1eb1ng file m\u1edbi.<\/li>\n\n\n\n<li>B\u1ea5m L\u01b0u \u2192 Ch\u1ea1y l\u1ea1i h\u00e0m setup() m\u1ed9t l\u1ea7n \u0111\u1ec3 b\u1ed5 sung kh\u00f3a PUBLIC_ACCESS v\u00e0o sheet CAU_HINH.<\/li>\n\n\n\n<li>V\u00e0o sheet CAU_HINH \u0111\u1eb7t PUBLIC_ACCESS = TRUE n\u1ebfu mu\u1ed1n b\u1eadt c\u00f4ng c\u1ed9ng.<\/li>\n\n\n\n<li>Tri\u1ec3n khai l\u1ea1i (Deploy \u2192 Manage deployments \u2192 New version).<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong file c\u00f3: B\u1ea3n n\u00e0y g\u1ed3m: t\u1ef1 sinh s\u1ed1 \u0111\u1ebfn\/s\u1ed1 \u0111i theo n\u0103m, ph\u00e2n quy\u1ec1n, lu\u1ed3ng x\u1eed l\u00fd, nh\u1eafc h\u1ea1n email, xu\u1ea5t Excel\/PDF, in phi\u1ebfu tr\u00ecnh, nh\u1eadt k\u00fd, danh m\u1ee5c m\u00e0u s\u1eafc, t\u00ecm ki\u1ebfm nhanh, xem file kh\u00f4ng c\u1ea7n t\u1ea3i, chia s\u1ebb link, l\u01b0\u1edbi\/danh s\u00e1ch, c\u1ea5u h\u00ecnh font\/m\u00e0u\/giao di\u1ec7n trong Google Sheet. C\u1eacP NH\u1eacT V4&#8230;<\/p>\n","protected":false},"author":1,"featured_media":288,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,2,5],"tags":[],"class_list":["post-286","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pc","category-thu-thuat","category-web"],"jetpack_featured_media_url":"https:\/\/namns.i234.me\/ns\/wp-content\/uploads\/2025\/10\/czNmcy1wcml2YXRlL3Jhd3BpeGVsX2ltYWdlcy93ZWJzaXRlX2NvbnRlbnQvam9iNjcwLTAwMjQteC5qcGc.webp","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts\/286","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/comments?post=286"}],"version-history":[{"count":4,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts\/286\/revisions"}],"predecessor-version":[{"id":536,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/posts\/286\/revisions\/536"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/media\/288"}],"wp:attachment":[{"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/media?parent=286"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/categories?post=286"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namns.i234.me\/ns\/wp-json\/wp\/v2\/tags?post=286"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}