-
Hi everyone.
I have a form that has a field of type Drop-Down, a field of type TextBox that is inside a group to make comments and a checkbox that enables and disables the Drop-Down and the TextBox.
The comments field is to be able to capture the Drop-Down data when the SAVE button of the form is pressed and save it within the group ...
-
HI Hilary,
Thanks again for your response!
When i export to excel, I am getting the calculated columns whichever created in sharepoint (for date formatting - calculated date fields) along with my view columns. Ihave unchecked those calculated columns in edit view and saved, but still i am getting those along with my view ones.
Sample ...
-
Hi
From my other posts you can see I'm trying to build a back office ticket support system where the support team take email requests then fill in a browser form to initiate the process, pass between the various steps in the process and teams etc.
I was thinking could I not make the form available in an email for the support team to send ...
-
I can't repro this. When I export to Excel, only the columns in the view are included. So, perhaps you need to not display those columns in your list view? I tested in both SharePoint Online and a SharePoint 2013 list and in both cases, only the columns from the current view (along with two system columns, Item Type & Path) were included.
-
Excellent. For whatever reason, it looks like the form hadn't saved those credentials you wanted to use - we generally shouldn't have to manually modify InfoPath form files, but sometimes it is the fastest way to fix a problem....
-
Thank you Hilary. This worked perfectly. Testers can launch it with no issues. Lou
-
Hi Hilary,
Thank you for providing a screenshot. This would be helpful and works for me. Thanks again for your help. Much appreciated. :)
-
Thanks. I made the changes and tested it out on my PC and it works fine. I published it, and asked one of my users to test it out tomorrow. Appreciate all the help! Lou
-
So - you could try manually modifying that connection string to use the credentials you want.
Remove:
Integrated Security=SSPI;
Replace with the SQL credentials you want to use:
Password=YOURPASSWORD;User ID=YOURUSERID;
Save the changes to manifest.xsf. Close it. Right click on manifest.xsf and select Design - it will open in design mode. ...
-
Thanks. I do see the manifest.xsf file. I opened it in Notepad and search for Connectionstring. I do see information for each connection to SQL server, but I do not see anything that shows what ID is connecting. I do see the SQL. Here is the text I see for one of my connections. I have asterisked out some information that may be ...