Issues with Multi-Select Lookup Field
I am creating automated Tasks from certain Projects. (One Project has many Tasks). In Projects is a Multi-Select Field [Selected Coverage Types] and it has a lot of Dynamic Form Rules based on what's ...
Forum Discussion
I was able to duplicate your problem. It seems to be a limitation of how the form rules treat those multi select lookup field types.
But when Quick Base closes a door, sometimes we just need to get in though a window.
I had a field on the parent record with a multi select list of fruits.
I looked that up to the child record.
I then created a Multi select formula field called [Apples] with a formula of
"Apples"
The formula box editor was not happy (yellow), but the formula saved OK without error.
I then put in a form rule on the child were the [Multi select fruit lookup field] "includes" the value in the field .... and lo and behold, it offered my up that [Apples field] as a choice.
So just create any choices you want as single value multi select formula fields and then use them in the form rules on the child.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But when Quick Base closes a door, sometimes we just need to get in though a window.
I had a field on the parent record with a multi select list of fruits.
I looked that up to the child record.
I then created a Multi select formula field called [Apples] with a formula of
"Apples"
The formula box editor was not happy (yellow), but the formula saved OK without error.
I then put in a form rule on the child were the [Multi select fruit lookup field] "includes" the value in the field .... and lo and behold, it offered my up that [Apples field] as a choice.
So just create any choices you want as single value multi select formula fields and then use them in the form rules on the child.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
So I feel like an idiot. I had forgotten that I already had the answer, but I got busy with other projects and other work related issues and I ended up forgetting about it and for some reason thought it didn't work when I never got to try it out, and I ended creating other fields and messed it up worse.
So what I originally did was create a Multi-Select field in the Tasks table [EGCI Selected Coverage] and it has the same list of items in it as the one in the Projects Table. And with the automation I am using to help create the task, I have the Tasks Multi-Select field the Projects information copied into it. And it works. The information I need is transferred and I can still use the Rules in the form to do what I need.
But if I wasn't using an automation that would be the great way to go. Thank you Mark! Thank you Jan!
------------------------------
Matt Gill
------------------------------
So what I originally did was create a Multi-Select field in the Tasks table [EGCI Selected Coverage] and it has the same list of items in it as the one in the Projects Table. And with the automation I am using to help create the task, I have the Tasks Multi-Select field the Projects information copied into it. And it works. The information I need is transferred and I can still use the Rules in the form to do what I need.
But if I wasn't using an automation that would be the great way to go. Thank you Mark! Thank you Jan!
------------------------------
Matt Gill
------------------------------
