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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Substitution scripting problem, NEED help please!

April 26, 200421 yr

I am running a script to do multiple substitutions of text in a global field running fmp 7. I was told that it could be done but I have been unable to get it to run.

My script is:

Go to Record/Request/page[First]

loop

Set Field[completed_template; Substitute(template; "the_item_name"; item_name)]

Set Field[completed_template; Substitute(template; "the_item_id"; item_id)]

Set Field[completed_template; Substitute(template; "the_item_case"; item_case)]

Go to Record/Request/Page[Next; Exit after last]

end loop

item_name, item_id, item_case, completed_template are all text fields

template is text global

The script runs but only substitutes every occurace of "the_item_name" for item_name in the global field and does not substitute either of the two other substitution fields.

Can anyone see what the problem is? Where am I going wrong? Thanks