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.

Importing data and keeping the modifications?

Featured Replies

  • Newbies

The problem I'm having is when I import information, I lose all the information that I entered/modified. Is there a way to keep information that I enter while also importing new data to update the file? I have 8 fields I need to import and update as the file is always changing, and 1 fields I need to enter new data into, not connected to the master file. When I want to update I import the new data but lose the data I entered. ex-(entering notes for a specific record after importing). I use basic scripting to display specific records, if that causes a problem. But otherwise I just import, enter notes, update, and then the information is gone. Does FMpro5.5 have to capabilities to do this? Thanks...

If I understand what you are saying I just had the same situation and this is how I solved it. If your problem is that you have data in a field and then when you run the import the imported data overwrites your data that was in the field. We will call your field Field A

Set up 2 new fields Field B Field C

When you run your script to Import. Add a step that will replace Field B with the contents of field A, import your imported data into field C, replace Field A with Field B & Field A

>>Enter Browse mode

>>Show ALL Records

>>Replace Field B with Field A

>>Import Records (into field C)

>>Replace Field A with Field B & Field C

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.