We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now


filemaker scripts query

Medium Priority
Last Modified: 2012-05-06
I am relatively new to modifying filemaker and am creating my first script inside of it. The script is finding a group of people with 6 months left on their subscription and listing them, I then need to automatically have it update a discount field so everyone gets offered 25% off.

I have completed the first two stages but can only get the 25% discount on the first found entry. How do I set the repetitions value so that it will encompass any number of results?
Watch Question

FileMaker Developer at Cognitive
To set the amount or discount use the Replace Field Contents script step not Set Field (which just does the current record).

The script step may have different names in different versions. You can manually test this by choosing the command from the Records menu when in browse mode. It replaces the values for the selected field for all found records.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


Was exactly what I was looking for, thanks
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.