EnumList with Ref "ADD" option

Hi everyone,

I am struggling with EnumList + Ref. Actually all works good but cannot find way to get what I need. The thing is when I add a formula for Valif_If constraint to get the values from referenced table I loose the ability to add “new” value to the referenced table. I will try to show you what I mean.

I have a column called Tags and this is its configuration


In the Valid_If I put this:

To get this:

But maybe there is a way to get this above plus ability to ADD new tag like here (this appears only when I leave Valid_If blank):

What is more when I ADD Tags[ID] formula to Suggested_Values I get this:

Maybe someone knows the solution? Maybe and probably I made mistake…
Thanks in advance for any help!
Cheers

Solved Solved
0 2 144
1 ACCEPTED SOLUTION

EDIT
I do not use Valid_If using Suggested_Values
It looks like this:


When I put Tags[Tag] instead of Tags[ID] I get this (could say it works but now don’t understand the reason of yellow triangles):

EDIT
It was the problem… As always small hidden problem. My bad!
Instead of TEXT there was NUMBER.
Thanks @Steve!

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4

If using Suggested values here, do no use Valid If.

Please post a screenshot of your Suggested values expression.

EDIT
I do not use Valid_If using Suggested_Values
It looks like this:


When I put Tags[Tag] instead of Tags[ID] I get this (could say it works but now don’t understand the reason of yellow triangles):

EDIT
It was the problem… As always small hidden problem. My bad!
Instead of TEXT there was NUMBER.
Thanks @Steve!

Top Labels in this Space