why aren't you using merggoogle again? It has issues but it would be easier to get going.
On Thu, Nov 15, 2018 at 3:06 PM JJS via use-livecode < use-livecode@lists.runrev.com> wrote: > i used this 3 years ago, found some examples and altered it a bit, still > works ok. > > we used this to find info back on what others had added to the list. > > you have to select the columns you want to read in the SELECT statement > in the script, you have to play with this > > the script shows you that i used some buttons and fields > > > cardscript: (add your key!) > > *local*sBrowserId > > *function*browserId > > *return*sBrowserId > > *end*browserId > > *on*browserBeforeNavigate pId, pUrl > > *global*browserCancel > > *if* "spreadsheets.google.com"isnotinpURL *then* > > *answer*warning"Won't allow you to go to a domain outside this page!" > > *put*trueintobrowserCancel > > *end* *if* > > *end*browserBeforeNavigate > > *on*closeCard > > *#if the hilite of btn "Browser ON" then* > > *#unhilite btn "Browser ON"* > > *#end if* > > *#set the vScroll of fld "theText" to 0* > > *pass*closeCard > > *end*closeCard > > *on*openCard > > altBrowserOn > > *pass*openCard > > *end*openCard > > *on*altBrowserOn > > *local*tWinID > > *put*thewindowidofthisstackintotWinID > > *local*tBrowserId > > *put*revBrowserOpen(tWinId, > " > https://spreadsheets.google.com/tq?tqx=out:html&tq=SELECT%20A%2C%20B%2C%20C%2C%20I%2C%20J%2C%20K%2C%20L&key=YOURKEYGOESHERE&gid=0";) > > intotBrowserId > > *if* tBrowserId isnotainteger*then* > > *answer*"Failed to open browser: "& tBrowserId > > *exit* altBrowserOn > > *end* *if* > > *put*tBrowserId intosBrowserId > > revBrowserSet sBrowserId, "showborder", true > > revBrowserSet sBrowserId, "rect", therectoffield"veld" > > *end*altBrowserOn > > *on*altBrowserOff > > *if* sBrowserId isaninteger*then* > > revBrowserClose sBrowserId > > *end* *if* > > *put*emptyintosBrowserId > > *end*altBrowserOff > > > button refresh: > > *on*mouseUp > > *local*tBrowserId > > *put*browserId() intotBrowserId > > *if* tBrowserId isnotaninteger*then* > > *exit* mouseUp > > *end* *if* > > revBrowserRefresh browserId() > > *end*mouseUp > > > button to find something in the list: > > *local*tVind > > *on*mouseUp > > *local*tBrowserId > > *put*browserId() intotBrowserId > > *if* tBrowserId isnotaninteger*then* > > *exit* mouseUp > > *end* *if* > > *put*field"findthis"intotVind > > revBrowserSet tBrowserId, "selected", tVind > > *Put*emptyintofield"findthis" > > *end*mouseUp > > > Op 15-11-2018 om 19:04 schreef dunbarxx via use-livecode: > > No good. Somewhere the last char of the text of a google sheet is > inserted > > three times in the body of the html tag suite. So adding a delimiting > char > > of any kind is futile. > > > > I still think I am overthinking this. > > > > Craig > > > > > > > > -- > > Sent from: > http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
