Skip to main content
Question

Formula Checkbox Help Needed

  • Feb 9, 2023 9:42 PM UTC
  • 0 replies
  • 472 views

I need a Formula Checkbox that checks against emails entered in a field on another table or a list of emails.



------------------------------
Stephanie Milburn
------------------------------

This topic has been closed for replies.

Forum|alt.badge.img+19
  • Qrew Champion
  • Feb 10, 2023 2:06 AM UTC

Stephanie,

A little more detail about your issue would be helpful.   Please describe the action desired by the formula.



------------------------------
Don Larson
------------------------------

Forum|alt.badge.img+12
  • Qrew Corporal
  • Feb 10, 2023 3:43 PM UTC

Hey Stephanie,

As Don mentioned, it's difficult to offer guidance without a better understanding of what your hoping to achieve.

The skeleton would look like something like the following, where you'll either return true or false. Note that you can have multiple "tests" within your Formula Checkbox logic.

If (
    // Check the box when …
    [Some Field Status] = "Active", true,

    // Or when  …
    [# of Some Related Records] > 0, true,

    // Default to unchecked
    false
)



------------------------------
Brian Seymour
------------------------------