InfoPath Dev

Try adding a button that sets the value of the Reviewer fields to the details of the person looking at the form and remove any default value settings from the fields. If you click the button, does it work OK? Does it change the name of the submitter too?

I think you've nearly done it... I think you need AND instead of OR between the brackets of your long expression. You need all the bits in brackets to be true (by being not true) to hide the control. The backwards conditional formatting in InfoPath gives me a headache!

The thing that might be happening is that if you're using the same data connection to get both values, that it is overwritng anything you do to set the value of the reviewer.  It's hard to say without seeing it. Are you able to attach it here to have a look at please?

Is there a way you can use a rule to set the Reviewer name, rather than using default value? If possible, you could attach your form here and I'll have a look. I've had a problem with these values before, which I've fixed by making sure that the field values are set by rules so they cannot be changed by refreshing.

As far as I know, you'll need code to do it from a repeating table. If it wasn't a repeating table, you could do it with workflows, just creating a list item and setting the field values. The inbuilt Visual Studio for applications isn't too daunting, certainly less complex than Visual Studio proper. Do you have any coding experience ...

Here's a good place to start, if you  haven't already: http://www.bizsupportonline.net/infopath2007/how-to-submit-items-rows-repeating-table-infopath-sharepoint-list.htm You could use this, and concatenate the general information and the repeating table row value.

I've done many forms that require multiple signatories and approvers, some sequential and some possibly concurrent. I do not use the digital signing function and I think it's easier to create your own version within the form. Would you consider doing that? I could probably dig out a generic example if you'd like.

Are you using the GetUserProfile web service to retrieve the user names? And then are you setting the field values by using "Default Values"?

You can do this using the OP's method with substrings. Try: concat(Type, " - Effective Date:", concat(substring(Effective_Date, 6, 2), "/", substring(Effective_Date, 9, 2), "/", substring(Effective_Date, 1, 4)))

I've got it working, but I have no idea how or why this has fixed it. On the form there is a button called Get Details in the Manager details section. I deleted that button and opened Logic Inspector. It was working correctly. Saved and published fine. Did Ctrl + Z to put the button back. Logic inspector OK, saved and published totally ...