{"id":10498,"date":"2023-04-20T23:07:17","date_gmt":"2023-04-20T17:37:17","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=10498"},"modified":"2023-04-20T23:07:21","modified_gmt":"2023-04-20T17:37:21","slug":"search-html-invoice-google-sheet-apps-script","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/search-html-invoice-google-sheet-apps-script\/","title":{"rendered":"Effortlessly Search HTML Invoices from Google Sheet with Apps Script"},"content":{"rendered":"\n<p>In this tutorial, you will learn how to create an HTML invoice that can search for relevant records in a Google Sheet using Apps Script and JavaScript. This tutorial covers the steps to create a search button that retrieves data from a Google Sheet and displays it on the invoice.<\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/BunOO__Ftk0\" target=\"_blank\" rel=\"noopener\">Related Video : HTML Invoice Search From Google Sheet Using Apps Script<\/a><\/p>\n\n\n\n<p>\u0939\u092e \u0907\u0938 Article \u0938\u0947 \u0938\u0940\u0916\u0947\u0902\u0917\u0947 \u0915\u0940 \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0906\u092a HTML Invoice \u092a\u0930 \u091c\u093f\u0938 \u092d\u0940 Invoice \u0915\u093e Number Type \u0915\u0930\u0947\u0902\u0917\u0947 \u0914\u0930 \u0938\u0930\u094d\u091a \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b \u0909\u0938 Invoice \u0915\u093e Data Google Sheet \u0938\u0947 Apps Script \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e HTML \u092a\u0930 Invoice \u092a\u0930 \u0915\u0948\u0938\u0947 Set \u0915\u093f\u092f\u093e \u091c\u093e\u090f \u0964 <\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#google-sheet-data-search-will-be-done-from-here\">Google Sheet : Data search will be done from here<\/a><\/li><li><a href=\"#html-invoice\">HTML Invoice <\/a><\/li><li><a href=\"#step-1-apps-script-code-for-getting-records\">Step 1 : Apps Script Code for Getting Records<\/a><\/li><li><a href=\"#step-2-html-code-for-search-icon\">Step 2 : HTML Code For Search Icon<\/a><\/li><li><a href=\"#step-3-java-script-code-for-set-result-on-html\">Step 3 : JavaScript Code For Set Result on HTML<\/a><\/li><li><a href=\"#\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"google-sheet-data-search-will-be-done-from-here\">Google Sheet : Data search will be done from here<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 Google Sheet \u0915\u093e Data \u0939\u092e\u0947 \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u092f\u0939 Google Sheet \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0907\u0938 Sheet \u0915\u093e \u0928\u093e\u092e Inv \u0939\u0948\u0902 \u091c\u092c \u0939\u092e Apps Script Coding \u0915\u0947 \u0938\u092e\u092f Sheet \u0938\u0947 Data Pick \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u092c \u0907\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"401\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-5.png?resize=640%2C401&#038;ssl=1\" alt=\"Google Sheet\" class=\"wp-image-10840\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-5.png?resize=1024%2C642&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-5.png?resize=300%2C188&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-5.png?resize=768%2C481&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-5.png?resize=150%2C94&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-5.png?w=1449&amp;ssl=1 1449w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-5.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"html-invoice\">HTML Invoice <\/h2>\n\n\n\n<p>\u0907\u0938\u092e\u0947 Inv. No. \u092a\u0930 Invoice Number Type \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u091c\u092c \u0906\u092a Search Button Press \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u092c JavaScript Function call \u0939\u094b\u0917\u093e \u0914\u0930 Apps Script \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Google Sheet \u0938\u0947 data \u0932\u093e \u0915\u0930 \u0907\u0938\u0940 Invoice \u092a\u0930 Display \u0915\u0930 \u0926\u0947\u0917\u093e\u0964   <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/complete-invoice-with-calculation\/\">HTML Bootstrap \u0915\u0940 \u092f\u0939 \u0907\u0928\u094d\u0935\u093e\u0907\u0938 \u092c\u0928\u093e\u0928\u093e \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/submit-html-form-to-google-sheet\/\">\u0907\u0938 Invoice \u0915\u0947 Data \u0915\u094b Google Sheet \u092a\u0930 Upload \u0915\u0930\u0928\u093e \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f  \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/submit-html-form-to-google-sheet\/\">Google Sheet \u0938\u0947 Invoice \u0915\u0940 Dropdown \u092e\u0947 data \u0932\u093e\u0928\u093e \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/next-invoice-number-html-apps-script\/\">Automatic Next Invoice Number Generate \u0915\u0930\u0928\u093e \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/bootstrap-invoice-validation\/\">Bootstrap Invoice Validation \u0932\u0917\u093e\u0928\u093e \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/a><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=640%2C333&#038;ssl=1\" alt=\"HTML Invoice\" class=\"wp-image-10841\" width=\"640\" height=\"333\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=1024%2C533&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=300%2C157&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=768%2C400&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=1536%2C800&amp;ssl=1 1536w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=220%2C115&amp;ssl=1 220w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=140%2C73&amp;ssl=1 140w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=620%2C324&amp;ssl=1 620w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?resize=150%2C78&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?w=1692&amp;ssl=1 1692w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-6.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>\u091a\u0932\u093f\u090f \u0905\u092c \u0939\u092e Step by Step \u0938\u0940\u0916\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-1-apps-script-code-for-getting-records\">Step 1 : Apps Script Code for Getting Records<\/h2>\n\n\n\n<p>\u092f\u0939 Apps Script \u0915\u093e Code \u0939\u0948\u0902 \u0964 \u0907\u0938 Code \u0915\u094b \u0906\u092a\u0915\u094b Apps Script Editor \u092e\u0947 Paste \u0915\u0930\u0928\u093e \u0939\u0948 \u0914\u0930 \u0907\u0938\u0915\u094b Deploy \u0915\u0930 Deployment \u0915\u0940 \u0932\u093f\u0902\u0915 \u092c\u0928\u093e \u0915\u0930 JavaScript \u092e\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/deploying-apps-script-as-a-web-api\/\">Apps Script Deploy \u0915\u0930\u0928\u0947 \u0915\u0940 Process \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/a><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">let MySheets = SpreadsheetApp.getActiveSpreadsheet();      \/\/01\nlet InvSheet = MySheets.getSheetByName(\"Inv\");             \/\/02\nfunction doGet(e) {                                        \/\/03\n  let page = e.parameter.page;                             \/\/04\n  if (page == 'search')                                    \/\/05\n  {\n      let no = e.parameter.no;                             \/\/06  \n      let ReturnData = InvSheet.getRange(\"A:A\").createTextFinder(no).matchEntireCell(true).findAll();\n                                                           \/\/07\n      let StartRow=0;\n      let EndRow=0;\n\n      ReturnData.forEach(function (range) {                \/\/08 \n        StartRow = range.getRow();                         \/\/09\n      });\n\n      if (StartRow &gt; 0) {                                  \/\/10\n         for (var i = StartRow + 1; i &lt;= StartRow + 10; i = i + 1) { \/\/11\n             let val = InvSheet.getRange(i, 6).getValue(); \/\/12\n             if (val == \"\") {                              \/\/13\n                 EndRow = i - 1;                           \/\/14\n                 break;\n             }\n         }\n  \n         let table = InvSheet.getRange(\"A\"+StartRow+\":I\"+EndRow).getValues(); \n                                                           \/\/15\n         let str = JSON.stringify(table);                  \/\/16 \n         return ContentService.createTextOutput(str);      \/\/17\n     }\n     else {\n         let str = JSON.stringify(\"NOT FOUND\");            \/\/18 \n         return ContentService.createTextOutput(str);      \/\/19\n     }\n  }\n}<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>01: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947&nbsp; \u090f\u0915\u094d\u091f\u093f\u0935 \u0917\u0942\u0917\u0932&nbsp; \u0936\u0940\u091f \u0915\u094b \u090f\u0915 \u0935\u0947\u0930\u093f\u090f\u092c\u0932 MySheets \u092e\u0947\u0902 \u0938\u0947\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0964&nbsp;<\/li>\n\n\n\n<li>02: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 MySheets \u0938\u0947 \u092a\u0939\u0932\u0947 \u0935\u093e\u0932\u0940 \u0936\u0940\u091f \u201cInv\u201d \u0915\u094b \u090f\u0915 \u0935\u0947\u0930\u0940\u0905\u092c\u0932 InvSheet \u092e\u0947 \u0938\u0947\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964&nbsp;<\/li>\n\n\n\n<li>03: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 doget \u092b\u0902\u0915\u094d\u0936\u0928 \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0964&nbsp;<\/li>\n\n\n\n<li>04: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 Page Parameter \u0915\u0940 value \u0915\u094b get \u0915\u093f\u092f\u093e \u0939\u0948\u0902\u0964 \u091c\u094b \u0915\u0940 \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e javascript \u0938\u0947 pass \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0925\u093e \u0964&nbsp;<\/li>\n\n\n\n<li>05: \u0906\u092a \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 Page variable \u0938\u0947 \u0915\u0902\u0921\u0940\u0936\u0928 \u091a\u0947\u0915 \u0915\u0940 \u0939\u0948\u0902 \u0939\u092e\u0928\u0947 Javascript \u0938\u0947 Search pass \u0915\u093f\u092f\u093e \u0925\u093e \u0909\u0938\u0947 \u091a\u0947\u0915 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964&nbsp;<\/li>\n\n\n\n<li>06: \u092f\u0939\u093e \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b \u090f\u0915 \u0914\u0930 Parameter Pass \u0915\u093f\u092f\u093e \u0925\u093e NO \u0909\u0938\u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u090f\u0915 Variable \u092e\u0947 get \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964&nbsp;<\/li>\n\n\n\n<li>07: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b \u0906\u092a \u0928\u0902\u092c\u0930 \u092a\u093e\u0938 \u0915\u0930\u0947\u0902\u0917\u0947 \u0909\u0938 \u092a\u093e\u0938 \u0915\u093f\u090f \u0939\u0941\u090f \u0928\u0902\u092c\u0930 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u091f\u0948\u0915\u094d\u0938 \u092b\u093e\u0907\u0902\u0921\u0930 \u092c\u0928\u093e\u092f\u093e \u0939\u0948 \u091c\u094b \u091c\u093f\u0938\u092e\u0947\u0902 \u091c\u094b \u0928\u0902\u092c\u0930 \u0939\u092e \u0926\u0947\u0902\u0917\u0947 \u0909\u0938 \u0938\u0947 \u0930\u093f\u0932\u0947\u091f\u0947\u0921 \u091c\u094b \u092d\u0940 \u0921\u093e\u091f\u093e \u0939\u094b\u0917\u093e \u0935\u0939 \u0939\u092e\u0947\u0902 \u092f\u0939\u093e\u0902 \u092a\u0930 \u0906\u0915\u0930 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e \u0914\u0930 \u091c\u094b \u0939\u092e \u0938\u0930\u094d\u091a \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0935\u0939 \u092a\u0942\u0930\u0940 \u0930\u0947\u0902\u091c \u092e\u0947\u0902 \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e\u0928\u0947 \u092f\u0939\u093e\u0902 \u092a\u0930 \u092a\u0939\u0932\u0947 \u0935\u093e\u0932\u0947 \u0915\u0949\u0932\u092e \u092e\u0947\u0902 \u0935\u0939 \u0921\u093e\u091f\u093e \u0915\u094b \u0938\u0930\u094d\u091a \u0915\u0930\u0947\u0917\u093e \u0914\u0930 \u091c\u094b \u092d\u0940 \u0938\u0930\u094d\u091a \u0939\u094b\u0917\u093e \u0935\u0939 \u0930\u093f\u091f\u0930\u094d\u0928 \u0921\u093e\u091f\u093e \u0935\u093e\u0932\u0947 \u0935\u0947\u0930\u093f\u090f\u092c\u0932 \u092e\u0947\u0902 \u0906 \u091c\u093e\u090f\u0917\u093e\u0964&nbsp;<\/li>\n\n\n\n<li>08: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b \u0930\u093f\u091f\u0930\u094d\u0928 \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u0948 \u0909\u0938 \u092a\u0930 \u090f\u0915 \u0932\u0942\u092a \u0932\u0917\u093e\u092f\u093e \u0939\u0948 \u0935\u0948\u0938\u0947 \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0947\u0936\u093e \u0938\u093f\u0902\u0917\u0932 \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u0940 \u0930\u093f\u091f\u0930\u094d\u0928 \u0939\u094b\u0917\u0940 \u090f\u0915 \u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0935\u0948\u0932\u094d\u092f\u0942 \u092d\u0940 \u0930\u093f\u091f\u0930\u094d\u0928 \u0939\u0941\u0908 \u0924\u094b \u092c\u093e\u0926 \u0935\u093e\u0932\u0947 \u0915\u094b \u092f\u0939 \u092e\u093e\u0928\u0947\u0917\u093e \u0914\u0930 \u0909\u0938\u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u0939\u092e\u0947\u0902 \u0930\u093f\u091f\u0930\u094d\u0928 \u0915\u0930 \u0926\u0947\u0917\u093e \u0964&nbsp;<\/li>\n\n\n\n<li>09: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0947\u0902 \u091c\u094b Rang \u0906\u090f\u0917\u0940 \u0909\u0938\u0915\u0940 Row \u0915\u093e Serial Number&nbsp; \u092e\u093f\u0932 \u091c\u093e\u090f\u0917\u093e<\/li>\n\n\n\n<li>10: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 \u0915\u0902\u0921\u0940\u0936\u0928 \u0932\u0917\u093e\u0908 \u0939\u0948 \u0915\u093f \u092f\u0926\u093f \u0939\u092e\u0947\u0902 StartRow 0 \u091c\u0940\u0930\u094b \u0938\u0947 \u092c\u0921\u093c\u0940 \u0939\u094b \u0924\u094b \u092b\u093f\u0930 \u0906\u0917\u0947 \u0915\u0940 \u0938\u094d\u0915\u094d\u0930\u093f\u092a\u094d\u091f \u090f\u0917\u094d\u091c\u0940\u0915\u094d\u092f\u0942\u091f \u0939\u094b\u0917\u0940<\/li>\n\n\n\n<li>11: \u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 \u090f\u0915 StartRow&nbsp; \u0938\u0947 \u090f\u0915 \u0932\u0942\u092a StartRows + 10 \u0924\u0915&nbsp; \u091a\u0932\u093e\u092f\u093e \u0939\u0948 \u0906\u092a \u091a\u093e\u0939\u0947 \u0924\u094b \u0907\u0938 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u092c\u0922\u093c\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964&nbsp;<\/li>\n\n\n\n<li>12: \u092f\u0939\u093e\u0902 \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b \u0939\u092e\u093e\u0930\u093e 6th \u0928\u0902\u092c\u0930 \u0915\u093e \u0915\u0949\u0932\u092e \u0939\u0948 \u0909\u0938\u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u090f\u0915 val&nbsp; \u0935\u0947\u0930\u093f\u090f\u092c\u0932 \u092e\u0947\u0902 \u0938\u0947\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0964&nbsp;<\/li>\n\n\n\n<li>13: \u091c\u092c \u0924\u0915 val \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u092e\u0948\u0902 \u0915\u0941\u091b \u092e\u093f\u0932\u0924\u093e \u0930\u0939\u0947\u0917\u093e \u091c\u092c \u0924\u0915 \u092f\u0939 \u0915\u0902\u091f\u093f\u0928\u094d\u092f\u0942 \u091a\u0932\u0924\u093e \u0930\u0939\u0947\u0917\u093e \u0914\u0930 \u091c\u0948\u0938\u0947 \u0939\u0940 val \u092c\u094d\u0932\u0948\u0902\u0915 \u092e\u093f\u0932\u0947\u0917\u093e \u0935\u0948\u0938\u0947 \u0939\u0940 \u0939\u092e \u0928\u093f\u092e\u094d\u0928 Condition \u092e\u0947 Enter \u0939\u094b \u091c\u093e\u090f\u0902\u0917\u0947\u0964&nbsp;<\/li>\n\n\n\n<li>14: \u092f\u0939\u093e \u092a\u0930 \u0939\u092e\u0928\u0947 EndRow \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0938\u0947\u091f \u0915\u0940 \u0939\u0948\u0902 \u0964 \u0939\u092e\u0947\u0902 \u092f\u0939\u093e\u0902 \u0924\u0915 \u0915\u093e \u0921\u093e\u091f\u093e \u0909\u0920\u093e\u0928\u093e \u0939\u0948 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u0907\u0938\u0947 -1 \u0915\u093f\u092f\u093e \u0939\u0948 \u0914\u0930 \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 \u0939\u092e \u0932\u0942\u092a \u0915\u094b \u092f\u0939\u093e\u0902 \u0938\u0947 \u092c\u094d\u0930\u0947\u0915 \u0915\u0930 \u0926\u0947\u0902\u0917\u0947 \u0964&nbsp;<\/li>\n\n\n\n<li>15: \u0939\u092e\u0928\u0947 \u091c\u094b \u0905\u092d\u0940 \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Code \u0932\u093f\u0916\u093e \u0939\u0948\u0902 \u0907\u0938\u0938\u0947 \u0939\u092e\u0947 StartRow \u0914\u0930 End Row \u092e\u093f\u0932 \u0917\u0908 \u0939\u0948\u0902 \u0907\u0938\u0915\u0947 \u0906\u0927\u093e\u0930 \u092a\u0930 \u0939\u092e A:I \u0924\u0915 \u0915\u0940 \u0930\u0947\u0902\u091c \u0915\u094b Table Variable \u092e\u0947 Set \u0915\u0930 \u0926\u0947\u0902\u0917\u0947\u0964&nbsp;<\/li>\n\n\n\n<li>16: \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u091c\u094b \u0935\u0948\u0932\u094d\u092f\u0942 Table&nbsp; \u092e\u0947\u0902 \u0906\u0908 \u0939\u0948 \u0909\u0938\u0947 JSON\u0964 stringify&nbsp; \u0915\u093f\u092f\u093e \u0914\u0930 STR&nbsp; \u0935\u0947\u0930\u093f\u090f\u092c\u0932 \u092e\u0947\u0902 \u0939\u092e\u0928\u0947 \u0909\u0938\u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b \u0932\u0947 \u0932\u093f\u092f\u093e\u0964&nbsp;<\/li>\n\n\n\n<li>17: \u0905\u092c \u091c\u094b \u0935\u0948\u0932\u094d\u092f\u0942 STR&nbsp; \u092e\u0947\u0902 \u0906\u0908 \u0925\u0940 \u0909\u0938\u0947 \u0939\u092e\u0928\u0947 \u0930\u093f\u091f\u0930\u094d\u0928 \u0915\u0930 \u0926\u093f\u092f\u093e\u0964&nbsp;<\/li>\n\n\n\n<li>18: \u092f\u0926\u093f Start Row 0 \u092e\u093f\u0932\u0947\u0917\u0940 \u0924\u092c str Variable \u092e\u0947 NOT FOUND \u0938\u0947\u091f \u0915\u0930 \u0926\u093f\u092f\u093e \u0939\u0948\u0902\u0964&nbsp;<\/li>\n\n\n\n<li>19: \u092f\u0939\u093e \u092a\u0930 \u0939\u092e\u0928\u0947 STR \u0915\u0940 Value \u0915\u094b \u0930\u093f\u091f\u0930\u094d\u0928 \u0915\u0930 \u0926\u093f\u092f\u093e \u0939\u0948\u0902 \u0964<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-2-html-code-for-search-icon\">Step 2 : HTML Code For Search Icon<\/h2>\n\n\n\n<p><strong>2.1 Add Font CND<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Search Icon \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u090f\u0915 Icons \u0915\u0940 CDN add \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 \u092f\u0939 Code \u0906\u092a\u0915\u094b head tag \u092e\u0947 \u0932\u093f\u0916\u0928\u093e \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"markup\" class=\"language-markup\">    &lt;link rel=\"stylesheet\" href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap-icons@1.3.0\/font\/bootstrap-icons.css\"&gt;\n<\/code><\/pre>\n\n\n\n<p><strong>2.2 Add Search Button<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0939\u092e\u0928\u0947 \u092a\u0939\u0932\u0947 \u0938\u0947 \u092c\u0928\u0947 Inv No \u0915\u0947 \u092c\u093e\u0926 \u092e\u0947 \u090f\u0915 button add \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 <\/li>\n\n\n\n<li>Button add \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u090f\u0915 button tag \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0914\u0930 Icon \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 i tag \u092e\u0947 bi bi-search class \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0938\u093e\u0925 \u0939\u0940 \u092e\u0947 \u0939\u092e\u0928\u0947 \u092f\u0939\u093e \u092a\u0930 button \u0915\u0947 onclick \u092a\u0930 search() function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"markup\" class=\"language-markup\">&lt;div class=\"input-group mb-3\"&gt;\n    &lt;span class=\"input-group-text\" &gt;Inv. No&lt;\/span&gt;\n    &lt;input type=\"text\" class=\"form-control\" placeholder=\"Inv. No\"  id=\"inv_no\" name=\"inv_no\" autocomplete=\"off\" required &gt;\n    &lt;div class=\"input-group-append\"&gt;\n       &lt;button class=\"btn btn-outline-secondary\" type=\"button\" onclick=\"Search();\"&gt;&lt;i class=\"bi bi-search\"&gt;&lt;\/i&gt;&lt;\/button&gt;\n    &lt;\/div&gt;\n    &lt;div class=\"valid-feedback\"&gt;Invoice No. is OK&lt;\/div&gt;\n&lt;\/div&gt;<\/code><\/pre>\n\n\n\n<p>Html \u0915\u093e Preview \u0915\u0941\u091b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e \u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-7.png?resize=297%2C45&#038;ssl=1\" alt=\"\" class=\"wp-image-10842\" width=\"297\" height=\"45\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-7.png?w=548&amp;ssl=1 548w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-7.png?resize=300%2C45&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/image-7.png?resize=150%2C23&amp;ssl=1 150w\" sizes=\"auto, (max-width: 297px) 100vw, 297px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"step-3-java-script-code-for-set-result-on-html\">Step 3 : JavaScript Code For Set Result on HTML<\/h2>\n\n\n\n<p>Search Button \u092a\u0930 \u091c\u094b \u0939\u092e\u0928\u0947 Search Function Call \u0915\u093f\u092f\u093e \u0925\u093e \u0935\u0939 Function \u092f\u0902\u0939\u093e \u092a\u0930 \u092c\u0928\u093e\u092f\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"javascript\" class=\"language-javascript\">function Search()\n{\n        var no = $('#inv_no').val();                      \/\/01\n        $.getJSON(\"https:\/\/script.google.com\/macros\/s\/\"+AppsScriptLink+\"\/exec?page=search&amp;no=\"+no, \n        function (data) {                                 \/\/02\n          if (data == \"NOT FOUND\") {                      \/\/03\n            alert('Invoice No. Not Found...');\n          }\n          else {                                          \/\/04\n            var record = data;\n            var i = 0;\n            $.each(record, function(key, value) {         \/\/05\n                  if (i == 0) {                           \/\/06\n                      var dt = value[1].substring(0,10);  \/\/07\n                      document.getElementsByName(\"inv_dt\")[0].value = dt;\n                      document.getElementsByName(\"inv_no\")[0].value = value[1];\n                      document.getElementsByName(\"cust_nm\")[0].value = value[2];\n                      document.getElementsByName(\"addr\")[0].value = value[3];\n                      document.getElementsByName(\"city\")[0].value = value[4];\n                  }\n                  else {                                  \/\/08  \n                       if (i &gt; 1) BtnAdd();               \/\/09\n                       document.getElementsByName(\"item_nm\")[i].value = value[5];                  \n                                                          \/\/10 \n                       document.getElementsByName(\"qty\")[i].value     = value[6];\n                       document.getElementsByName(\"rate\")[i].value    = value[7];\n                       document.getElementsByName(\"amt\")[i].value     = value[8];\n                  }\n                  i = i + 1;\n            });\n          }\n        });\n}<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>01: \u0907\u0938\u0938\u0947 \u0939\u092e\u0928\u0947 \u091c\u094b Invoice Number Type \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0909\u0938\u0947 Get \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>02: getJSON \u0938\u0947 \u0939\u092e \u091c\u094b Apps Script Project \u0915\u0940 \u0932\u093f\u0902\u0915 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0938\u0947 Data Return \u0939\u094b\u0924\u093e \u0939\u0948\u0902, \u0907\u0938\u092e\u0928\u0947 \u0939\u092e\u0928\u0947 Page \u092e\u0947 Search \u0914\u0930 no \u092a\u0930 invoice number \u092a\u0939\u0941\u091a\u093e\u092f\u093e \u0939\u0948\u0902 \u0964 \u091c\u093f\u0938\u0947 \u0939\u092e Apps script \u092e\u0947 read \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>03: \u092f\u0926\u093f \u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0915\u094b\u0908 \u0910\u0938\u093e Invoice No \u0926\u093f\u092f\u093e \u0917\u092f\u093e \u091c\u094b \u0915\u0940 Google Sheet \u092a\u0930 available \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 \u0924\u092c data \u092e\u0947 NOT FOUND return \u0939\u094b\u0917\u093e , \u0907\u0938\u0915\u0947 \u0906\u0927\u093e\u0930 \u092a\u0930 \u0939\u092e Invoice Not Found \u0915\u093e Message \u0926\u093f\u0916\u093e \u0926\u0947\u0902\u0917\u0947 \u0964 <\/li>\n\n\n\n<li>04: \u091c\u092c data variable \u092e\u0947 data \u0906\u090f\u0917\u093e \u0924\u092c \u0939\u092e \u0907\u0938 block \u092e\u0947 \u0932\u093f\u0916\u0947 Code Execute \u0939\u094b\u0902\u0917\u0947\u0964 <\/li>\n\n\n\n<li>05: data Rows \u0914\u0930 columns \u0915\u0947 form \u092e\u0947 \u0906\u0924\u093e \u0939\u0948\u0902 \u092f\u0939\u093e \u0938\u0947 \u0939\u092e\u0928\u0947 \u091c\u093f\u0924\u0928\u0940 \u092d\u0940 Rows \u0939\u0948\u0902 \u0909\u0928\u0915\u094b \u0905\u0932\u0917 &#8211; \u0905\u0932\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>06: \u092f\u0939\u093e \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b Header \u092e\u0947 Columns \u0939\u0948\u0902 \u0909\u0928\u0915\u0940 Condition \u0932\u0917\u093e \u0915\u0930 \u0909\u0928\u0915\u094b \u0938\u0947\u091f \u0915\u093f\u092f\u093e \u0939\u0948\u0902, \u091c\u094b \u092a\u0939\u0932\u0940 Rows Return \u0939\u094b\u0924\u0940 \u0939\u0948 \u0909\u0938\u092e\u0947 Header \u0915\u0947 Columns \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>07: \u092f\u0939\u093e \u092a\u0930 \u0939\u092e\u0928\u0947 \u091c\u094b \u092d\u0940 Rows \u0939\u092e\u0928\u0947 Get \u0939\u0941\u0908 \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 array \u092e\u093e\u0928 \u0915\u0930 \u0938\u092d\u0940 Header Column \u0915\u0940 Value \u0915\u094b \u0939\u092e\u0928\u0947 \u0938\u0947\u091f \u0915\u0930 \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>08: \u092a\u0939\u0932\u0940 Rows \u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u091c\u093f\u0924\u0928\u0940 \u092d\u0940 Rows \u0939\u0948\u0902 \u090a\u0928\u0915\u0947 Data \u0915\u094b \u0907\u0938 Block \u092e\u0947 Read \u0915\u093f\u092f\u093e \u091c\u093e\u090f\u0917\u093e \u0964 <\/li>\n\n\n\n<li>09: Table \u092e\u0947 \u090f\u0915 Row open \u0939\u094b\u0928\u0947 \u0913\u0930 Set \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 , \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 Condition \u0932\u0917\u093e\u0908 \u0939\u0948\u0902 \u0915\u0940 \u091c\u094b Detail \u0935\u093e\u0932\u093e Data Get \u0939\u094b \u0909\u0938\u092e\u0947 \u092a\u0939\u0932\u0940 Row \u092a\u0930 Rows Insert \u0928\u0939\u0940\u0902 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 Rows Insert \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f\u0964 <\/li>\n\n\n\n<li>10: \u091c\u0940\u0924\u0928\u0947 \u092d\u0940 Tables \u0915\u0947 columns \u0939\u094b \u0909\u0928\u0915\u094b \u0905\u092c \u090f\u0915 \u090f\u0915 \u0915\u0930 Set \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u0907\u0938 Article \u092e\u0947 \u0939\u092e\u0928\u0947 HTML Invoice Search From Google Sheet Using Apps Script  \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u092c\u0924\u093e\u092f\u093e \u0939\u0948\u0902 \u0906\u0936\u093e \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a\u0915\u094b \u092f\u0939 Article \u092c\u0939\u0941\u0924 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u092f\u093e \u0939\u094b\u0917\u093e\u0964<\/p>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e ? \u092c\u0924\u093e\u0928\u093e \u0928 \u092d\u0942\u0932\u0947, \u092e\u093f\u0932\u0924\u0947 \u0939\u0948\u0902 Next Article \u092e\u0947 Thanks for Reading \u0964<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how to create an HTML invoice that can search for relevant records in a Google Sheet using Apps Script and JavaScript. This tutorial covers the steps to create a search button that retrieves data from a Google Sheet and displays it on the invoice. Related Video : HTML Invoice [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":10901,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[28],"tags":[],"class_list":["post-10498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-apps-script"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/04\/search-html-invoice.jpg?fit=1280%2C720&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/10498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=10498"}],"version-history":[{"count":73,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/10498\/revisions"}],"predecessor-version":[{"id":10902,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/10498\/revisions\/10902"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/10901"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=10498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=10498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=10498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}