Use our Google Custom Search for best site search results.
Search
-
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 ...
-
Ah, thats my issue! Thanks!
-
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...
-
[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 ...
-
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 ...
-
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))) + ...
-
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
-
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 ...
-
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.
-
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 ...