Model with two Ui only formula fields (Field A and B) that use Model_Lookup to different models
I then have a third Ui only field (Field C) that is a formula and subtracts B from A.
This all works great until the user tries to search the table/model. As soon as it starts searching, it was locking the search bar. I traced this back to the fact it was registering an unsaved change in the model and hence locking the search bar.
Solutions:
- Hitting save/cancel on the table allows the user to continue searching
- Removing Field C from the model prevents the unsaved changes issue
- Adding a model action to save the model upon requery (seems to be working, but is constantly saving the model)
I’m not sure if its the intended design to have these fields trigger unsaved changes on the model. Saving/canceling does not actually do anything as the formula renders regardless. Right now I’m using solution #3. 2 is not viable as I need the field and 1 is not practical because it interrupts the user as they type.