How to receive data from Google Spreadsheet?


#1

i to want send data through Spreadsheet to app.
i’m using webviewer component, where i want to change weblink through spreadsheet.
can anyone help me to do this


#2

u can use this


#3

but this is paid can you give me


#4

yes its paid .
only $5


#5

sorry. mai tumhe pay nahi kar sakta kyu ki mai abhi sikh rha hu.


#6

https://puravidaapps.com/spreadsheet.php


#8

i have tried this,


how to get perticular row&Column value and replace for webviewer link


#9

Did you try the tutorial?


#10

yes
but how can i do.
i want to change links of webviewer component using spreadsheet automatically when i change it in spreadsheet how can do this


#11

Never tried that before. So can not help you. Play with the tutorial and test some things. You will learn from that.


#12

okk thanxx
this tutorial is for sending data to spreadsheet using app

  • but i want to receive data from spreadsheet automaticaly for perticular component like webviewer.

#13

I was used this tutorial to receive data from spreadsheet using Spreadsheet Query(almost SQL), and works for me!


#14

Can you send me block images or .aia file


#15

You need to first go to “Preparation” part of tutorial in https://puravidaapps.com/spreadsheet.php to prepare your google spreadsheet.

For strSelectUrl in example below you must use https://spreadsheet.google.com/tq?tqx=out:csv&key=YOUR_SPREADSHEET_ID&tq=

Then you get the ID of your sheet, now see the blocks


Data or Value Exchange using Spreadsheet
#16

it does not look like you read the complete tutorial?
see chapter "SELECT using the Google Visualization API"
https://puravidaapps.com/spreadsheet.php#select
see also the screenshot from @tiagoks … thank you @tiagoks

Taifun