How make Scan QRCode and Save it in Google Sheet using Google App Script Android Studio

Step 1: Create new app script project. Click here to create App Script.

Step 2: Copy and paste the below script which recieves scanned data and inserts in Google Sheet.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

function doGet(e){

  var ss = SpreadsheetApp.openByUrl("Your Spread Sheet URL");

  var sheet = ss.getSheetByName("Sheet1");

 return insert(e,sheet);

}

function doPost(e){

  var ss = SpreadsheetApp.openByUrl("Your Spread Sheet URL");

  var sheet = ss.getSheetByName("Sheet1");

  return insert(e,sheet);

}

function insert(e,sheet) {

  var scannedData = e.parameter.sdata;

 var d = new Date();

  var ctime =  d.toLocaleString();

  sheet.appendRow([scannedData,ctime]);

  return ContentService

  .createTextOutput("Success")

  .setMimeType(ContentService.MimeType.JAVASCRIPT);  

}

Step 3: Change the url of the spread sheet. Make sure sheet is shared .[anyone with the link can view]

Step 4: Go to Publish -> Deploy as web app. A window pop up, here ->Who has access to the app: -> Anyone, even Anonymous

Publish/Update. Copy the published URL and store it.

2. Android Part

Step 1: Create new Android App from Android Studio

Step 2: Go to build.gradle[module: app] and add following dependencies.

note: If you are downloading the source code and modifying. Please make sure build tool version and compileSdk Version in build.gradle[module: dependancyapp] are compatible with your phone. If you are developing from the scratch then no issues, just dependency,

1

2

 compile 'com.google.zxing:core:3.3.0'

 compile 'com.journeyapps:zxing-android-embedded:3.4.0'

Step 3: Let’s add all layout files.

activity_main.xml This adds a button to Scan

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:paddingBottom="@dimen/activity_vertical_margin"

    android:paddingLeft="@dimen/activity_horizontal_margin"

    android:paddingRight="@dimen/activity_horizontal_margin"

    android:paddingTop="@dimen/activity_vertical_margin"

    tools:context="alabs.qsg.MainActivity">

    <TextView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:text="QR SCAN TO GSHEET"

        android:layout_alignParentTop="true"

        android:layout_centerHorizontal="true"

        android:id="@+id/textView" />

    <Button

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:text="SCAN"

        android:id="@+id/scan_btn"

        android:layout_below="@+id/textView"

        android:layout_centerHorizontal="true"

        android:layout_marginTop="80dp" />

</RelativeLayout>

Step 4: add the following code to MainActivity.java which scans and calls web service

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

package alabs.qsg;

import android.app.Activity;

import android.content.Intent;

import android.os.AsyncTask;

import android.os.Bundle;

import android.support.v7.app.AppCompatActivity;

import android.util.Log;

import android.view.View;

import android.widget.Button;

import android.widget.Toast;

import com.google.zxing.integration.android.IntentIntegrator;

import com.google.zxing.integration.android.IntentResult;

import org.json.JSONObject;

import java.io.BufferedReader;

import java.io.BufferedWriter;

import java.io.InputStreamReader;

import java.io.OutputStream;

import java.io.OutputStreamWriter;

import java.net.HttpURLConnection;

import java.net.URL;

import java.net.URLEncoder;

import java.util.Iterator;

import javax.net.ssl.HttpsURLConnection;

public class MainActivity extends AppCompatActivity {

    String scannedData;

    Button scanBtn;

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

       final Activity activity =this;

        scanBtn = (Button)findViewById(R.id.scan_btn);

        scanBtn.setOnClickListener(new View

إعلان فوق المشاركات

How make Scan QRCode and Save it in Google Sheet using Google App Script Android Studio

Step 1: Create new app script project. Click here to create App Script.

2. Android Part

ليست هناك تعليقات:

إرسال تعليق

إعلان اسفل المشاركات

نبذة عن المدون

Facebook

الشائعة

أحدث

التعليقات

التسميات

التسميات

كن على أتصال

أحدث الاخبار

نموذج الاتصال

التصنيفات

عدد الزوار حالياً

الصفحات

إعلان فوق المشاركات

How make Scan QRCode and Save it in Google Sheet using Google App Script Android Studio

Step 1: Create new app script project. Click here to create App Script.

2. Android Part

ليست هناك تعليقات:

إرسال تعليق

إعلان اسفل المشاركات

نبذة عن المدون

متابعينا!

Facebook

الشائعة

أحدث

التعليقات

التسميات

التسميات

كن على أتصال

أحدث الاخبار

نموذج الاتصال

التصنيفات

عدد الزوار حالياً

الصفحات