Currently pursuing B Tech at MPSTME. Technical Blogger, interested in Google Workspace. Hope to remain a life long student. Created a course on Google Classroom
Image for post
Image for post

Welcome !

In this blog I am going to show you how to restrict responses for each option in Google Forms. We are going to do this using some basic Google Sheets formulas and a Google Form Add-on called FormRanger.

So let’s get started.

If you need to refresh your knowledge on using Google Forms, click on the link given below.

Step 1 : Sample Google Form

The form that I will be using is a Simple Session registration form . (If you prefer working with a copy of the Google Form, click here)

This form contains the following:

  • Name of the Attendee
  • Email address of…


Image for post
Image for post

Welcome to the No-Code Apps with Google AppSheet Tutorial Series.

So what is Google AppSheet ?

Google AppSheet is a No-Code application development platform that allows users to create mobile, tablet and web applications from data sources like Google Drive, Office 365 .

Why do people prefer no-code app development platforms ?

Yes, people do prefer No-Code app development platforms. They find it appealing because it is easy to use and also allows non-programmers to pump out apps.

In this series I will show you how to create simple apps using Google AppSheet.

  1. Create an Expense Tracking App Using Google AppSheet.
    - Part 1
    - Part 2
  2. Create an Inventory Management App Using Google AppSheet…


Image for post
Image for post

Welcome !

In the last blog we learnt how to create the app and also made our first service order . In this blog I am going to show you how to filer data for specific users , where the manager of the service centre should be able to see the data of all users .

So let’s get started.

Step 1 : Add the Third Sheet


Image for post
Image for post

Welcome !

In this blog I am going to show you how to create a Vehicle Inspection App using Google AppSheet . In this app the user can place a service for his car by filling out a form. This app will have the following features:

(1) The user can place a service order.
(2) Filter data for specific users. Manager of the service centre should be able to see data of all users.

This blog is divided into two parts:

(1) The first part will show you how to create and setup the app, followed by placing our first…


Image for post
Image for post

Welcome!

In the last blog we learnt how to create the app , setup the product codes and make our first sale . In this blog I am going to show you how to calculate the total inventory using some formulas and slices. Then we will see how to display the items that need to be restocked.

So let’s get started.

Step 1 : Add the Third Sheet


Image for post

Welcome!

In this blog I am going to show you how to create an Inventory Management App Using Google AppSheet. An Inventory Management app is used for keeping track of stock, sales, restocking, etc. This app will have the following features:

(1) Add stock to the Inventory.
(2) Sell items from the Inventory.
(3) It will lay out the items that need to be restocked.

This blog is divided into two parts:

(1) The first part will show you how to create and setup the app, followed by setting up of unique codes for each objects. …


Image for post
Image for post

Blogging has become a very popular activity online. I have been engaged in this for the past year, and wanted to share my experience with my fellow students.

Recently, I was given an opportunity to speak at IETE MPSTME on the topic of How to write a blog. This was my first time speaking at an event. Understandably I was nervous, however it was a very rewarding experience and I hope to have more opportunities to speak on various topics in the future.

In preparation of the webinar, I designed a presentation using Google Slides . Google slides has as…


Image for post
Image for post

Welcome!

In the last blog we learnt how to create the app and make our first expense in the app.In this blog I am going to show you how to organise and beautify(styling) the expenses made by the user, followed by exporting a csv file of all the expenses made.

So let’s get started.

So first let’s make a few more expenses, under different categories. So now I am going to make 4 expense entries under 4 different categories.


Image for post
Image for post

Welcome!

In this blog post, I am going to show you how to create a simple Expense Tracking app using Google AppSheet. This app can be used to track your expenses. Additionally, I will demonstrate how you can download a csv file at the end of every week or month that contains all the expenses made by the user.

This blog is divided into two parts:

  1. In the first part, I will show you how to create the app and make your first expense entry in it.
  2. In the second part I will show you how to organise and beautify…


Image for post
Image for post

Recently I took a survey on the experience of teachers using Google Forms for their exams. Overall the response of the teachers was positive, but there were few issues mentioned by the teachers. So in this blog I am going to give 10 tips and tricks that teacher can use while conducting exams online.

So let’s get started.

(1) How to add a Time Limit to my Google Form ? :

This was the most asked question. Most teachers are facing issues in order to time limit the test on Google Forms. …

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store