Skip to main content
K
Kamila
Contributor
May 18, 2023
Solved

SaveDataEventHandler for calculated values

  • May 18, 2023
  • 2 replies
  • 0 views

Dear Team,

I'm trying to check if value of a specific column is <> 0, if isn't I would like to inform user by some kind of Message Box.

I was trying to use SaveDataEventHandler, but the issue is this value is not inputted by user - it's calculated by UD8.

Do you think there's any another possibility?

 

Thanks a lot!

 

    Best answer by JackLacava

    We need more details. Is this a Form? Is it a SQL Table Editor? 

    If it's a form, you can simply highlight cells with conditional formatting, making it obvious that something needs attention (in fact, it typically works better than a popup, since nobody reads popups). If the user doesn't pick it up, you can always check later with a Confirmation Rule.

    2 replies

    J
    OneStream Employee
    JackLacavaOneStream EmployeeAnswer
    OneStream Employee
    May 18, 2023

    We need more details. Is this a Form? Is it a SQL Table Editor? 

    If it's a form, you can simply highlight cells with conditional formatting, making it obvious that something needs attention (in fact, it typically works better than a popup, since nobody reads popups). If the user doesn't pick it up, you can always check later with a Confirmation Rule.

      K
      KamilaAuthor
      Contributor
      May 22, 2023

      I was thinking about the form. Thank you for your help - I have changed font color and created Confirmation Rule for this case. 

      Terms & ConditionsAccessibility statement