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.

Calculations not occuring on Import

Featured Replies

I have a table that has a field call Constant which defined as a calculation with a calculation of "1". I have another field in the table called RecordID which is defined as a calculation with a calculation of "Get(RecordID)". When I import records into this table, unless the "Perform auto-enter options while importing" box is checked, these calculations do not occur so the fields are empty. This was not the case in FM6 and below. Any thoughts?

Try setting the calculations as unstored.

Open the calc field. Click Storage Options. Check the box for "Do not store calculation results ..."

This would actually be necessary for your RecordID field to work properly.

As for the Constant field, I'd suggest using a normal number field with an auto-enter value of "1". Though this would mean for importing you'd still have to check the "Perform auto-enter ..." box.

  • Author

Sounds like something else I am going to have to break my habit of doing. Setting RecordID to unstored is not going to help me since I use that data in relationships. Previous versions of FM didn't have this problem. Not a big deal really. It's just that I'd rather not have lookups and auto-enters occur when importing data into a clone, but I do need the Constant and RecordID to calculate.

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.