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

Can anyone throw some light on this problem?

I have a simple table of addresses, linked to a person table. There are two auto-enter by calc fields. One is Line1 & Line2; the other is Suburb & State & Postcode. Really complex stuff. Both have 'do not update' unflagged. Both have do not calc if all empty. The basic fields are entered in a portal when new people are added. Recently, for a new batch of people, these calcs have stopped working on initial entry - but only for some people. On my system, if I change the Suburb, for instance, the calc works. At first glance, it looks as though the Address records in the portal are not being committed - ever!

My customer is using V8.5 (on WIN XP) but, recently, I upgraded to V10 (on Win 7) In theory, this should be irrelevant but I can't help wondering.

If your fields are indeed named as you typed them in your post, then FM Help states ...

[color:blue]Field names must be unique, and can contain up to 100 characters. Follow these guidelines when naming fields:

Do not use any of the following symbols and words in the field name:

,(comma), +, -, *, /, ^, &, =, ≠, >, <, ( ), [ ], { }, ", ; (semicolon), : (colon), :: (relational indicator), $ (variable indicator)

• AND, OR, NOT, XOR, TRUE, FALSE, or the name of any FileMaker Pro function

• Don't begin a field name to be used in a calculation formula with a space, period (.), or number.

• Use _ (underscore) in place of a space to avoid restrictions in ODBC, exporting, web publishing, and other operations.

• If you're exchanging data with another application, check the field naming restrictions in the file formats supported by that application.

• If you're using ODBC or JDBC to share FileMaker Pro data, avoid using SQL keywords in field names.

Maybe it's causing or contributing to the problem.

  • Author

Thanks, Iawaid. You had me worried for a moment. My field names are all fine. I'm guessing you objected to the '&'s. My 'Field1 & Field2' referred to the calculation. My fields are Field1 and Field2.

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.