google sheets

Graphics & Virtual
1

Hi all,

its 1st time to me work with google sheets and datalinq.

So

1st* I create a google sheet as a test and add sheet1 sheet2

2nd* I copy the link to Rss / HTTP Datalinq Source and make it dynamic URL

till now all is fine

my problem is

1- when i Browse the data i find only sheet1 plus all in one line ( so how i can find sheet 2 )

2- when i link it to text it reeds all caulomes and cells in one text ( so how i can link every cell in 1 text as excel

so any direction in this

there is attached phots

and the google sheet link

810×648 101 KB

929×717 106 KB

1062×612 74 KB

473×761 19 KB

420×770 17.7 KB

2

Tamer,

You won’t be able to just use the URL of the sheet…You’ll need to publish each table to the web as a CSV file, then set up separate Datalinq sources for each table.

All of the steps are shown in this video:

https://www.rossvideo.com/resources/ross-university/google-sheets-as-a-datalinq-source/

3

This also required XPression version 11.5

4

Many thanks Jeff is work now

5

Thanks Garner thats work