5 Replies Latest reply on Nov 21, 2018 3:05 PM by Penn Wang

    How to create a dropdownlist without null value

    Penn Wang

      Hi Everyone,

       

      This could be an easy question, just couldn't get my head around.

       

      I have a datetime column which data keeps rolling in. I have created a dropdownlist (see below) however there is an option for choosing null value. I can't simply select all the values other than null because there will be new month/year.

      Capture.PNG

       

      I am thinking about creating a calculation field to filter out null value first, then build a dropdownlist on the new column.

       

      Thank you.