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
------------------------------
Original Message:
Sent: 01-18-2023 01:08
From: Mark Shnier (Your Quickbase Coach)
Subject: Issues with form rules and notifications when Log Edits is enabled
The issue is that once populated there is other text in that field.
so create a field for [Approval Status] with this formula
Trim(Right([Purchasing Review and Approval],"]"))
Here below are my own cheat notes on parsing fields set to Log Changes where the new entries are at the bottom.
Parsing Append Only Fields
so... if you have a text field set to Log Changes where the new entries act in the default manner which is to be at the bottom of the updates, here are some formuals to use to parse out the values from the most recent entry. I am also assuming that you are logging the date and not the date and time.
Most recent value (formula text field type)
Trim(Right([my update field],"]"))
Date of most recent update (this needs to be a formula date field)
ToDate(Left(Right([my update field],"["),9))
Who did the most recent update (formula text field type)
Trim(NotLeft(Left(Right([my update field],"["),"]"),9))
Parse out the date and time of the update
var text DateAndTime = Left(Right([append only with date /time],"["),18);
var date TheDate = ToDate(Left($DateAndTime," "));
var timeofday TheTime = ToTimeOfDay(NotLeft($DateAndTime,9));
ToTimestamp ($TheDate, $TheTime)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 01-17-2023 21:10
From: Diane Sinawi
Subject: 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 this field.
After value "Reviewed and Approved" is selected, I don't want this field to be editable. However, my form rule is not working in this field. If I select a different multiple choice field that does not have Log Entries enabled, the rule is working.
NOTE: originally I had 2 values "Not Reviewed or Approved" and "Reviewed and Approved", but it had the same issue.
Also, I've set a notification (currently to myself for testing) that when the value changes to "Reviewed and Approved", a notification is sent. This is also not working.
Is this a QB limitation when using Log Entries, or am I doing something wrong? Thank you for your help!
------------------------------
Diane Sinawi
------------------------------