Issues with form rules and notifications when Log Edits is enabled
I have a multiple choice field (Purchasing Review and Approval) with one value "Reviewed and Approved." The field is empty until someone approves. To log the user and date, I enabled Log Entries for t...
I think the issue is a combination of problems. The first, Mark already explained. However, if I remember correctly, dynamic form rules and notification triggers look at whatever is in the field. As soon as the record is saved and the selection is logged, QB see's the field as null, as nothing is currently selected in the dropdown.
The solution is to use Marks formula field, and have notifications trigger when the multiple choice field is changed, but the formula field equals your condition.
You can use the formula field for the dynamic rule, but the problem you will have is, as soon as the select from the multiple choice field, it will instantly go read only, which means if they selected accidentally, they are stuck. You only want the rule to go into effect after they save.
Mark might have a better solution for that issue, but I think in the past I have made a checkbox called 'Make Multiple Choice Read Only', then make a dynamic form rule that says 'When the record is saved and the Multiple Choice Field has been Changed to Approved' change Checkbox to Checked'
Then make a second dynamic form rule based off that checkbox (if checkbox is checked, make multiple choice read only). If you do this, you actually don't really need Marks formula.
------------------------------ Mike Tamoush ------------------------------
I ended up finding a simpler solution, as I have limited experience with formulas.
I removed logging from Review and Approval field. I added 2 new fields: Approved By and Approved Date. They autopopulate with current user and date when value in Review and Approval field is changed to "Reviewed and Approved". They are read-only fields, so the users cannot populate those fields themselves.
Also, I made the Review and Approval field not editable when it is changed to "Reviewed and Approved".
If someone accidentally approves, if they don't save they can just close the record and it will remove the value and make the field editable. If they save, we can temporarily suspend the rule, remove the value, then put the rule back.
This gets me the ultimate result I need - ability to log who actually approved and date in some way, and ability to keep approvals from being edited. There's no conflicts with notifications. But I really appreciate the time you took to help.
