3 Replies Latest reply on Jul 3, 2014 4:14 PM by philmodjunk

    date [732014] automatically being added to a summary field



      date [732014] automatically being added to a summary field


      FileMaker Pro



      Operating system version

      mac mavericks

      Description of the issue

      the Balance Due field of my invoices started adding the date to the other fields for that sum

      note: have been using 8.5 for yrs and have been on Mavericks for months,
      - nothing chanced recently
      - this problem started today
      - installed v13
      - did not fix problem

      Steps to reproduce the problem

      1. checked what is in the summary field, just what should be there

      2. removed all inputs to all fields including the date field

      Expected result

      2. to have zero in the sum field

      Actual result

      2. has the date as a number in the sum field added to the sum

      Exact text of any error message(s) that appear





        • 1. Re: date [732014] automatically being added to a summary field

               Is balance due a field of type calculation or a field of type summary?

               Your issue report title indicates that it's a summary field, but the layout suggests that it may be a calculation field.

               If it is a calculation field, please post the calculation.

               Since you are certain that nothing has changed, take this file or a very recent back up copy and run a recover on it. Perhaps the file has become damaged in some way.

               Things to keep in mind about Recover:

               While Recover almost always detects and fully corrects any problems with your file...

          1.           The recovered copy may behave differently even if recover reports "no problems found".
          3.           Recover does not detect all problems
          5.           Recover doesn't always fix all problems correctly
          7.           Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.


               And here's a knowledgebase article that you may find useful: What to do when your file is corrupt (KB5421).

          • 2. Re: date [732014] automatically being added to a summary field

                 Thx PhilModJunk!

                 It says it is a calculation - see two more screen shots attached.  Let me know if this changes the way to approach fixing this problem.

            • 3. Re: date [732014] automatically being added to a summary field

                   Do you see this only on this record?

                   Here's what this looks like:

                   If you enter a date into a text field and then include that field in a calculation, you'll get the digits from the date field as shown in this post.

                   If you enter a date into a number field and then use that number field in a calculation such as adding 0 to it, you'll get the digits of the date also.

                   I'd check the value of each and every field listed in that calculation by clicking into the field and checking for data. By clicking into the field, you check to make sure that the value isn't hidden by having a return put it on a different line than the single line visible on your layout.