Comparing Many-to-Many Linked Fields

Ask for Help
1

I had an action button on every Deal record page that would allow the user to update the originators and/or closers of that Deal.

If the logged in user is an originator of the Deal, or a manager over an originator of the Deal, then he can update both the originators and closers.

If he’s a closer of that Deal, or a manager over a closer of that Deal, then he can only update closers.

To achieve this, I was using the “Only show when conditions are met” option on each field. The originators field, for example, would show if either of these OR conditions were met:

  • Deal > originators > id (list) is one of Logged In User
  • Deal > originators > id (list) is one of Logged In User > managed users collection > managed users collection (id)

But recently the second condition broke. Where it used to say “Logged In User > managed users collection > managed users collection (id)” it now said “Invalid item”.

And when I try to select the managed users collection in the data picker, it’s no longer there.

Is it still possible to use a condition of “multiple linked records is one of multiple linked records”? Or was this functionality removed?

screenshot
screenshot1920×1247 138 KB

2

It should be possible, but maybe one of your linked fields was modified in some way?

If you can share the link to that page with us I might be able to tell you more

3

I don’t believe I’ve modified either of those fields.

Here’s the link to the page of that screenshot:
https://app.fundmore.io/deals/view/rec19g6wlw9hzlxw/activity?_parentPage=eyJlbmFibGVkIjpmYWxzZSwiZWxlbWVudElkIjoiUmJ4TFliY0tNIiwicGFyYW1zIjp7Il9xIjoiYXRsYXMifX0%3D

1 Like