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.

Please help make my scripting easier

Featured Replies

  • Newbies

I have gotten myself into a rather tedious scripting scenario. I have a rather large script (about 300 steps, many of which are repetitive.) Is there a way to speed things up at all when duplicating large numbers of steps. I would take any of the following suggestions:

1. Export the script to plain text and re-import when finished.

2. Copy blocks of the script and move them as a block (I can only seem to move one step at a time, not a block)

3. Any way to actually enter code directly, not via point and click.

I am running FileMaker Pro 8.5. I have a feeling I may need FileMaker Advanced to do some of these things...please tell me I'm wrong.

Thanks in advance

.... you shouldn't have to duplicate that many script steps. What does your script do?

  • Author
  • Newbies

I know there are probably numerous ways this could have been designed better, but this is what I have to work with. I have attached a sample of one of the simpler scripts. Basically the script will fill in an employee's hours for a specific day. Employee's working the same hours will be filled in based on the previous employee's times. This way the times of 30 employees can be entered only once per unique time (hours vary greatly on a daily basis.)

It doesn't seem all that complex:

If field A is empty [clear fields A1-A6]

if field B is not empty AND field B1 is empty [copy value of fields A1 thru A6 into B1 thru B6]

if both fields are empty [do nothing]

This same action occurs for up to 30 employee fields. Hopefully this makes some sense...

script.png

The question here isn't so much one of scripting but why the structure requires replication of information... and not even to a related structure.

What is the actual information being passed and why?

  • Author
  • Newbies

Thanks for the quick replies. The data consists of the following:

Employee name and 3 sets of start/end times (and a few calculations not relevant to the script: total hours worked, pay rate, cost, billing cost)

For any given day there can be up to 30 employees working, each with different start and end times. The idea is when a group of employees have the same times (which happens frequently) you would only have to input the info for one employee.

Thanks again for the help.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.