Graphics

 View Only

  • 1.  google sheets

    Posted 05-30-2024 16:32

    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 

    https://docs.google.com/spreadsheets/d/113jf_BXqwE0z3bUnSSAzvuUcsHfnecIU0Lv8arqrVoQ/edit#gid=0

     



    ------------------------------
    TAMER ABDELAZIZ
    ONTV
    CAIRO Egypt
    ------------------------------


  • 2.  RE: google sheets

    Posted 05-31-2024 11:36

    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/



    ------------------------------
    Jeff Mayer
    Ross Video
    ------------------------------

    Original Message


  • 3.  RE: google sheets

    Posted 05-31-2024 13:45

    This also required XPression version 11.5 


    Original Message


  • 4.  RE: google sheets

    Posted 05-31-2024 16:39
    Thanks  Garner thats work 



    Original Message


  • 5.  RE: google sheets

    Posted 05-31-2024 16:38
    Many thanks Jeff is work now 



    Original Message