Graphics

Request. Is it possible to put the Google Docs/Drive function in a future xpression update? I like the way Google spreadsheet works it would be nice if I can login with DataLink to it and pull data from it.

[COLOR=#000000]There is no native datalinq for google sheets, but Google Sheets can publish the sheet to an XML feed (albeit not as a nice spreadsheet but more as a cryptic xml tree, you'll see what I mean when you try this).

Go to your google sheet and choose File->Publish To The Web, and hit Publish.

Now set up an RSS datalinq and set it to this URL: [/COLOR]https://spreadsheets.google.com/feeds/list/[COLOR=#000000][FONT=Tahoma] Key>//public/full

Replace with the key that you see in the URL when you just open up your google sheet. It should be a long series of random characters.[/FONT][/COLOR]
[COLOR=#000000][FONT=Tahoma]Replace with the number of the sheet you want to link to. First sheet starts at 1, second is 2, etc..

Set the RSS datalinq to refresh every couple of seconds..

This is not something Ross Video officially supports nor have done any testing on, so use it only after you've given it a thorough vetting! [/FONT][/COLOR]
#XPression

Thanks. Going to try it and post results here.
#XPression

I would like to be able to use Google Sheets as well, but need to continue using the %RELID% function. Any suggestions?
#XPression