Hello,
I have an InfoPath form with some data connections to SharePoint lists. I concatenate several fields into 1 field. Example:
Field1 = 45
Field2 = 66
Field3 = 00
So concatenated, Field4= 456600
Sometimes, Field2 is empty. Then I get Field4= 4500. But that's not what I need, Field4 needs to be 6 characters long! So I want it to be ...