Make Formula-Checkbox clickable

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hey folks,

For context- here are my checkboxes involved...

1. "Material Cleared by Supply Chain"
2. "Schedule Approved by LPM"
3. "Schedule Denied by LPM"

I want my supply chain guys to review a schedule, approve material to ship, then have the LPM approve the schedule after material has been cleared.

Here's the functionality I'm looking for:

1. If the LPM selects "Schedule Denied by LPM", I want "Material Cleared by Supply Chain" to automatically uncheck.
2. When supply chain re-checks "Material Cleared by Supply Chain" at a later date, I want the "Schedule Denied by LPM" checkbox to uncheck.

I'm willing to make changes, if making the two checkboxes into a Yes/No field entitled "Schedule Approved by LPM", that's fine. I'm trying to avoid making a bunch of ghost checkboxes to pass checks along.

Keep in mind that I want to keep all checkboxes clickable from the grid edit view!

Thanks for your help!
Photo of Mark Capretta

Mark Capretta

  • 110 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Mark Capretta

Mark Capretta

  • 110 Points 100 badge 2x thumb
Just a thought, I could also make it so that when the schedule for the record changes, the "Scheduled Denied by LPM" checkbox unchecks. But I'd need help with that formula too =]
Photo of Alex Wilkinson

Alex Wilkinson

  • 1,036 Points 1k badge 2x thumb
In effect, you want to apply some validation rules within a grid edit report, but without the automation that would be available with rules on a form. In situations like this, I've often found it handy to create a formula-text field called "Warning" that's blank if all's well, and put the field on the grid edit report. This is especially handy if the grid-edit is within a form that's being edited. Here's how it might work in your example:

1. The "Warning" allows html and looks like this:
If( not ( [Material Cleared by Supply Chain] and [Schedule Denied by LPM] ), "",
    "<span style='color:red; font-weight:bold;'>" &
    "Warning: Re-review required. Uncheck 'Material Cleared by Supply Chain' " &
    "</span>"
  )

2. If the grid edit is within a form (i.e., it's a detail table on a master record that's being edited), then create a summary field on the master record that counts the number of detail records where "Warning" is not blank. And on the form, create a rule that aborts the save if the summary field is greater than 0. The rule aborting the save would have a message saying something like "Please correct the check-box for the Supply Chain."

Or, if you don't want to put a burden on your users to uncheck the box, but you have a master-detail relationship, you could create a Quick Base Action on the master table that says, in effect, when a record is modified and the number of warnings is greater than zero, edit the related detail records to uncheck all the boxes. While this frees your users from having to do the unchecking, it makes the system a bit less transparent, which may be a downside, depending on the sophistication of your users.