3 Replies Latest reply: Apr 4, 2017 3:50 AM by Benedikt Neumayer RSS

    QV: Reflect single value in textbox

    Benedikt Neumayer

      Dear all,

       

      I am trying to create a textbox that reflects a single string value depending on the current selections and a formula integrated in the textbox itself.


      Textbox currently contains the following query: =if([Event Year]=2017), 'Resort')

       

      My Database is organized this way:

       

      Event YearEventResortGame
      2017

      World Cup

      A-CityGame 1
      2017World CupA-CityGame 2
      2016World CupB-CityGame 1
      2016World CupC-CityGame 2
      2017European CupD-CityGame 1
      2016European CupE-CityGame 1


      Now, as soon as the user filters to event "World Cup", the textbox should be able, with the help of the if-formula, to reflect the respective single value, as for 2017 there is only one distinct value in this column?

       

      However in order that the formula correctly shows "A-City", I have to filter to Event year 2017 with the help of a listbox.

       

      Does anybody see the mistake I am making, or the information I am missing?

       

      Thanks a lot

       

      Benedikt