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.

Saving import order for a Multi-User DB

Featured Replies

I have a database that will be a multi user file. The majority of the information entered into it will be from importing excel files. Many users will need to import into it. Is there a way that I can save the import order so that it is the same for all users? We don't want to have to keep re-mapping.

Thanks

FMP 6 does only have one mapping if someone screws it up, everybody suffers. Have you considered Apple Script, such matters can be stored in separate records, where you choose the import'ish transferes indiviually designed to suit the particular task. But read what Fenton writes about Applescript in calc'fields:

http://fentonjones.com/Articles/25_Bookmarks.html

--sd

  • Author

Does FM 7 Have multiple mapping?

If you want to have different mapping, just change your scripts.

  • Author

Sorry I didn't make myself clear. I don't want different mappings, I want multiple users, that are connected to the DB at the same time, to be able to enter data in the same order but not have to re-map each time they launch the database. If I need to make a script I will, but not really familiar with doing so.

(We will be getting in Excel forms that are being filled out by a diiferent department, and we don't want to key in all of the information. So the easy solution is to import, but the mapping disappears after you close the database. I want it to stay stationary at all times.)

Once you perform an import, create a script with the Import Records step, having 'Restore import order' selected. Whenever this script is run, it will use the saved mapping.

And, yes, FM 7 allows you to specify the import order within the script step and, therefore, save multiple mappings within a single script.

  • Author

Thanks. That is a big help.

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.