Multi-select lookup field form rules don't work

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
Parent table is Audits, child table is questions

I have a multi-select field on the parent table called Location(s). On the parent table I can use that field in dynamic form rules just fine - meaning I am able to select 'includes' 'doesn't include' and then I'm given the options of all of my inputs in the dropdown. So i can say when the audit location includes Nashville, show a certain field.
But on the Questions form (child) when i try to create a dynamic form rule based off of the lookup multi-select 'Location(s)' field it doesn't work the same way. I'm still given the option of using 'includes' 'doesn't include', but the next dropdown doesn't give me my only option is to use 'the value in the field'. I can't specify Nashville, for example.

Photo of Trish Wehrle

Trish Wehrle

  • 160 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of AustinK


  • 1,338 Points 1k badge 2x thumb
This seems like a bug to me. I checked a similar field I have and it behaves the same way. The child does not let me do anything. It should at least let you do an includes on the field.

One way around this I found is to create another multi-select text field on the child table with the options that you want to see. If you have another multi-select field then you can do "is equal to the value in..." and choose your new field. I think you would need a field for each set of options, though. 

Looking at what you are doing with city names that "fix" could become a ton of fields really quickly. If you only have a few options in there, this way could work. If there are a bunch then I wouldn't bother. 

There is likely a better way around this issue but I don' know how else. That was just what I could come up with off the top of my head. You might want to speak to support or file an issue about this as I do think it should behave differently too.

I guess you could also have some kind of formula field that would have all the options that were in your multi-select field. Then you could do something to break apart the multiple options(multi-select to regular text it will look like "select1 ; select2 ; select3" etc)  and see what was in there.