Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 2 of 2 (20 items) < Previous 1 2 Re: Adding (summing) clock time I'm now having a strange issue where the resultant of the addSeconds is adding an additional 5 hours to every computation. For instance, I have the following formula: addSeconds(field1, 1800). Field1 = 12:15. The resultant should be 12:45. Instead, I'm getting 17:45. All of my formatting is correct, from what I can tell... But I'm ... Posted to General (Forum) by workin'stiff on 10-23-2012 Re: Adding (summing) clock time Ah, thats my issue! Thanks! Posted to General (Forum) by workin'stiff on 10-23-2012 Re: Adding (summing) clock time It appears that IP doesn't like two field parameters. When I enter values into the preview, it comes up with ERR? in the resultant field. Yet in the formula editor, there are no errors found when running the check... Strange... Posted to General (Forum) by workin'stiff on 10-23-2012 Re: Adding (summing) clock time [quote user="Anson Hidajat"]You can use rules to create this effect, though it may get a little complicated. You can use string functions (substring) in InfoPath to parse our the hour and the minutes. Then you can add to the minutes based on the total amount then divide by 60. The result should be added to the ... Posted to General (Forum) by workin'stiff on 10-23-2012 Adding (summing) clock time I'm trying to find a no code solution for the following problem. I've got a text field (formatted as time with the following format, XX:XX). I need to add a defined amount of time to the previously referenced text field. The returned value needs to be formatted in XX:XX. Any help with this would be greatly appreciated. And let me know if ... Posted to General (Forum) by workin'stiff on 10-03-2012 Adding time column in repeating table Hi everyone, I'm trying to add up a column in a repeating table which contains time values. I'm currently using the following formula, however, it will only utilize the first row of the table in determining the value. concat(substring(100 + number(concat("0", substring(aircraftFlightLogIncomingFlightTime, 1, 2))) + ... Posted to Controls (Forum) by workin'stiff on 06-25-2012 Re: Multiple conditionals within a common control I ended up splitting everything into six separate conditions. And it worked like a champ! Sometimes it all about the KISS concept. Thanks for the help! Tom Posted to General (Forum) by workin'stiff on 06-04-2012 Multiple conditionals within a common control Hi everyone, I've got an issue where I need to have multiple conditionals (read formatting) within a common control. See my example below. Text Box 1 (Integer) Text Box 2 (Integer) Text Box 1 (e.g. TB1) will contain one of three user entered values - 39,000 / 40,000 / 41,000. If the user enters 39,000 into TB1, the acceptable ... Posted to General (Forum) by workin'stiff on 06-04-2012 Re: Numeric Input Mask Thats a good idea. Thanks! It would be nice if an all-in-one solution for textboxes was incorporated to support this type of feature, though. Posted to Controls (Forum) by workin'stiff on 05-15-2012 Numeric Input Mask Hi everyone, I've searched the site several time with different wording to see if the topic has been covered. So, please accept my apology if I've missed it. I am trying to figure out if it is possible to create an input mask for numeric characters to be completed in a pre-defined format. For instance, if I need to capture the value ... Posted to Controls (Forum) by workin'stiff on 05-14-2012 Page 2 of 2 (20 items) < Previous 1 2 Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.