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.

Trouble with value lists "by field" and new related records created in portals

Featured Replies

I set up a portal in a layout for table A with respect to related records in table B.  The first screen shot shows the portal -- there is currently one related record, 1041.343US4.

 

post-112239-0-09395900-1417558442_thumb.

 

I created a value list that is used in the portal.  Thus, in the second screen shot, if I click in the box, you can see all the different values.  This is working as intended.

 

post-112239-0-16357800-1417558447_thumb.

 

Now, the problem I'm having is that the value list is not showing up for a new related record created in Table B using the portal from layout for Table A.  See the third screen shot.  If I click in the box, the value list doesn't show up.

 

post-112239-0-27299700-1417558451_thumb.

 

However, if I were to enter anything, and press return to actually create this related record, and then go back to the newly created record, the value list appears.

 

That is, the value list is not showing up.  If I specify the value list as a "static" list (i.e., use custom values), it does work.  But this value list is "from field," specifically "include only related values starting from:" a table C that table A is related to.  (If I say "include all values", the problem goes away).

 

The relationships are as follows.  A and B are related by matter number.  A and C are related by client.  The value list is matter numbers from A, including only related values starting from table C.

 

Again, this works perfectly for any *existing* record shown in the portal.  But, it does not work when attempting to create a new record.

 

I have the relationship between A and B set up so that A can create new records in B. 

 

Let me know if this is clear!  It's a bit of a vexing issue.  I was thinking of work arounds, but nothing has worked so far.

Please avoid abstract names like A, B C... - they are very difficult to follow. I think the problem is due to the new record not being related to the table where the values are coming from, until it's committed. This shouldn't be a problem if the value list were defined correctly - but I am afraid that's the point where I got lost.

  • Author

I actually started working through this problem, and I realize I set it up incorrectly from the start (I think).  I'm going to post a new thread . . . I don't know how to set up what I'm trying to do!

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.