bpwebs
bpwebs
  • 48
  • 388 889
Create progress bars in Excel
This video will explore the step-by-step process of creating dynamic and visually appealing Excel progress bars. Progress bars are excellent visual aids that enhance the presentation of data, making it easier for users to track and understand progress. Whether you’re managing projects, tracking goals, or presenting data, implementing progress bars in Excel can significantly elevate the visual impact of your spreadsheets.
มุมมอง: 66

วีดีโอ

How to Create HTML Data Entry Forms in Google Sheets
มุมมอง 1.2Kหลายเดือนก่อน
Link to the blog post: www.bpwebs.com/create-html-data-entry-forms-in-google-sheets/ Are you constantly battling typos, inconsistent formatting, and the sheer tedium of manually entering data into spreadsheets? If so, it’s time to ditch the error-prone process and upgrade your workflow. The data entry forms are a great way to improve this workflow and increase the efficiency of the data entry p...
Display Google Sheets Data on Interactive HTML Tables (Quick & Easy Setup)
มุมมอง 4K2 หลายเดือนก่อน
Link to the blog post: www.bpwebs.com/display-google-sheets-data-on-interactive-html-tables/ This video demonstrates how to effortlessly transform your Google Sheets data into dynamic, interactive HTML tables. Using the power of Google Apps Script and the Tabulator library, this process is surprisingly straightforward. Tabulator provides a wide array of features for filtering, sorting, and more...
Automatically Email Google Sheets Invoice as PDF
มุมมอง 7083 หลายเดือนก่อน
Tired of manually creating and sending invoices? This video shows you how to automate the process using Google Sheets and save time and reduce errors. Get a free Google Sheets template with the necessary code in the description below! Visit the Blog Post: www.bpwebs.com/automatically-email-google-sheets-invoice-as-pdf/
How to Perform Basic Calculations in Microsoft Word Tables
มุมมอง 1864 หลายเดือนก่อน
Blog Post URL: www.bpwebs.com/perform-basic-calculations-in-microsoft-word-tables/ In our modern, fast-paced world, efficiency is crucial, particularly in managing documents. Microsoft Word, a versatile tool, extends beyond basic word-processing functions. An often overlooked feature is its capability to perform straightforward calculations directly within tables. In this video, I will show you...
Take your inventory to Google Sheets with QR, Bar code scanning Web Apps
มุมมอง 7K4 หลายเดือนก่อน
In today’s fast-paced retail environment, efficiency is key. Small shop owners need a cost-effective solution for managing their inventory without breaking the bank. In this blog post, we’ll explore how you can create a user-friendly QR Code Scanner Web App using Google Apps Script, providing shop owners with a free and efficient tool to take your inventory to Google Sheets. Go to the blog post...
How to Create a Weather Dashboard in Google Sheets
มุมมอง 7285 หลายเดือนก่อน
Read the complete blog post at: www.bpwebs.com/how-to-create-a-weather-dashboard-in-google-sheets/ Have you ever wanted to track local weather conditions without leaving your favorite spreadsheet tool? Or do you need to keep track of the weather in different locations without constantly checking multiple websites? With a little bit of code, you can create a dynamic weather dashboard that pulls ...
How to Combine CSV Files with Google Apps Script
มุมมอง 5326 หลายเดือนก่อน
CSV files are well-liked for their ease of use and compatibility with a wide array of software. They provide a straightforward and human-readable format for storing and sharing structured data, making them a favored choice for data exchange and manipulation across diverse fields, ranging from business and finance to scientific research and beyond. If you find yourself dealing with a substantial...
How to create progress bars in Google Sheets
มุมมอง 6K8 หลายเดือนก่อน
Learn to create progress bars in Google Sheets for efficient project management. Visualize tasks, calculate overall progress, and boost productivity. Read the complete blog post at: www.bpwebs.com/how-to-create-progress-bars-in-google-sheets
How to Link Word Table Caption to Document Body: Cross-Reference
มุมมอง 1.4K9 หลายเดือนก่อน
Streamline referencing in Word. Learn to link table captions using Cross-Reference for precise, hassle-free updates. Enhance document credibility and readability. Read the complete blog post at: www.bpwebs.com/link-word-table-caption-to-document-body-cross-reference/
How to create dropdown lists in Excel - Dependent & Multirow
มุมมอง 3419 หลายเดือนก่อน
Learn how to create dropdown lists in Excel, including dependent and multirow dropdowns, in this tutorial. Dropdown lists in Excel help you select options for data entry, ensuring accuracy and consistency. Dependent dropdowns change options based on previous selections, making them ideal for forms and tables. By following these steps, you'll be able to create dropdowns that improve data entry. ...
Create Your Own Personal Finance Tracker App with Google Sheets
มุมมอง 5K11 หลายเดือนก่อน
Blog post link: www.bpwebs.com/personal-finance-tracker-app-with-google-sheets/ Keeping track of your income and expenditures is an important part of your financial planning. It can help you understand your spending habits, set financial goals, make informed financial decisions, and spot potential problems early on. There are many different ways to store your income and expenses. Some people us...
How to link Google Sheets to Google Maps and create interactive maps
มุมมอง 13Kปีที่แล้ว
How to link Google Sheets to Google Maps and create interactive maps
How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets
มุมมอง 56Kปีที่แล้ว
How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets
Periodically Extract Website Data to Google Sheets
มุมมอง 946ปีที่แล้ว
Periodically Extract Website Data to Google Sheets
How to generate static Google Maps in Google Sheets - Add paths, colors, and labels
มุมมอง 2.5Kปีที่แล้ว
How to generate static Google Maps in Google Sheets - Add paths, colors, and labels
How to generate static Google Maps in Google Sheets - Add distinct colours and labels to markers
มุมมอง 1.2Kปีที่แล้ว
How to generate static Google Maps in Google Sheets - Add distinct colours and labels to markers
How to generate static Google Maps in Google Sheets
มุมมอง 539ปีที่แล้ว
How to generate static Google Maps in Google Sheets
20 Excel Tips and Tricks to Save Time
มุมมอง 189ปีที่แล้ว
20 Excel Tips and Tricks to Save Time
How to Create a Crypto Newsfeed in Google Sheets and send daily Crypto updates to Inbox
มุมมอง 255ปีที่แล้ว
How to Create a Crypto Newsfeed in Google Sheets and send daily Crypto updates to Inbox
How to import data from websites to Google Sheets
มุมมอง 936ปีที่แล้ว
How to import data from websites to Google Sheets
How to pull data from Google Sheets to HTML table
มุมมอง 82K3 ปีที่แล้ว
How to pull data from Google Sheets to HTML table
Highlight multiple rows of Google Sheets based on conditions attached to Google Sheets Checkbox
มุมมอง 6K3 ปีที่แล้ว
Highlight multiple rows of Google Sheets based on conditions attached to Google Sheets Checkbox
Google Sheets Checkbox - Apply Conditional Formatting across entire row
มุมมอง 120K3 ปีที่แล้ว
Google Sheets Checkbox - Apply Conditional Formatting across entire row
Google Sheets Import Data - Import from multiple spreadsheets to one range
มุมมอง 1.3K3 ปีที่แล้ว
Google Sheets Import Data - Import from multiple spreadsheets to one range
How to Import Data in Google Sheets - Import Data from other Spreadsheets
มุมมอง 1.3K3 ปีที่แล้ว
How to Import Data in Google Sheets - Import Data from other Spreadsheets
Creating Forms in Google Sheets - Sidebar & Modal Dialog forms
มุมมอง 10K4 ปีที่แล้ว
Creating Forms in Google Sheets - Sidebar & Modal Dialog forms
How to Create a Table of Contents in Microsoft Word
มุมมอง 4274 ปีที่แล้ว
How to Create a Table of Contents in Microsoft Word
Formatting Captions in Microsoft Word
มุมมอง 2384 ปีที่แล้ว
Formatting Captions in Microsoft Word
Insert Caption to Tables, Figures, and Equations in Microsoft Word
มุมมอง 1.9K4 ปีที่แล้ว
Insert Caption to Tables, Figures, and Equations in Microsoft Word

