Newbie Questions

Re: Font color on disabled controls

Hilary Stoupa — Thu, 02 Apr 2020 19:13:22 GMT

Based on your earlier post in this thread, it sounded like you already were changing the "employee" selection when the manager made theirs? But just don't care for the formatting? The suggestion I'm making would use the same conditional formatting on the dropdown control - just hide it instead of disabling it. Add a calculated value (not a text field) with the opposite formatting? Feel free to attach a copy of your form if you need a hand.

Re: Font color on disabled controls

rpacdn — Thu, 02 Apr 2020 05:26:09 GMT

Thank you. It might but I have to check it... I am not sure if I can dynamically replace a dropdown list with a textfield view, based on another field (Manager's field) selection.

What I really wanted to do was that when the Manager changes the options in the selection box, it also affects the selection in the one that the Employee has selected. That way Manager can see that even though the employee selected Option C, when they manager changed it in their Approval box to Option B, it actually changed/overrides the selection made by the Employeee also.

Re: Font color on disabled controls

Hilary Stoupa — Tue, 31 Mar 2020 14:33:16 GMT

I would probably hide the dropdown instead of disabling it. Then use a calculated value to show the selection in the formatting you wish - with that hidden if the dropdown is showing.... Does that make sense?

Re: Font color on disabled controls

rpacdn — Mon, 30 Mar 2020 19:23:43 GMT

I have a slightly different but related issue regarding the font color of a dropdown list.
I have a drop down list with four options.The User will have to pick what is relevant to them and submit the form. This is Security clearance of an employee. So employee pick one of the four options. (Option A, Option B, Option C, Option D). Say Applicant picked Option C.

In the next stage the Manager has to verify the selection the User has made. So the Manager also has a dropdown list with the same four options. And the Manager checks the record and make the correct security status of the employee as per the records. Say that choice is Option B.

So what I am trying to do is:
- When the Manager makes their selection (in this case, Option B) I want to change the value of the Employees dropdown also to Option B instead of the Option C that they have picked. I know how to do that, no problem. And I can disable the field so that the employee cannot change it back to Option B.

The problem is the font in that disabled field. Now it is barely readable. Is there anyway I can change the format?

Re: Font color on disabled controls

Hilary Stoupa — Fri, 15 Apr 2016 17:59:01 GMT

Oh excellent - I think the error only will affect you if the form has code, so as long as you don't have code, you'll be fine.

Re: Font color on disabled controls

nkidd — Fri, 15 Apr 2016 17:46:10 GMT

Well, the bad news is it still gave me the same design checker error...but - the good news is i tried publishing the form anyway and it appears to be working just fine. I ran a couple tests in sharepoint and as far as i can tell, it is working perfectly. Thank you so much for all of your help!!!

Re: Font color on disabled controls

Hilary Stoupa — Fri, 15 Apr 2016 16:44:43 GMT

Here it is back with a minor change made to the Change Status view after saving as form files that should take care of that design checker error. Save locally, right click and select Design - if you can't download from here, let me know - I'll get your email address from your forum account and email it to you. :)

Re: Font color on disabled controls

nkidd — Fri, 15 Apr 2016 16:34:14 GMT

Here is my template. Thank you very much for your help - i really appreciate it. Just a quick overview - the "AllOpen" view is the default view which will be used to create the SharePoint item initially. All fields should be active. The ChangeStatus view will have all fields except for Status disabled - so they can be seen but not changed. In the end, i would like the 2 views to look identical - except you can edit the info in one view and "read only" in the other. Thanks again. For some reason, my firewall is blocking me from attaching the file to this post. I uploaded the file to Dropbox...hopefully you can get it here. https://www.dropbox.com/s/uqsohs5a0jj2ah1/UAMForm.xsn?dl=0 thanks again

Re: Font color on disabled controls

Hilary Stoupa — Thu, 14 Apr 2016 22:44:52 GMT

This is an InfoPath issue: http://www.infopathdev.com/blogs/hilary/archive/2012/01/19/ipfs-design-checker-errors-amp-print-preview.aspx If you need a hand fixing up the view, attach your template to a reply under Options and I can give you a hand tomorrow - apparently you can also recreate the control to get around this: http://www.infopathdev.com/blogs/mel_balsamo/archive/2013/01/14/get-rid-of-that-quot-control-binding-is-not-supported-quot-error-on-your-design-checker.aspx

Re: Font color on disabled controls

nkidd — Thu, 14 Apr 2016 19:15:53 GMT

Well, i thought i had it, but when i tried to publish the form to SharePoint, i got a message - "Binding a non-repeating control to a repeating field or group is not supported in InfoPath 2010 Web browser forms...". Any idea if i did something wrong or if what I am doing wont work in SharePoint? I am pretty sure I matched everything you did on your example to my form with the data source, etc but may have messed something up...i appreciate your help very much

Re: Font color on disabled controls

Hilary Stoupa — Wed, 13 Apr 2016 22:49:16 GMT

Save the attached file locally. Right click and select Design to open in design mode. I've added an XML file as a resource (Data tab, Resource files) and added a data connection to it. Then I've used it as the data source for my dropdown, so in the second view it is easy to add a calc'd value that displays the "display" value.

Re: Font color on disabled controls

Hilary Stoupa — Wed, 13 Apr 2016 21:55:56 GMT

That makes it a little harder. How many items are there? You could create an XML file for them, then you'd be able to use a calculated value - I'll set up a sample later today or sometime tomorrow and attach it to a reply so you can see what I mean.

Re: Font color on disabled controls

nkidd — Wed, 13 Apr 2016 19:48:15 GMT

I have the options set in the control

Re: Font color on disabled controls

Hilary Stoupa — Wed, 13 Apr 2016 19:42:12 GMT

Are your dropdown options hardcoded in the control? Or are they in a secondary data source?

Re: Font color on disabled controls

nkidd — Wed, 13 Apr 2016 19:37:39 GMT

I'm not sure. I do have the same issue as the original poster as well, where I want it to show the "display" name and not the "value". Would a calculated field allow for that? or is the only way to show the Display name by using the dropdown control? If I had to, i could make the display and value match, however i'd rather not (the values are all email addresses and the display are just names which looks much nicer in the form, but i need the email address as the value to be used in sharepoint workflows).