Comparing Date Fields on Eform

追蹤

Chris Howard

• 2020年02月20日 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

  • 2020年02月20日 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

  評論操作 永久連結
• 

  Chris Howard

  • 2020年02月20日 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

  評論操作 永久連結
• 

  sysberry GmbH

  • 2020年02月21日 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

  評論操作 永久連結

請登入寫評論。