Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Troubleshooting and Isolating a Bug

Jonathan Veit
in Damaged / Corrupt File Problems

Featured Replies

So I'm neck deep into my first database design using filemaker and would describe myself between novice and intermediate.  The needed functionality was prioritized over well thought design due to time concerns so there is a lot of going back after the fact and fixing being done.  I'm prefacing so I can perhaps be spared the lecture - I know this is a bad form but the company I work for needed a solution quickly.

 

So now my database is producing a bug I'm trying to understand and fix.  For some reason the text within the projectName field of my Projects table has been occasionally repeating itself within the field.   For example, if the project is titled 'Hyatt Hotel - New York', at some point is modified to be: 

 

"Hyatt Hotel - New York

 

Hyatt Hotel - New York

 

Hyatt Hotel - New York"

 

sometimes repeating over 20 or so times.   I don't know what's triggering this and was hoping there might be some suggestions for isolating the problem.  I figure something within one of my many scripts is causing the problem but not sure even where to begin.  I don't have a copy of advanced filemaker so I don't have a debugger but maybe there are ideas or methods to isolating the problem.  

 

I couldn't really find a proper forum category for this problem so sorry if this is miscategorized.  Thanks for any help in advance.

 

Jon 

First check the auto-entry options of the field to make sure there's no calculation doing that.

Then since you don't have debugger, you could print your scripts to a PDF, which you can then search for that field name, and see if there's a Set Field script step that's the culprit.

  • Author

Checked both of those but nothing turned up.  Saving the scripts as PDF as searching them was a very useful tip but nothing shows me why this would be happening.  It seems to happen on the most frequently access projects but I still have problems isolating the problem.  If anyone else knows a possibility or ways of isolating the problem I'd appreciate it.  Thanks!

Are there some trigger attached to the projectName field ?

Create an account or sign in to comment

https://fmforums.com/topic/87167-troubleshooting-and-isolating-a-bug/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.