Skip 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.

Wading through ScriptMaker...

Featured Replies

...for the first time (almost).

How does one execute functions within a script? I'm thinking specifically about the let and copy functions. They don't appear in the list of script steps, and ScriptMaker won't let me manually type them in. I've tried going through the help, but can't find anything.

What am I doing wrong or missing?

Thanks...

Use the setfield script step. You specify the field and define the calculation.

There are many script-steps (in addition to Set Field[]) which allow/require a calculation within them. The Let[] function would be used within one of these calculations. Copy is NOT a function and can't be defined within a calculaton. It is a script-step which can be found under the Editing section (to copy a field value) and under the Records section for copying one or more records. Copy puts data on the User clipboard so should be used sparingly.

A script step is the action to perform. A calculation (within a script step) is used to specify the desired outcome. And functions drive the calculation. Example:

You want to set a field with a value of today's date + 5 days. Here's how it goes -

Script step: Set Field[ ]. Which field to set? Specify that in the Set Field Options button.

Set the field with what? Calculated Result button reveals calculation box.

Calculation syntax to set the field would be: Get(CurrentDate) + 5

The function being used here is Get(CurrentDate) and the '+' is the Operator.

Just start creating test scripts and putting stuff in them. You'll pick it up very quickly! Always back up before running them though. And NEVER ... EVER ... turn Allow User Abort to OFF (particularly if you use a loop) until you are sure your script is perfect. Open your FM Help (F1) and search for: Copy Script Step, Let[] function etc ... it covers all the basics and even provides example scripts to play with. :wink2:

LaRetta

Uhm.. off topic: that F1 thing is for Windows. The Mac keyboard has a dedicated help key, or you can use Command+?. Highly recommended though, I agree.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.