This article shows: 1) How to create Google Form using AppScript’s “FormApp” class 2) Send Form URL to any email address using MailApp or GmailApp class 3) How to use Triggers in AppScript 4) How to send Form submit Responses to any email address 5) How to save Form submit Responses to any particular Google … Read more
This article shows how to get latitude and longitude of a particular place or city. We read the city/place name from a Google Spreadsheet, then get the latitude and longitude of that place using Google AppScript’s “Maps” class and then save the lat long in the spreadsheet. We will also be reading two places name … Read more
This article shows how to read list of email addresses, subject and message body from Google Spreadsheet and send separate emails to all of them with Google AppScript. First, let’s see a simple example of sending single message to a particular email address. Send Single Email Here, AppScript’s MailApp class is used to send email. … Read more
This article shows how to create a new Google Sheet and write data into it with Google AppScript. We will also be writing data into existing Google SpreadSheet. Create a new Google Sheet and write data into it with AppScript The following function will create a Google Sheet named TestSheet in your Google Drive. Then, … Read more
This article shows how to create a new folder and file with some text inside it with Google AppScript. We will also see how to create a new Google Doc and write some text inside it through AppScript. Create File & Folder with AppScript The following function will create a folder name My Folder in … Read more
This tutorial provides a very basic introduction to Google App Script. I will also list out the works that can be done with AppScript. And, I will be showing very basic Javascript code that can be run on AppScript’s console. In this article, we will be dealing only with Javascript arrays and loops. What is … Read more
This article shows how you can get attribute name or label, id, entity_type, etc. by attribute code in Magento 2. If you would like get attribute name and value in Magento 1 then you may refer to this article: Magento: How to get attribute name and value? I will be showing both Dependency Injection (DI) … Read more
This article shows how to get payment methods in Magento 2. We will be fetching 3 types of payment methods. They are: 1) All Payment Methods 2) Active/Enabled Payment Methods 3) Payment Methods that have been used while placing orders I will be showing both ways (Dependency Injection & Object Manager way) to get payment … Read more
This article shows how to get all customer groups name and id in Magento 2. I will be showing an example in a Block class. You can write the code in other class (Helper/Model) as well. Both ways (Dependency Injection & Object Manager way) are shown below. Using Dependency Injection (DI) Here is the code … Read more