Comparing Date Fields on Eform

Follow

Chris Howard

• February 20, 2020 16:23

Hello,

New member here. I'm looking to create a rule to make a field show/make it required  if the difference between a date field and a date/time field is a day and a half. Sorry if this is the wrong place to ask.

 

Thank you in advance.

Chris

0

• 

  sysberry GmbH

  • February 20, 2020 18:58

  Hi Chris,
  You can use hidden control formula to calculate the difference between two dates and set a rule on this formula to show/set mandatory on it.

  Please give a feedback if it helps.
  Regards,
  Alexey

  0

  Comment actions Permalink
• 

  Chris Howard

  • February 20, 2020 22:22

  Thanks for the suggestion. I poked around a little in the formula control, but didn't see where to calculate the difference. I ended up using some JavaScript my IT department suggested. 

  Is that a normal solution for AgilePoint?

  0

  Comment actions Permalink
• 

  sysberry GmbH

  • February 21, 2020 06:30

  Hi Chris,
  if formula doesn't help, then JavaScript is the next option. It's normal. Don't forget to use eFormHelper methods: https://documentation.agilepoint.com/00/appbuilder/cloudjsMethodsIntro.html
  Regards,
  Alexey

  0

  Comment actions Permalink

Please sign in to leave a comment.