Condition for running calculated field - InfoPath Dev
in

InfoPath Dev

Condition for running calculated field

Last post 09-02-2015 05:38 PM by Sailor. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-02-2015 11:39 AM

    • Sailor
    • Top 75 Contributor
    • Joined on 09-15-2009
    • Canada
    • Posts 107

    Condition for running calculated field

    Hello, Really stupid question, but I just can't remember the right mechanism for this. I have 3 fields as part of a repeating table; START_TIME, END_TIME, TOTAL_TIME. Where can I set the rule to run the formula to calculate the total_time? If it's the default value for total_time, it creates an error as soon as the start_time is entered (because the end time isn't there yet).
  • 09-02-2015 04:53 PM In reply to

    Re: Condition for running calculated field

     I'd add a rule to Start Time - condition would be that Start Time and End Time are not blank. Then I'd add the same rule to End Time - same condition, Start and End Time are not blank. Then the rules can set the Total Time.

    Hilary Stoupa

  • 09-02-2015 05:38 PM In reply to

    • Sailor
    • Top 75 Contributor
    • Joined on 09-15-2009
    • Canada
    • Posts 107

    Re: Condition for running calculated field

    Hi Hilary, I take it that my confusion over your reply is due to the fact that I had no idea InfoPath can't subtract two times and return an integer value. So I tried following the method at http://www.bizsupportonline.net/infopath2003/time-calculations-infopath-using-rules.htm, which is EXACTLY what I need to accomplish. However, following this example to a tee, I don't return a value in my Total_Time field.
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.