ความคิดเห็น

  • @chidinduuwaeziozi7360
    @chidinduuwaeziozi7360 6 วันที่ผ่านมา

    Great. The problem with the REPT function is that 30 to 39 will have the same number of symbol.

  • @MytubeEdutech
    @MytubeEdutech 16 วันที่ผ่านมา

    Loading problem

  • @samdrios
    @samdrios 21 วันที่ผ่านมา

    how to change the time?

  • @skkarim3386
    @skkarim3386 22 วันที่ผ่านมา

    Where the link sir, please provide the link

    • @bpwebs
      @bpwebs 21 วันที่ผ่านมา

      You can read the blog post at: www.bpwebs.com/how-to-generate-static-google-maps-in-google-sheets Link to Google Sheet: docs.google.com/spreadsheets/d/1BWNk59IQjhZYppVk2zJVlcuP3WUknSA7WAN_K3FUdCw/copy

    • @skkarim3386
      @skkarim3386 21 วันที่ผ่านมา

      @@bpwebs sir how can i find direction between 2 address using that sheet

  • @zakariazaid8519
    @zakariazaid8519 22 วันที่ผ่านมา

    Such a great video. Would you try nfc reader ?

  • @sachasteem1708
    @sachasteem1708 23 วันที่ผ่านมา

    Thanku soo much it has been really helpful❤️

  • @tpitangerpg
    @tpitangerpg 23 วันที่ผ่านมา

    hello Sir thank you i have question how to delete column delete ?

  • @EzequielBaldiviezo-sd5vm
    @EzequielBaldiviezo-sd5vm 25 วันที่ผ่านมา

    THANK YOU SO MUCH

  • @temyraverdana6421
    @temyraverdana6421 26 วันที่ผ่านมา

    Very useful video. Thanks a lot for share your knowledge.

  • @_Software_developer_
    @_Software_developer_ 29 วันที่ผ่านมา

    once again love u i have completed my task of a week with your base model

  • @_Software_developer_
    @_Software_developer_ หลายเดือนก่อน

    what a great service u have provided me as base model for my project

  • @GJLomba
    @GJLomba หลายเดือนก่อน

    It's working fine for me but not on mobile. When showing the page on my phone, receiving the message "Impossible to open this file". Any idea anyone please? Thanks

  • @SOUVIKKUMAR-vj6wm
    @SOUVIKKUMAR-vj6wm หลายเดือนก่อน

    Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do? Because hyperlink or weblink is not working in html table, it shows fix value. Please help

    • @bpwebs
      @bpwebs หลายเดือนก่อน

      Read the following section of the blog post pls. www.bpwebs.com/pull-data-from-google-sheets-to-html-table/#display-ur-ls-as-hyperlinks

  • @SOUVIKKUMAR-vj6wm
    @SOUVIKKUMAR-vj6wm หลายเดือนก่อน

    Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do? Because hyperlink or weblink is not working in html table, it shows fix value. Please help

    • @bpwebs
      @bpwebs หลายเดือนก่อน

      Add formatter:"link" to the relevent column in the createTable function of the JavaScript.html file. E.g. {title:"Type",field:"Type",headerFilter:true, formatter:"link"},

  • @SOUVIKKUMAR-vj6wm
    @SOUVIKKUMAR-vj6wm หลายเดือนก่อน

    Sir if i want to show any hyperlink or weblink which is in Google sheet, what changes have to do? Because hyperlink or weblink is not working in html table, it shows fix value. Please help

    • @bpwebs
      @bpwebs หลายเดือนก่อน

      Add formatter:"link" to the relevent column in the createTable function of the JavaScript.html file. E.g. {title:"Type",field:"Type",headerFilter:true, formatter:"link"},

  • @SOUVIKKUMAR-vj6wm
    @SOUVIKKUMAR-vj6wm หลายเดือนก่อน

    Sir, if i create hyperlink or want to show any weblink from Google, it is not showing or acting like fix value, how to do. Please help

  • @dgrolfe
    @dgrolfe หลายเดือนก่อน

    Does this work when opening the file from an Android phone???

    • @bpwebs
      @bpwebs หลายเดือนก่อน

      Try this demo. script.google.com/macros/s/AKfycbxYqPy8kAK3q6y3gQKdJ7nK_uW5MCUVNb5nleB2K3R5AlST5_ybOyUpgI59WQVBDytr/exec

  • @airdrop4ufree
    @airdrop4ufree หลายเดือนก่อน

    i need a scrip code please

  • @gregt8262
    @gregt8262 หลายเดือนก่อน

    This won't return image in cell results. Is there a way to do that?

  • @Bharatiya_Brothers
    @Bharatiya_Brothers หลายเดือนก่อน

    add print option

  • @airdrop4ufree
    @airdrop4ufree หลายเดือนก่อน

    Hi can make step by tutorial

  • @BraveHeart-ht8zf
    @BraveHeart-ht8zf หลายเดือนก่อน

    How to call data with drop down from other sheet and edit it

    • @bpwebs
      @bpwebs หลายเดือนก่อน

      Please watch the following video: th-cam.com/video/Vwti3s1Y2Zw/w-d-xo.html

  • @SouravTalukdar-oz6os
    @SouravTalukdar-oz6os หลายเดือนก่อน

    Why Sheet Data Not Showing??

  • @Jayantirana-wl6lj
    @Jayantirana-wl6lj หลายเดือนก่อน

    thank you so, much this video is help me a lot!

  • @yunszzailani7601
    @yunszzailani7601 หลายเดือนก่อน

    hahaha i try to search it say huawei

  • @aarontran6468
    @aarontran6468 หลายเดือนก่อน

    i'm cant open on phone? which problem ?

    • @aarontran6468
      @aarontran6468 หลายเดือนก่อน

      i solve that. but i have a question Could we scan multi barcode. and submit with same other information ?

    • @AsishSharma1
      @AsishSharma1 หลายเดือนก่อน

      Yeah you can scan multiple bar code and saperate with comma, I modified the script

  • @mahaysan
    @mahaysan หลายเดือนก่อน

    This is amazing, Thank you so much! Its so easy to do and hassle free, love it.

  • @jorgetesecum9065
    @jorgetesecum9065 หลายเดือนก่อน

    Mine does not display all the info for example i changed the headers to this: Part Description, Quantity, Location , Condition, Serial Number , Compatibility , Information, Comments , Date/Time ... and only quantity, information and date/time have their data populated in the app, what am i doing wrong ? columns:[ {title:"Part Description", field:"Part Description"}, {title:"Quantity", field:"Quantity"}, {title:"Location", field:"Location"}, {title:"Condition", field:"Condition"}, {title:"Serial Number", field:"Serial Number"}, {title:"Compatibility", field:"Compatibility"}, {title:"Information", field:"Information"}, {title:"Comments", field:"Comments"}, {title:"Date/Time", field:"Date/Time"}, ],

  • @EricCawaling
    @EricCawaling 2 หลายเดือนก่อน

    Can you create a video on how to make with INCOME, EXPENSE, and TRANSFER from Wallet to wallet?

  • @nunomarques6106
    @nunomarques6106 2 หลายเดือนก่อน

    Hi. Can we have ID number to be a number like 1, 2, 3, n... instead of random number? i tried to use this code but it didn´t worked: const uniqueIds = ws.getRange( 2, 1, ws.getLastRow(), 1).getValues(); var maxNum = 0; uniqueIds.forEach(r => { maxNum = r[0] > maxNum ? r[0] : maxNum }); var newID = maxNum + 1; Can you explain ho to do it? thank you.

  • @tranquangminh3347
    @tranquangminh3347 2 หลายเดือนก่อน

    it's not work

  • @rahul_rv15
    @rahul_rv15 2 หลายเดือนก่อน

    Its showing can not edit app script.so how we can paste there URL which copied..?

  • @junior7664
    @junior7664 2 หลายเดือนก่อน

    promo sm 💞

  • @Fullscholarships
    @Fullscholarships 2 หลายเดือนก่อน

    Link please

  • @jeremy112898
    @jeremy112898 2 หลายเดือนก่อน

    Their sign in or sign up page is not working :(

  • @christopherangeles4916
    @christopherangeles4916 2 หลายเดือนก่อน

    Why the body of HTML didn't show up?

  • @PrimeRestore
    @PrimeRestore 2 หลายเดือนก่อน

    the time record is late for 2hrs and 30mins, how to fix ?

  • @obraata567
    @obraata567 2 หลายเดือนก่อน

    "The MY menu" did not appear on my screen. What did I miss?

  • @THDYoung
    @THDYoung 2 หลายเดือนก่อน

    Thank you. Question! If you paste the url of a web app like the one in this video into a Google Site (using 'embed'), then update the data in the spreadsheet associated with the web app, will the Google Site view update automatically or only with a manual page reload?

    • @bpwebs
      @bpwebs 2 หลายเดือนก่อน

      Manual page reload.

  • @aa_konovalov
    @aa_konovalov 2 หลายเดือนก่อน

    🔥🔥

  • @user-by5jd7ii6y
    @user-by5jd7ii6y 2 หลายเดือนก่อน

    NotAllowedEdior:permission denied after click button

  • @user-yq5uu4zq9o
    @user-yq5uu4zq9o 2 หลายเดือนก่อน

    Can we customize the sheet as per our requirements?

    • @bpwebs
      @bpwebs 2 หลายเดือนก่อน

      Yes.

  • @user-yq5uu4zq9o
    @user-yq5uu4zq9o 2 หลายเดือนก่อน

    ❤❤❤

  • @NdegwaGithigi
    @NdegwaGithigi 2 หลายเดือนก่อน

    Nice,

  • @user-by5jd7ii6y
    @user-by5jd7ii6y 2 หลายเดือนก่อน

    phone camera not work

  • @drummergeorge9642
    @drummergeorge9642 2 หลายเดือนก่อน

    didnt work for me too hard

  • @FANITUBE-kn8ii
    @FANITUBE-kn8ii 2 หลายเดือนก่อน

    I love ypur products. Thanks. I have a question can u make a complete webapp using Googlesheet and app script with html css and java to make a Student Fee Management system. Where i can generate monthly fee chalan and enter montly fee collection of a student or whole class of students. Also i can generate fee chalan to download as pdf and also i can send those fee chalan by email. And also i can send unpaod fee inquiries to parents automatically at a specific fix date.

  • @Sooch762
    @Sooch762 2 หลายเดือนก่อน

    How do I get the “create static map” function?

  • @pierreg.1682
    @pierreg.1682 2 หลายเดือนก่อน

    Loved the script, what can I do to continue using it even when I get "Service invoked too many times"?

  • @Netajidebade
    @Netajidebade 3 หลายเดือนก่อน

    hi could you please help me to implement dark theme for this crud operation app