AnsweredAssumed Answered

Find on a variable responds on the wrong field

Question asked by MarkPage_1 on Feb 8, 2017
Latest reply on Feb 8, 2017 by keywords

Hi,

 

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.

 

Cheers

 

Mark

Outcomes