10 Replies Latest reply on Feb 8, 2017 2:58 PM by keywords

    Find on a variable responds on the wrong field




      I am creating a reporting DB, in which I enter hours per month each year. I also have first and last names and normal fields like "Comments".  I have a field for year eg "2017", and another for month eg "Jan". I will have many years and months, so I set up a concatenation of year and month to produce eg "2017Jan". I've created a script with a variable to find "2017Jan".


      However I only get a result from the script if the comments field is empty!


      The comments field defaults to "0" if I leave it empty. If I delete the "0" then perform the find that record then shows up in the find.


      This is bewildering to say the least.


      2 questions:


      1 What on earth is wrong?

      2 How do I set up so that all fields with no data remain blank?


      Any help gratefully received. I'm using FMP 12.0v4 by the way.