Relationship Condition Dropdown stopped to work after formula update
Team,
I have a challenge to my relationship update. For my relationship I was using "Formula Field" [SMO_Predecessor_Key] which was selected to create conditional dropdown based on its value.
[SMO_Predecessor_Key] used in formula another field [SMO CPS Template] which had some logic in it based on field [SMO].
I no longer need this logic so I decided to rewire [SMO_Predecessor_Key] directly to field [SMO]. After I did it I have problem that my Relationship PROXY field does not work in Legacy Form. It ask to choose [SMO_Predecessor_Key] even if this is already selected.
I notice that if I re-select value in field [SMO] in form (i.e. remove value, select it again, even without saving, this starts to work. So problem is with data which are already filled in.
[QUESTION] - is there a way to force such refresh to all records and to not need to do it 1 by 1 in form?
What I tried:
- I tried to Import records ID# and field SMO but during Import No update to records (as SMO does not change).
- Tried to create new field [SMO_Predecessor_Keyv2] and update Conditional Value to it and back. But not working as well.
This is how dependency of fields looks line (Blue changed to Green)
Current workaround but not well seen by users 😢