<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Bikash Lalani on Medium]]></title>
        <description><![CDATA[Stories by Bikash Lalani on Medium]]></description>
        <link>https://medium.com/@bikashlalani?source=rss-401b901908f1------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*0rnFTQF0UOaLeGSwIGaFDQ.jpeg</url>
            <title>Stories by Bikash Lalani on Medium</title>
            <link>https://medium.com/@bikashlalani?source=rss-401b901908f1------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 08:01:27 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@bikashlalani/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Conquering Chaos: How Small Businesses and Startups Can Hire Better]]></title>
            <link>https://bikashlalani.medium.com/conquering-chaos-how-small-businesses-and-startups-can-hire-better-71c91e9d39f2?source=rss-401b901908f1------2</link>
            <guid isPermaLink="false">https://medium.com/p/71c91e9d39f2</guid>
            <category><![CDATA[hr]]></category>
            <category><![CDATA[hiring]]></category>
            <category><![CDATA[small-business]]></category>
            <category><![CDATA[recruitment]]></category>
            <dc:creator><![CDATA[Bikash Lalani]]></dc:creator>
            <pubDate>Sat, 09 Nov 2024 15:30:44 GMT</pubDate>
            <atom:updated>2024-11-09T15:31:38.044Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nvEHa5RnXm4pDv9Y3s7LBw.jpeg" /></figure><p>Chaos.</p><p>A word usually associated with negative connotations. One that can send shivers down spines. Bring forth negative emotions. Conjure images of uncontrolled and unorganized growth. It rules our world and is present everywhere we look.</p><p>The beginning and end of things in this world is filled with Chaos. The birth of the universe, the birth of a baby, birth of a company, birth of an idea, they all began with chaos. Even the end of things are equally chaotic, such as, the death of a star, the death of a person, the death of a company. Chaos is everywhere and is gonna be ever present.</p><p>Chaos is necessary. Chaos is the heralder of change. Chaos is the precursor to beginnings and ends. Chaos leads Equilibrium and also trails it. It defines, limits and controls the period of stability.</p><p>Similarly, the story of HireTale is rooted in chaos.</p><p>To unravel it we need to understand the chaos in the recruitment industry. One of the most misunderstood industry and usually not well-liked, HR personnel have a difficult job. Being a bridge between an employer and its employees can sometimes feel like you are the rope in a tug o’ war. To crack this industry one needs to develop advanced level skills in multiple aspects, such as, interpersonal, quick thinking, negotiations, analytical etc.</p><p>But managing candidate data should not be painful. We bring to you a fully cloud solution that eases the maintenance of data and feels budget-friendly in your pocket, with a free tier with all features for solopreneurs and micro businesses.</p><p>Potential candidate data in small business and startups is usually lost and forgotten over time like most hoarded files. They are usually dispersed across systems, software and individual devices. They could be found anywhere from a job portal to spreadsheet to LinkedIn message to an email; only to remain unutilized and unorganized.</p><p>The reason for this is simple. The glove does not fit the hand. Current market solutions are not suited for small businesses.</p><p>Spreadsheets are loved because they are very flexible and can be modified based on the person’s taste and needs. The users find them easy to organize the data, define fields and maintain.</p><p>Other systems like full ATS solutions are large, complex and rigid systems that need lot of data entry, and only derive value after a lot of training and time.</p><p>Both these solutions lack each other’s best qualities. This huge gap that has been unfulfilled. It is like the unoccupied middle ground, like the No Man’s Land between two hostile countries. Risks taken in this space can be career threatening.</p><p>It is not easy to build the best of both worlds which we have embarked upon. We see the challenges in this space are multifold.</p><p>Basic solutions need to be self-prepared, themed and automated, taking away time and focus from more important deliverables. Advanced solutions that seem future-proofed, even though many of those features will never be used, making the solution slowly incomprehensible and confusing while turning the expense cheque bulkier.</p><p>Small businesses and startups, usually have up to couple of tens of employees. Their candidate churn is generally low, and they do not have a large budget or need for a full fledged HR functions solution. Employees make do with whatever solutions are available at hand and this leads them to Spreadsheet solutions, such as Google Sheets and Excel.</p><p>Although this might be a good strategy to begin with, it is a hidden honeytrap that delays the inevitable. After reaching a certain point, it can be self-harming to rely on unstructured solutions. These do not have a consistent process across the organization, and will be avoided, or rather re-created multiple times.</p><p>Hence, a solution built on the most familiar UI, and delivering on the most necessary needs is the tool you need.</p><p>So, if you resonate with what we are talking about, then try out our solution (<a href="https://workspace.google.com/marketplace/app/hiretale_applicant_tracking_system/387251605270">https://workspace.google.com/marketplace/app/hiretale_applicant_tracking_system/387251605270</a>) or send an email to <a href="/service/mailto:ats@hiretale.com">ats@hiretale.com</a> to help set you up.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=71c91e9d39f2" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Need a customized invoicing and inventory solution for your retail business?]]></title>
            <link>https://bikashlalani.medium.com/need-a-customized-invoicing-and-inventory-solution-for-your-retail-business-73d9c65140b6?source=rss-401b901908f1------2</link>
            <guid isPermaLink="false">https://medium.com/p/73d9c65140b6</guid>
            <category><![CDATA[inventory]]></category>
            <category><![CDATA[invoice]]></category>
            <category><![CDATA[google-spreadsheets]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[inventory-management]]></category>
            <dc:creator><![CDATA[Bikash Lalani]]></dc:creator>
            <pubDate>Fri, 13 Nov 2020 16:35:21 GMT</pubDate>
            <atom:updated>2020-11-13T16:35:21.428Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*rNhG1Y22NKeBAlDa" /><figcaption>Photo by <a href="https://unsplash.com/@biancablah?utm_source=medium&amp;utm_medium=referral">Bianca Ackermann</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>I have created numerous google sheets with scripts to automate processes and tasks for small businesses. These small businesses have used these solutions to solve some of their critical business needs. They are simple and easy to use and are designed to fit into your business process like the critical missing puzzle piece.</p><p>One of the popular solutions that most small businesses have shown an interest in and has been an instant hit is a simplistic invoicing and inventory solution that boasts of the following capabilities:</p><ol><li>A simple invoicing solution that also helps maintain inventory.</li><li>Multi-user capabilities.</li><li>Create multiple invoices at the same time.</li><li>Save invoices as pdf or excel.</li><li>Share invoices through emails and whatsApp.</li><li>Charts/dashboards to analyze data.</li><li>Automation of repeated tasks.</li><li>Plenty of free storage and automated back-up of data.</li><li>Can create webapps and native app for data entry or data viewing.</li></ol><p>If you are interested in having such a customized solution built for you, drop me an email at vicky.lalani@gmail.com</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=73d9c65140b6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Using Google Sheets to create a simple Sales Invoicing/Billing system for your small business]]></title>
            <link>https://bikashlalani.medium.com/create-a-simple-sales-invoicing-system-for-your-small-business-with-google-sheets-b105abe1aa9b?source=rss-401b901908f1------2</link>
            <guid isPermaLink="false">https://medium.com/p/b105abe1aa9b</guid>
            <category><![CDATA[invoice]]></category>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[inventory-management]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[google-apps-script]]></category>
            <dc:creator><![CDATA[Bikash Lalani]]></dc:creator>
            <pubDate>Sat, 18 Apr 2020 18:13:31 GMT</pubDate>
            <atom:updated>2020-05-03T12:41:08.965Z</atom:updated>
            <content:encoded><![CDATA[<p>Before, I dive into how this solution was created, let me shed light on why I created this solution and why I used Google Sheets.</p><p>I have a cousin who owns and runs a small consumer goods retail/wholesale store. They sell everything from a small soap to 50 Kgs of sacks of Sugar, Rice, Flour, etc. Basically, they have a lot of product variety along with different packet &amp; box sizes, volumes, weights, boxes for different products.</p><p>One day, when I was visiting them, I saw their operations for a few hours. I realized that their operation was entirely manual and and required re-doing things multiple times, like checking their calculation of sum total of 50+ items ordered by just one customer with a small calculator at least twice and even if a minute product was dropped or added to the list the total had to be checked again. This started bothering me and so I spoke to my cousin and asked him if I could suggest him some ways to reduce some of the manual operations which would also speed up his work. He later listened to my suggestions and gave mea go ahead to build him a simple invoicing system.</p><p>My previous experience of developing a <a href="https://medium.com/@bikashlalani/using-google-sheets-to-build-a-very-simplistic-inventory-management-solution-for-your-small-8aeddc30936c">simple inventory solution</a> for my brother that was operated by his employees gave me some notion of the kind of user interfaces people in our regions found easy to use and grasp. Hence, I built an interface that looked similar to what a manual sales slip looks like.</p><p>The reason for choosing Google Sheets over other spreadsheet/software:</p><ol><li>Google sheets is free and there is free storage of 15Gb</li><li>Task automation capabilities using Google Apps Script and Macros</li><li>Multi-user capability and auto-saving of data</li><li>Direct saving and printing capability through the click of a button created on Google Sheets</li><li>Ease of sharing of files and data and the ability to share with view only option.</li></ol><p>Now, let’s get started with developing this Sale Invoicing system.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*VZpnolu4Of9J0spdRcmS8g.png" /><figcaption>Sale Invoice</figcaption></figure><p>The above image shows the way I designed the interface for the Sale Invoicing system for my cousin.</p><p><strong>Customer Field: </strong>I put in the ‘CUSTOMER’ text in Cell ‘B1&#39;. Then below it I created a dropdown from the ‘Data Validation’ option under the ‘Data’ option in the Menu bar. The list of customers was put in a separate sheet ‘ListOfItems’ as seen in image. All lists needed for creating dropdowns can be put into one sheet that makes it easier when you want to add, edit or delete items. See image below.</p><p><strong>Date field: </strong>In the date field simply apply the formula: =TODAY() to automatically get the date of the day.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-KhmOBr-JOp7gniFSU_x4A.png" /><figcaption>‘ListOfItems’ Sheet</figcaption></figure><p><strong>Product Description Field:</strong> The product description field was also created in a similar way as the above ‘Customer’ field was created.</p><p><strong>Unit Field: </strong>The unit field was also turned into a dropdown that is not linked to the product description field to allow more variety for different types of unit varieties of the same product, such as, pieces, packets, boxes or volumes or weights, etc.</p><p>The remaining fields of ‘<strong>Quantity’</strong> and ‘<strong>Rate’ </strong>were left for keyboard input as these goods have variable pricing strategies. The <strong>‘Total’</strong> field was calculated by the simple formula of multiplying the cell values of <strong>‘Quantity’</strong> and <strong>‘Rate’.</strong></p><p>If you have more fixed priced goods then you can simply recall all data associated with a product by selecting the product in the dropdown list and linking the remaining fields with the product name and they will autofill. The data for products should all still be just put into one sheet.</p><p>Now, let us turn onto the customizations that are needed to turn this simple formatted sheet into a powerful tool for invoice creation, saving and printing.</p><blockquote><strong>Custom Menus</strong></blockquote><p>A custom menu is basically a menu option created by you which shows up on the sheet, like in the photo below: <strong>‘Vinit Enterprises’</strong> is a custom menu with options like <strong>‘SalePerson1’</strong> and sub-menu options like <strong>‘Add 5 Rows — SP1’</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9U4kzMIapaDNRitW8Ph7nA.png" /><figcaption>Custom Menu of Vinit Enterprises — with menu items ‘SalePerson1&#39; and sub-menu options ‘Add 5 Rows — SP1’</figcaption></figure><p>To understand how to create a custom menu option either follow <a href="https://developers.google.com/apps-script/guides/menus">this tutorial</a> on Google Apps Script by Google or just copy my codes for creating this simple invoicing tool from<a href="http://custom menu and buttons for simple invoicing system"> this github repository</a>.</p><p>The Custom Menu has the following items: SalePerson1, SalePerson2, SalePerson3, SalePerson4. This has the same name as the sheets added in the spreadsheet. All the sheets are alike. The reason for creating multiple sheets is to allow creation of multiple invoices at the same time either by one person or multiple people. Each of the menu items under ‘SalePersonX’ has the same options to edit the invoice. They are:</p><p><strong>Add 5 Rows-SPX: </strong>When you run out of rows, just click on this option under the correct menu item corresponding to the sheet name to automatically add 5 rows with serial nos and borders. Click <a href="http://custom menu and buttons for simple invoicing system">here </a>for the script code. The function <strong>‘addRowsX’ </strong>contains the code for this functionality.</p><p><strong>Delete Empty Rows-SPX: </strong>When you have extra rows left in your invoice and want to delete them click on this option under the correct menu item corresponding to the sheet name. Click <a href="http://custom menu and buttons for simple invoicing system">here </a>for the script code. The function <strong>‘deleteEmptyRowsX’ </strong>contains the code for this functionality.</p><p><strong>Click to Clear Data-SPX: </strong>When you want to create new invoice and clear data of the old invoice, click on this option under the correct menu item corresponding to the sheet name. Click <a href="http://custom menu and buttons for simple invoicing system">here </a>for the script code. The function <strong>‘clickToClearDataX’ </strong>contains the code for this functionality.</p><p><strong>Save &amp; Print-SPX: </strong>This option only saves the file to the google drive folder with the given id that you choose and enter in the script. You can get it to also directly print the file with no dialog window by adding the one-line print function already given in the code. Click <a href="http://custom menu and buttons for simple invoicing system">here </a>for the script code. The function <strong>‘saveToPdfX’ </strong>contains the code for this functionality.</p><blockquote><strong>Buttons</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*D39lY1QSrr4Sk_GNAdnckQ.png" /><figcaption>‘S’ &amp; ‘P’ Buttons</figcaption></figure><p>There are two buttons created on the sheet, <strong>‘S’</strong> and <strong>‘P’</strong>. <strong>‘S’ </strong>is for Saving the file without printing it. <strong>‘P’</strong> is for printing the file without saving it. These functionalities were separated to allow the user to decide whether they wanted to print a file or not. The functions <strong>‘saveToPdfX’ </strong>and<strong> ‘printPdfX’ </strong>contain the code for this functionality<strong>.</strong></p><blockquote><strong>Direct Printing</strong></blockquote><p>To set up direct printing from Google sheets, we need to complete a few steps. I have already created a separate tutorial for this process. Click on this <a href="https://medium.com/@bikashlalani/set-up-direct-printing-from-the-click-of-a-button-or-a-custom-menu-option-in-google-sheets-634a67abad7d">link</a> to view the tutorial.</p><p>Once, you have setup the direct printing, continue to the next step.</p><p>If you have completed the above steps, then now you can duplicate the sheet to allow for multi-invoicing capability. Copy the code and change the function names and add it to the sub-menus of the custom-menu. If you have buttons do not forget to change the function names associated to them as well. Check your drive to see if your file is getting saved into pdf and its formatting is alright also the location where the file is being saved.</p><p>If you liked this tutorial, please leave a clap. Follow me to see more of such content. If you have any queries or would like help in developing similar solutions for your business or personal needs drop me an email at vicky.lalani@gmail.com.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b105abe1aa9b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Google Sheets — How to set up Direct Printing from the click of a Button or from a Custom Menu item]]></title>
            <link>https://bikashlalani.medium.com/set-up-direct-printing-from-the-click-of-a-button-or-a-custom-menu-option-in-google-sheets-634a67abad7d?source=rss-401b901908f1------2</link>
            <guid isPermaLink="false">https://medium.com/p/634a67abad7d</guid>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[solutions]]></category>
            <category><![CDATA[google-apps-script]]></category>
            <category><![CDATA[google-cloud-print]]></category>
            <category><![CDATA[printing]]></category>
            <dc:creator><![CDATA[Bikash Lalani]]></dc:creator>
            <pubDate>Sat, 18 Apr 2020 17:53:40 GMT</pubDate>
            <atom:updated>2020-12-31T03:32:25.782Z</atom:updated>
            <content:encoded><![CDATA[<h3>Google Sheets — How to set up Direct Printing (Now defunct) from the click of a Button or from a Custom Menu item</h3><p><strong>Update on 31st Dec 2020: </strong><em>Due to Google removing support for </em><a href="https://www.google.com/cloudprint/learn/"><em>Google’s Cloud printing</em></a><em>, it is no longer possible to set up direct printing via the method described below.</em></p><figure><img alt="Google Cloud Print Shutdown from 31st December 2020" src="https://cdn-images-1.medium.com/max/1024/1*ih4RGvgfRmg1t4F3O0B7VA.png" /></figure><p>In your Google sheets if you want to directly print a sheet without the pop-up of the dialog window for printing then you can use the following steps.</p><ol><li>Create a Button or Custom Menu. (See Image below)</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*R647KlaPJ_XMlgVRKriWLQ.png" /><figcaption>Custom Menu</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PbQkIBJeXB52DL8qOpjupQ.png" /><figcaption>Button</figcaption></figure><p>2. Select Tools from the Menu bar and click on the Script Editor Option</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Z0IMhEko-1wt39ZbL3CoAA.png" /><figcaption>Select Script Editor</figcaption></figure><p>3. Once the Google Apps Script Project opens — Copy and Paste the following <a href="http://direct printing from Google Sheets">Script Code</a>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hX8Bmj4iNLUTO_9pX5VJ3A.png" /><figcaption>Google Apps Script Project Creation</figcaption></figure><p>There are three fields in this code that need values to be entered, they are <strong>CLIENT_ID, CLIENT_SECRET</strong> and <strong>PRINTER_ID</strong>.</p><p>4. To generate <strong>CLIENT_ID </strong>and <strong>CLIENT_SECRET </strong>we need to create a project in Google Cloud Console. Open another tab in your browser and enter <a href="https://console.cloud.google.com/">https://console.cloud.google.com/</a></p><p>5. Once the console is open. Click on ‘Select a project’</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*P1HszGRTTMNz5Dxc381v9w.png" /></figure><p>6. A pop-up window will open up from it select ‘New Project’.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ExtH7yRrS5yuKLPc01gCZA.png" /></figure><p>7. A new project window will open up. You can use the suggested name for the project or rename it. Leave the ‘Location’ field as is. Then click ‘Create’.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I40nhc2xTv2Gq57RSZnfBA.png" /></figure><p>8. You will see a notification once the project has been created. Click on it. Then the created project’s Dashboard will open up.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5eFjHR8FbW9iVicHtjwqvg.png" /></figure><p>9. From the left-hand menu select ‘ APIs &amp; Services’ and then select ‘OAuth Consent Screen’</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*X9TVDGMGRzuumjmKFQPnhA.png" /></figure><p>10. From the new window of OAuth Consent Screen, click on ‘External’ and click Create.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9c4GFuciP_w-Aw1Oi6hqEQ.png" /></figure><p>11. From the OAuth Consent screen — Fill the Application name field (Give it any name you like) and the Authorized Domains field. In the authorized domains field enter “script.google.com”. Then click ‘Save’.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/569/1*mm6y8yH-yUZgMWu2IiNcWQ.png" /></figure><p>12. Now, that the OAuth Consent has been completed click on Credentials from the left menu bar. Then click on ‘Create Credentials’ and from its dropdown click on ‘OAuth client ID’. The ‘Create OAuth client ID’ screen will appear.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Yjc7qqpgT5c9iDe6WjxIXg.png" /></figure><p>13. From the ‘Create OAuth client ID’ screen. Select Application type as — ‘Web Application’ and then give the Web Application a ‘Name’ and fill the Authorised redirect URIs with this: https://script.google.com/macros/d/{SCRIPT ID}/usercallback</p><p>The {SCRIPT ID} has to be replaced by the script ID of your Apps Script Project. To find the script ID of your project see images below the ‘Create OAuth client ID’ image.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Mp3SIQELzQiNBbdXhiK4Fw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*a6LEC5Cnqr8kO2wkwDwCrw.png" /><figcaption>Apps Script Project — Select ‘File’ item from menu bar and then ‘Project properties’</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YJQk-3KdhCYv3Gsnvxfedw.png" /><figcaption>From the ‘Project properties’ pop-up window copy the ‘Script ID’ of the file (hidden here)</figcaption></figure><p>14. Now, that the ‘Script ID’ has been replaced in the URI. Click on the ‘Create’ button in the ‘Create OAuth client ID’ window and a pop-up window with the ‘CLIENT ID’ and ‘CLIENT SECRET’ will pop up.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9-7QrMX-aBvoHQjTS9y0VA.png" /></figure><p>15. Copy the ‘Client ID’ and ‘Client Secret’ back into the Apps Script Project’s setClientId and setClientSecret fields in the script’s code.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ULZvEfonOMKGgo3mwdXrqQ.png" /></figure><p>16. Click on the ‘Resources’ item from the Menu bar and then select ‘Advanced Google Services’. A new pop-up window will open up. We have to add the ‘OAuth’ library here.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2HktmbMcjJMjO4Y_PtdoNA.png" /></figure><p>17. The ‘OAuth’ library has a unique script ID like our project which we can find by opening this <a href="https://github.com/gsuitedevs/apps-script-oauth2">github repository link</a> and scrolling down to the ‘Setup’ heading and then copy the script ID.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wf_hN4kRLlnd530FbHHjAA.png" /></figure><p>18. The copied Script ID can be pasted into the ‘Add a library’ field and then click on ‘Add’. The OAuth2 library will appear and then select the latest version from the version dropdown. Then click ‘Save’ and close the window.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RpKPRcJj4yv-rVCWv6oUBQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*f_98VgOzG3lmsL2Eif56lA.png" /></figure><p>19. Now, we need to get the ‘Printer ID’ and paste it into our Apps Script code.</p><p>To get the printer ID, make sure that your printer is connected to the same network as your laptop/desktop. Now in your browser, open a new tab and search for “chrome://devices”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IyR3L5T1FLNwkqiFcPKV_w.png" /></figure><p>20. Click on ‘Add printers’. A new window listing all the printers in your network and desktop will appear. You can choose to add all printers or just the ones you wish to connect to. Then click on Add printer(s).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*T09-5EasX2dfmpZDq2NdZQ.png" /></figure><p>21. Then click on ‘Manage your printers’.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*I3iqCcpbaYJ9XA2i2C1C1w.png" /></figure><p>22. From the list of printers, click on the printer you want to connect for direct printing. Then click on ‘Details’ to find the details of the printer.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oGcNhVQHf3Q-H6UDywf0Eg.png" /></figure><p>23. Click on ‘Advanced Details’ to find the ‘Printer ID’.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*h7OOXTHi-TzWIyIyEIUB0Q.png" /></figure><p>24. Copy the ‘Printer ID’.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AU9mmA0dI4O0AkeqwprwSg.png" /></figure><p>25. Go back to your Apps Script Project and scroll to the ‘Printer ID’ location and paste the ‘Printer Id’ in the “printGoogleDocument” function.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DDH6AxvpGJaL4oqUKtzjFQ.png" /></figure><p>Now, you can call the “printGoogleDocument” function from another function or directly and pass the “document ID” and the “document name” values of the document to be printed to print the sheet directly from your printer and no print dialog window will appear. For any queries mail me at vicky.lalani@gmail.com.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=634a67abad7d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Using Google sheets to build a very simplistic Inventory Management solution for your small…]]></title>
            <link>https://bikashlalani.medium.com/using-google-sheets-to-build-a-very-simplistic-inventory-management-solution-for-your-small-8aeddc30936c?source=rss-401b901908f1------2</link>
            <guid isPermaLink="false">https://medium.com/p/8aeddc30936c</guid>
            <category><![CDATA[inventory-management]]></category>
            <category><![CDATA[apps-script]]></category>
            <category><![CDATA[small-business]]></category>
            <category><![CDATA[solutions]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Bikash Lalani]]></dc:creator>
            <pubDate>Wed, 15 Apr 2020 13:19:49 GMT</pubDate>
            <atom:updated>2020-12-31T03:15:56.906Z</atom:updated>
            <content:encoded><![CDATA[<h3>Using Google sheets to build a very simplistic Inventory Management solution for your small business.</h3><p>Before I dive into the process of building a Google sheets solution for a very simplistic Inventory Management system, I thought I would just provide the reasons for selecting Google sheets over other similar options like Excel and others.</p><p>The factors that made me lean towards Google sheets:</p><ol><li>Most people today have a Google account and they can access the basic free versions of Sheets, Form, Data Studio, etc, which are sufficient for small business requirements. Other usually charge a subscription fee.</li><li>Google sheets allows multiple users to edit or view a sheet by simply setting the permissions in the Share option and sharing the file with other Google accounts.</li><li>Google sheets has Apps Script which extends its functionalities — allowing the automation of tasks, creation of UIs, webapps, add-ons, etc. This makes it a very powerful tool to create customized solutions for your needs.</li><li>Google sheets has an API library which allows you to connect the sheet with other softwares.</li><li>Google sheets is further extendable by connecting it with libraries available on the net.</li><li>Google Apps script allows Javascript, HTML, CSS, Python and other scripting/programming languages for ease of use.</li></ol><p>Now, I will dive into how I created a basic inventory management system using Google sheets.</p><p><strong>What problem I was trying to solve?</strong></p><p>My brother owns a retail automotive parts store. He asked me to take an inventory of the goods stored. Well, as there was currently no system to track the inventory, I decided to start taking the inventory on Google sheets as I could make the entries using my phone. I began with very simple columns of data like Product Name, Quantity, Stock Date.</p><p>After a week, I managed to finish taking down all the inventory and also had expanded my data columns, as I kept thinking about all the important information regarding the product, distinguishing between products with similar names but differing sizes/volumes/weight, entry date into the warehouse, exit date out of the warehouse, etc. My sheet grew to many columns which I further refined by keeping ones that were most important after discussions with my brother.</p><p>I applied the ‘Alternating colors’ option to the sheet from the ‘Format’ menu option on the sheet and highlighted the column that needs to be edited with ‘yellow’. This was done to avoid errors when employees who work on the sheet do no make mistakes while changing the data. Also, I protected the sheet from accidental changes by activating the ‘Protect Sheet’ option under ‘Tools’ option in the Menu bar.</p><p>My sheet looked finally like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZtsOBFOG7TvYPEMw89BcdA.png" /></figure><p>I made other sheets in the same spreadsheet for other products like Mobil (Engine Oils/Hydraulic Oils/Gear Oils), Batteries and Inverters, Greases and Pipes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xGlqsu-T5uAjyWHdDfffkA.png" /></figure><p>Then, I thought, when a product’s quantity is reduced it can be assumed as a sale and when a product’s quantity is increased it can be assumed as a purchase. I then googled as to how to automatically capture data when the value of a cell is changed. I found the solution was to create an <a href="https://developers.google.com/apps-script">Apps Script Project</a> and write Javascript based scripts to automate tasks.</p><p>I made two separate sheets of Purchase and Sale and wrote the script with help from resources on the internet and other codes written by people on the internet and understanding it and adapting it for my own purpose. Best resource: <a href="https://stackoverflow.com/">stackoverflow.com</a>.</p><p>The sheet captures data from the product sheets when the Quantity column for the sheets changes. When quantity is reduced it captures the data in the ‘Sales’ sheet and when quantity is increased it captures the data in the ‘Purchase’ sheet, automatically.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ki6t2EJGvoO1qe3LXQBkgA.png" /></figure><p>The code for automating capture of data when cell value is changed can be accessed from this <a href="https://github.com/vickylalani/GoogleAppsScript/blob/master/capture%20data%20when%20cell%20value%20changes">Github repository</a>.</p><p>We also need to set up a trigger in Apps script to run this code. A trigger can be created by selecting the ‘Edit’ option from the Apps Script Project Menu bar and selecting “Current project’s triggers” from the list.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*o6l3HCTCH8x3Rs3Vs_0vkQ.png" /><figcaption>Apps Script Project</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cAbRLxVU0UbO9dNFinYntw.png" /><figcaption>Current Project’s Triggers</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/775/1*Dilz2IYuoGkA2besoFCFGg.png" /><figcaption>Trigger Setup</figcaption></figure><p>After setting up the project and editing the code and when you are ready, run the Apps script project. When the project is run for the first time, it will ask for authorization. Grant it permission by following these steps.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5KdUSzFaNxPv2mxzUkd_mg.png" /><figcaption>Authorization — Step 1-Select ‘Review Permissions’</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sZh8ql3z-cHAqyuUyyfWAg.png" /><figcaption>Authorization — Step 2-Select Email ‘xxxxxx@gmail.com’</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/850/1*PbmhGQS1BmvOxUZGo1gk_Q.png" /><figcaption>Authorization — Step 3-Select ‘Advanced’</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/975/1*QFCuwYqcP0A09Ua-r5sMyA.png" /><figcaption>Authorization — Step 4-Select ‘Go to “Project Name” (unsafe)’</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/910/1*rz8hMFIeYIuDBiOS4dCbWg.png" /><figcaption>Authorization —Step 5- Select ‘Allow’</figcaption></figure><p>If you find this tutorial helpful for your project and would like to see more content like this and for any other queries drop me an email at vicky.lalani@gmail.com.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8aeddc30936c" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>