11 Replies Latest reply on Jun 12, 2014 3:29 AM by uday.kumar.1

    1 Quote per day from database...

    Jeremy Wilcock

         As a tile in a dashboard that is sent out daily, I'd like to include an Inspirational Quote that changes each day.  I have an excel table I will use with one quote per line.  I've thought I could maybe use something like the following to get the row number to use for the day:

       

      INT(TODAY()) % TOTAL([Number of Records])

       

      I'm not sure how to go about actually displaying just that row of data though.  Any ideas?