2 Replies Latest reply on Feb 21, 2016 6:58 PM by KrisYells

    List Status from Conditional Values List

    KrisYells

      Hello all,

       

      I am tracking properties (land) and the statuses that go to each property. I have aobut 60 different statuses that are all in a condidtion value list by status category then the actual status. The statuses contain the ID field, which matches the id of the property, status field, date field.

       

      Currently I can only get Filemaker give me the statuses listed by status and it will only show properties that have a status. See the first grid below. (the columns names are the field names)

       

      I would like to have Filmmaker give me the list showing all the properties and add new columns for the various statuses that are in use, or be able to select which statuses I want to see. (I would like to have the status as the column name and use the date of the status as the value in the grid)

         

      ParcelStatusDate
      Property 1Signed5/6/2015
      Property 1Mailed5/6/2015
      Property 2Signed5/6/2015
      Property 2Mailed5/6/2015

       

       

       

         

      ParcelSignedMailed
      Property 15/6/20155/6/2015
      Property 2
      Property 35/6/20155/6/2015

       

      thank you.