Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
  1. #1
    New to the CF scene
    Join Date
    May 2010
    Location
    Auckland
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to create web page using google spreadsheet json?

    we have a google spreadsheet with manager and team details. I got to the point how to extract/filter a single line formatted as json (as shown below). What I would like to create is a page similar this one (only the address portion) http://www.aucklandfootball.org.nz/index.php?id=62

    I have no idea how the coding needs to look like making use of a raw data formated as json.

    Not sure if you hate me for it - but I am using expression web to create our site. I am not a programmer - however can understand code once I see it.

    Using this query....
    http://spreadsheets.google.com/tq?ke...pporters%27%29

    ...I get below json. How from here to a proper page?


    google.visualization.Query.setResponse({version:'0.6',status:'ok',sig:'1763367110',table:{cols:[{id:'A',label:'Timestamp',type:'datetime',pattern:'dd/MM/yyyy HH:mm:ss'},{id:'B',label:'TeamID',type:'number',pattern:'#0.###############'},{id:'C',label:'Divisio n',type:'string',pattern:''},{id:'D',label:'Team Name',type:'string',pattern:''},{id:'E',label:'Ground Name',type:'string',pattern:''},{id:'F',label:'Manager (Full Name)',type:'string',pattern:''},{id:'G',label:'Manager email',type:'string',pattern:''},{id:'H',label:'Manager Home phone',type:'string',pattern:''},{id:'I',label:'Manager Mobile phone',type:'number',pattern:'#0.###############'},{id:'J',label:'Assistant Manger (Full Name)',type:'string',pattern:''},{id:'K',label:'Assistant email',type:'string',pattern:''},{id:'L',label:'Assitant Home phone',type:'string',pattern:''},{id:'M',label:'Assistant Mobile phone',type:'number',pattern:'#0.###############'},{id:'N',label:'Colour: Home Shirt',type:'string',pattern:''},{id:'O',label:'Colour: Home Shorts',type:'string',pattern:''},{id:'P',label:'Colour: Home Socks',type:'string',pattern:''},{id:'Q',label:'Colour: Away Shirt',type:'string',pattern:''},{id:'R',label:'Colour: Away Shorts',type:'string',pattern:''},{id:'S',label:'Colour: Away Socks',type:'string',pattern:''},{id:'T',label:'Colour: Away Socks',type:'string',pattern:''}],rows:[]}});

    Thanks for some ideas, help or even lines of code.

    Cheers
    Last edited by asfa.webmaster; 05-13-2010 at 12:07 PM.


 

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •