I’m trying to work through a condition logic issue and having some trouble. I have model A which has a location field. I am trying to activate and set the value of model B with that location when it is selected from model A to only pull model B records at that location. Model B data is then used in a Ui-Only field Model lookup on Model C.
Currently I have a condition on model B set to == the location value from the first row of model A. This condition is activated and value updated on model A updates on the location field.
All of this works as expected when I select a value.
Except for two things:
I would like when location is set to -None-, all of the records from model B are pulled in.
I have not found a way to do this other than have the “Clear Location Filter” button that deactivates the condition on Model B, but I would love for it to be automatic and not rely on the user to manually reset it.
Should I do this with a JS snippet to run on model A update of location field to check if the field is null then activate/deactivate the conditions accordingly? Was trying to do it with the action framework but can go to JS if thats the only way.
My second issue is related to a UI only formula field on model C that depends on the model lookup field being altered above. When I change my location, the model lookup field works great, but the simple formula field which is just doing subtraction changes to 0 on all records. Re-querying the model does not help. I thought I saw something on here about an issue related to ui-only formula fields based on other ui-only formula fields. Not sure if its related to that or if its an asynchronization issue.