General

Re: Returning larger number

Jimmy — Thu, 07 Oct 2010 06:01:13 GMT

For your first question, InfoPath provies a max() function, which should be the simplest way to do what you're asking. Have you tried that?

Here is a formula to conditionally append a leading zero to a single digit number:

concat(substring('0', 1, 2 - string-length(number)), number)

Re: Returning larger number

Qazi Anis — Thu, 07 Oct 2010 05:40:26 GMT

well the rule you have written is indeed an infinite loop because

let us say the original value is 4, 4 is less than 9 so you put the new value as 04 but 04 is also less than 9, so you put the new value as 004.......

a way around this would be to check the length of the field also. Check the attachment

Re: Returning larger number

haigaiz — Tue, 28 Sep 2010 10:07:03 GMT

Thanks for that, can't believe I didn't think of that! I'm very new to InfoPath.. I have another question, do you know of a way to do a conditional concat? I want to concat "0" to the start of a number in a textfield if the number is less than 9. So I have a rule setup doing just that, but when I try to preview the form I get a message saying it's an infinite loop - do you know any way around this? Thank you so much for your help.

Re: Returning larger number

Qazi Anis — Tue, 28 Sep 2010 05:12:45 GMT

write simple rules on the two text boxes to compare the two and perform the action that you need to do. To be on safer side you can change the data type fo the text fields to "whole Number"

Returning larger number

haigaiz — Mon, 27 Sep 2010 22:41:00 GMT

Hi guys, This is probably an easy one, but does anyone know how to compare two numbers in text fields and return the larger one? Cheers