Skip 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 info (field content) without duplicates

Featured Replies

Hi, I'd like to find a way to import content of a field from every records but I don't want to see the same exact content more than once.

My BD has a lot of bibliographical references here and there (basically everytime an historical information is inserted, there is also a "reference" field). What I want to do, is to have a Bibliography of every reference in one record, but I know that some references are used more than once and I don't want the same reference more than once in the bibliography. If i do a script with a copy and paste, is there a way to tell the script to verify if that reference is already in the bibliography and not to copy/paste it if it is?

Thank

If I understand your structure you have "history" records and with each record a field - "Reference" into which you insert (one?) reference. You would like a single field which contains all the references with no repeats. Can I assume the single field is a global? call it Bibliography

First define a Value list "Refs" which is the values of the field reference in BD (show all values). Now define Bibliography = ValueListItems("BD";"Refs"). That should provide you with a list of unique references.

One further point - if you have more than one reference in the field Reference that is not a problem so long as you separate them with carriage returns.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.