3 Replies Latest reply: May 11, 2015 5:41 PM by Shannoy Panankoodan RSS

    Dynamic Status display using Text Boxes

    Shannoy Panankoodan

      I have a field "Frequency" with the following values

      Weekly

      Monthly

      Yearly

      Daily

       

      When my QV document opens I want to display text boxes as below:Display.jpg

       

      The color indicators show the latest status.

      "Status" has following values:

      Ended

      Failed

       

      The challenge is all the frequencies run on different dates for e.g the respective calendar dates for the "Frequency" are as follows

      Weekly- 08/05/2015 (Changes Every Friday)

      Daily- 11/05/2015 (Changes Daily)

      Yearly- 01/01/2015 (next year 01/01/2016)

      Monthly - 01/05/2015 (Next month it would be 01/06/2015)