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.

Variables inside Constrain Found Set not being processed correctly

Rich S
in Script Workspace and Script Triggers

Featured Replies

This one's driving me crazy because when I manually enter the date range in the appropriate field during a Find the data comes up fine. However, when when the script calls the variables--which have the same dates I used when manually performing a Find--FileMaker sticks its tongue out at me. There's something amiss with the script step, Constrain Found Set [Restore], but I can't figure out what.

Open the attached file, click on the Lists button, then click the GO button for the "...or Date" side of the layout; have the Script Debugger and Data Viewer open.

Everything works until the script reaches the marked script step, Constrain Found Set (under the Constrain by Date section) when it uses the variables $_DateFrom and $_DateTo. Why aren't they being processed as they should to constrain the found set? The Data Viewer shows the dates correctly and I have the ellipsis in as well so I literally just don't get it. :S

I'm sure it's something obvious that I'm missing and will kick myself later for it. TIA for your help!

Class Admittance Permit Copy.fp7.zip

Hi Rich,

You have $_DateFrom…$_DateTo in your Constrain. Restored finds require static text or variables and you have combination of the two.

Create a variable with: $_DateFrom & ".." & $_DateTo then use that variable instead.

  • Author

Ah! Learn something new everyday. Thanks again, LaRetta!

  • 3 years later...
  • Newbies

Helped me a lot.

Create an account or sign in to comment

https://fmforums.com/topic/81543-variables-inside-constrain-found-set-not-being-processed-correctly/
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.