Rule on Date/Time field on repating table - InfoPath Dev
in

InfoPath Dev

Rule on Date/Time field on repating table

Last post 08-24-2017 08:01 AM by Hilary Stoupa. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 08-18-2017 01:06 AM

    Rule on Date/Time field on repating table

     Hi,

     

    I'm trying to set up a rule on a Date/Time field in repeating table which checks the same field in repeated lines to ensure they're on the same day as the first date entered.

     

    I'm not sure how to set up the rule to only apply to the date portion of the control, as the time portion is linked to the same field so any rules applied apply to both halves.

     

    Any help would be appreciated.

     

    Thanks,

    DWoolley. 

  • 08-22-2017 04:33 PM In reply to

    Re: Rule on Date/Time field on repating table

     Fun - see attached sample. Save the file locally, right click and select Design, and from there you can preview and try it out.... I'm highlighting the whole row on a mismatch of date. I've also set a default in field2 to show the value of the substring-before formula. Holler if you have any questions or need a hand implementing this in your form.

    Hilary Stoupa

  • 08-24-2017 01:06 AM In reply to

    Re: Rule on Date/Time field on repating table

    Thanks for the response! I wasn't aware of the Substring-Before feature, very useful!

     

    I have this working in my form, but I was wondering if there was a way to make this a validation type rule, if the dates don't match it wont allow a form submit?

  • 08-24-2017 08:01 AM In reply to

    Re: Rule on Date/Time field on repating table

    In my sample form, I was able to just copy / paste my highlighting rule onto my datetime field and change it to a validation rule - maybe try that?
    Hilary Stoupa

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.