Details about this thread
  • State Not Answered
  • Replies 2 replies
  • Subscribers 325 subscribers
  • Views 319 views
  • Users 0 members are here
Related content from around SugarClub

SugarBPM - evaluate if date field is null

Luc Myre

Hello,

I'm trying to build a process that evaluates if a date field is null. Whether I try this with a business rule or a gateway, available conditions in SugarBPM do not include an option to evaluate if a date field is null. Does anyone have suggestions on how I can accomplish this? 

Trigger = user selects checkbox field 
 then check if date field is null
  if date is null
   then date = today()
   else do not update date
end

Happy to hear how others have gotten around this.

Kind regards,

Parents
  • 0

    Hi Luc,

    I had a similar need and my solution was:

    • Create a field in the module named “date today” with the formula: today()
    • In my BPM I have a branch that looks at the date field that may or may not be populated.
    • One branch goes to an action.  The branch is taken if the desired date field is equal to a blank.  The action is to set the field to the “date today” field
    • The other branch is taken if the desired date filed is not equal to a blank.

    It may not be the best solution, but it works for me.

    Bud Hartley | Cape Foulwind, NZ (and Oregon, USA)

Reply
  • 0

    Hi Luc,

    I had a similar need and my solution was:

    • Create a field in the module named “date today” with the formula: today()
    • In my BPM I have a branch that looks at the date field that may or may not be populated.
    • One branch goes to an action.  The branch is taken if the desired date field is equal to a blank.  The action is to set the field to the “date today” field
    • The other branch is taken if the desired date filed is not equal to a blank.

    It may not be the best solution, but it works for me.

    Bud Hartley | Cape Foulwind, NZ (and Oregon, USA)

Children
No Data