Trouble with more complex interactions
Old dog learning new tricks here. Long time .NET guy transitioning to QB...
I have a form that needs to have (on edit and add):
An initial selection in the first field
Several fields auto-po...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendI believe I understand your roadblock, and the fundamental problem is that the form needs to know when to fire the Form Rules to refresh the editable field with the value from the lookup.
Would you consider adding a radio button multiple-choice field onto the form where the user chooses to use either the Standard Clause or Override Clause.
That can give more flexibility to your form rules, because if they select to use the Standard Clause, then the field would be non-editable, and would always be a mirror of the look up field ( ie maintained by form rules). But as soon as they do override, then the field becomes editable at that point.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Not ideal, but this might be the best available option. It's kind of foreign to me that there is no "onChange" event or equivalent for the fields (unless I have just totally missed it)
------------------------------
Jason Zeller
------------------------------- MarkShnier__You
I am admittedly a little behind in my learning curve for new forms, but I know an old style forms you can trigger a rule based on when the record is saved, and a certain field changes.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
