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.

Featured Replies

I am working on a database that has fields named with bullet points in the names. I see that FMP will update "each layout and any field references used in calculation or summary fields" per this link Filemaker Help.

 

I want to make sure I am not going to break any scripts if I update the field names. Can anyone assure me that FMP will update the field names in any scripts that may access or write to said fields?

 

I could ask rather is there anything that is not updated when a field name is changed in the define database dialog?

 

Thanks in advance!

Do you think that FileMaker Help is misleading you on this?

  • Author

Not sure if your trying to be sarcastic. No, I don't think they are trying to mislead me. How ever their documentation does not state that it updates script references. It only emphatically states "When you change a field name, FileMaker Pro changes the name on each layout and any field references used in calculation or summary fields."

 

 

I was not aware if the term "calculation" was referring to all scripts or calculations in calculated field.

Anyway, To anyone who might be as stupid as me. I found they answer elsewhere...

 

 

It is safe to update field names, FMP is smart enough to update all necessary references within your database. 

 

Thanks for the help.

Except for script steps that use hard-coded field names like:

- Set Field by Name

- anything that uses the ExecuteSQL function

 

There are a few more probably that I'm forgetting

  • Author

Except for script steps that use hard-coded field names like:

- Set Field by Name

- anything that uses the ExecuteSQL function

 

There are a few more probably that I'm forgetting

Thanks, Hope I did not have any of those in my database.  :laugh2:

If a field named in a ScriptParameter it will not be updated as far as I can tell.

There's a blog post at Six Fried Rice that discusses the cases where changing field names will break a script; it also provides a workaround solution using the indirection technique. It might be worth taking a look at.

 

http://sixfriedrice.com/wp/set-field-by-name-exposed/

Create an account or sign in to comment

Important Information

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

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.