Android Question Problem with updating a cell in google sheet

DonManfred said:

check this library (not free):

GSheet Library (integrate google sheets into your B4X apps easily)

Gsheet Author: Fernando Arevalo Version: 1.0 Functions: Process_Globals As String B4A, B4I Initialize (ClientId As String) B4J Initialize(ClientId As String,ClientSecret As String) B4X SpreadsheetsId As String The ID of your document. This is the big long aplha-numeric code in the...

www.b4x.com

Click to expand...

Abbas818 said:

Is there another way?

Click to expand...

Abbas818 said:

It is not possible for me to buy it.
Is there another way?

Click to expand...

emexes said:

Other than the $7, is there anything else stopping you from using it?

Click to expand...

Abbas818 said:

It is not possible for me to buy it.

Click to expand...

DonManfred said:

He answered to my answer telling about this library from Fernando.

Click to expand...

emexes said:

Understood: I'm just trying to distil what the true problem is that makes it not possible for him to buy it, in case there is an easy solution to that secondary issue.

That library looks pretty good, btw, so thanks for the prompt pointing it out.

Click to expand...

emexes said:

Does the GSheets library solve your problem?

The library's author Fernando writes "One-time payment, no strings attached! "

Other than the $7, is there anything else stopping you from using it?

Click to expand...

Abbas818 said:

Yes, this library can do what i want

Click to expand...

Abbas818 said:

Hi, thanks
It is not possible for me to buy it.
Is there another way?

Click to expand...

function doGet(e) {
  const sheet = SpreadsheetApp.openById('google sheet ID').getActiveSheet();
  const action = e.parameter.action;

  if (action === 'read') {
    const data = sheet.getDataRange().getValues();
    return ContentService.createTextOutput(JSON.stringify(data)).setMimeType(ContentService.MimeType.JSON);
  }

  if (action === 'create') {
    const values = JSON.parse(e.parameter.values);
    sheet.appendRow(values);
    return ContentService.createTextOutput('Row added successfully');
  }

  if (action === 'update') {
    const row = parseInt(e.parameter.row, 10);
    const values = JSON.parse(e.parameter.values);
    for (let i = 0; i < values.length; i++) {
      sheet.getRange(row, i + 1).setValue(values[i]);
    }
    return ContentService.createTextOutput('Row updated successfully');
  }

  if (action === 'delete') {
    const row = parseInt(e.parameter.row, 10);
    sheet.deleteRow(row);
    return ContentService.createTextOutput('Row deleted successfully');
  }

  return ContentService.createTextOutput('Invalid action');
}

personalapps said:

You can use Google App Script (GAS) and publish the sheet as web app so you can access it by okhttp easily by WEB APP URL. Here is the GAS if you want:

Google App Script:

function doGet(e) {
  const sheet = SpreadsheetApp.openById('google sheet ID').getActiveSheet();
  const action = e.parameter.action;

  if (action === 'read') {
    const data = sheet.getDataRange().getValues();
    return ContentService.createTextOutput(JSON.stringify(data)).setMimeType(ContentService.MimeType.JSON);
  }

  if (action === 'create') {
    const values = JSON.parse(e.parameter.values);
    sheet.appendRow(values);
    return ContentService.createTextOutput('Row added successfully');
  }

  if (action === 'update') {
    const row = parseInt(e.parameter.row, 10);
    const values = JSON.parse(e.parameter.values);
    for (let i = 0; i < values.length; i++) {
      sheet.getRange(row, i + 1).setValue(values[i]);
    }
    return ContentService.createTextOutput('Row updated successfully');
  }

  if (action === 'delete') {
    const row = parseInt(e.parameter.row, 10);
    sheet.deleteRow(row);
    return ContentService.createTextOutput('Row deleted successfully');
  }

  return ContentService.createTextOutput('Invalid action');
}

Click to expand...

Abbas818 said:

If yes, can you please show me how to update a cell in the spreadsheet using Okhttp?

Click to expand...

Abbas818 said:

Hi
Thanks for your response.
I create a new Spreadsheet and add your code to "Apps script" section in "Extensions" menu of the spereadsheet. I run it and allowed the required access to my google account.
This method is correct?
If yes, can you please show me how to update a cell in the spreadsheet using Okhttp?

Click to expand...

emexes said:

I am curious about this too. It sounds like it could be useful as a poor man's cloud database.

Click to expand...