On Jul 24, 8:24 am, Otter <[email protected]> wrote: > Thank you Justin for your reply. I fixed my spreadsheet as you > indicated. So like today is the 24th. Shouldn't it be showing the 24th > tip instead of the first tip? I want it to show a different tip each > day of the month and at the end of the month it starts over at the 1st > again. How would I do this? Any help would be great. Use the same technique as is used for the image. First write the tag without a src attribute. Then use javascript to set the src of the iframe to a URL that varies depending on the day. The "varies depending on the day" part can be accomplished using the Date.getDate function: https://developer.mozilla.org/en/Core_JavaScript_1.5_Reference/Global_Objects/Date/getDate
> > Thanks again for your help on this > > Mike > > On Jul 23, 5:15 pm, Justin McConnell <[email protected]> wrote: > > > On Jul 22, 8:30 am, Otter <[email protected]> wrote:> My gadget now > > > displays all 31 tips with a scroll bar down the right side. > > > From looking at your gadget code, I can see that the range of cells is > > specified in the range parameter of the src attribute of the > > iframe:http://spreadsheets.google.com/pub?key=rmVL44BQKlEm8aL_Th4-SIg&single... > > range=a1%3Aa101 tells the server to return cells a1 through a101 > > > > I want it > > > to only show 1 tip per day. What have I done wrong. > > > Specify a range from a1 to a1. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "iGoogle Developer Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Gadgets-API?hl=en -~----------~----~----~----~------~----~------~--~---
