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.

Value List based on Calculated Field to filter a portal - Auto-Commit?

Featured Replies

  • Newbies

I have a value list based on two fields: A record ID field, and a "display name" field based on a concatenated First-Last name. This appears in a pop-up menu which filters the portal below it to display the related contact information for the contact selected in the pop-up menu.

Everything works correctly for data entry on a new customer record. My problem is that the pup-up menu on each existing record currently shows the Record ID number for the contact, and not the display name. The portal below does not show any information. To update this, I have to manually select the pop-up menu and re-select my choice for the primary contact. Is there any way to automatically commit this across all my 6500 or so records?

post-106392-0-73103800-1334168298_thumb.

Yes but what is the value that is actually stored in that field? If its the same as the primary field selected via your popup menu then technically you probably should see it work without issue. I would start by evaluating what values are being stored in that field.

If you are still having issues, then post a copy of your file.

  • Author
  • Newbies

The values are the same number format, but they are from a different table.

The drop down menu is used to enter a value into the "PrimaryContactID" field on the Customer record. The values come from a separate Contacts table. Value 1 is the ContactID for each contact for that customer, and Value 2 is DisplayName, a calculated first-last name field.

I have this set up to work with the customer's locations as well - I think the issue is that DisplayName is a calculated field. The location names are plain text and it works out fine.

It shouldnt matter. If you have your ID stored in that field, simply changing it to the same ID itself shouldnt just make it work. I have a feeling that the values in that PrimaryContactID field has a different value in there than maybe you may think.

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.