Code

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Tue, 29 Jul 2008 18:23:34 GMT

The following solution was thanks to Hilary Stoupa, Thank you!:

I had to to create a boolean field first that would assist in the operation. Then I created to event handlers. One for the dropdownlist, and onAfterChange event, and one for saving, onSaveRequest. Here is the code I used for the two of them:

public void ddlEngagementType_OnAfterChange(DataDOMEvent e)

//checks to see if the engagement type has changed from New to Extension. If so, it sets a boolean field to true

//which will later disable save forcing a submit only. This prevents saving new extensions over current new project announcements.

{

// Write your code here to restore the global state.

if (e.IsUndoRedo)

{

// An undo or redo operation has occurred and the DOM is read-only.

return;

}

// A field change has occurred and the DOM is writable.

// Write your code here.

if (e.OldValue != null)

{

//set variables to hold the old value and the new value of the field

string newValue = e.NewValue.ToString();

string oldValue = e.OldValue.ToString();

//if the field used to have the value of new and now has the value of extension, move into the next code block

if (oldValue.ToLower().Equals("new") && newValue.ToLower().Equals("extension"))

{

//set our helper field to "true"

thisXDocument.DOM.selectSingleNode("/my:myFields/my:ddlEngagementType/@my:bEngagementType").text = "true";

}

public void FormEvents_OnSaveRequest(SaveEvent e)

//This checks the value of the helper boolean to determine if any of the triggers went off to disable save

{

// Write your code that will run before a Save or Save As operation here.

//get the values of the drop down and the helper node

string ddlValue = thisXDocument.DOM.selectSingleNode("/my:myFields/my:ddlEngagementType").text;

string helper = thisXDocument.DOM.selectSingleNode("/my:myFields/my:ddlEngagementType/@my:bEngagementType").text;

//check to see if our helper node is true -- if it is, and if the value of the drop down is "extension", don't allow saving

if (Convert.ToBoolean(helper) && ddlValue.ToLower().Equals("extension"))

{

thisXDocument.UI.Alert("You can't save the form because you changed the status from new to extension");e.ReturnStatus = true;

}

else

{

e.IsCancelled = e.PerformSaveOperation();

// Write your code to be run after saving here.

e.ReturnStatus = true;

}

Hope this helps. Thanks to all who contributed!

Eric

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Mon, 28 Jul 2008 16:41:06 GMT

Yeah, thats how I figured out this was for 2007. When I had 2003 compatible C#, the changed event was not available, but when i changed it to plain C# it became avaialble. Is there anyway to do this in 2003 and would anyone be willing to volunteer the code if so? I have a few books on the way, but this project is supposed to go live on Monday and I don't think i'll know that much by then.

Re: Disable Save fetaure based on the changing of a drop down value.

Hilary Stoupa — Mon, 28 Jul 2008 16:04:57 GMT

The code you are using is for the 2007 object model, to begin with. It will not work with the 2003 object model. Also, the code includes the event handlers, which you will need to add to your form and then use the code from the sample in the event handler you create. Here is an article on that.

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Mon, 28 Jul 2008 15:55:00 GMT

Looks like this has to be done in 2007 to use this code. Any way to do this in 2003 or with 2003 compatible code?

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Mon, 28 Jul 2008 12:14:21 GMT

Hilary, thanks for your patience. I understand what you mean now and got that poriton setup. I'm still getting run time errors with XmEventArgs and SaveEventArgs however. They have the green squigley line under it and it says this when I rollover it: "The type or namespace name 'XmlEventArgs' could not be found (are you missing a using directive or an assembly reference?)

I'm using C#(InfoPath 2003 Compatible)

Re: Disable Save fetaure based on the changing of a drop down value.

Hilary Stoupa — Fri, 25 Jul 2008 21:22:26 GMT

I realize you are just copying and pasting the code provided earlier. That code depends upon you having a boolean field that can be set to "true" when certain conditions are met. You don't have to add a control, you can just add another node to your schema in the Data Source Task Pane, and set its datatype to be a boolean. Here are some instructions on how to do that.

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Fri, 25 Jul 2008 21:14:58 GMT

I'm not sure what that field is though (the helper field). I'm just copying and pasting code that was provider earlier in this post. Do i need to add a control of some sort?

Re: Disable Save fetaure based on the changing of a drop down value.

Hilary Stoupa — Fri, 25 Jul 2008 20:37:01 GMT

Any place you see XPATH to Reference Variable, you need to replace those words with the xpath to your field. To get that, you can right click on the field in the data source and select Copy XPath. When I read this code, it tells me that in the Changed event for your drop down, if the drop down changes from "new" to "extension", another field is having its value set to "true" -- kind of a helper field, if you will. XPATH to Reference Variable should be replaced with the XPath to that field.

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Fri, 25 Jul 2008 20:32:24 GMT

Are you refering this this line?:

root.SelectSingleNode("XPATH to ReferenceVariable", NamespaceManager).SetValue("true");

My entire coding is such:

public void ddlEngagementType_Changed(object sender, XmlEventArgs e)

{

string oldValue = e.OldValue;//collect the Old Value form Status drop down

string newValue = e.NewValue;//collect the New Value form Status drop down

//Check if the user changes the Drop down value from new to extension then only dont allow save otherwise let him for saving.

if (oldValue.ToLower() == "new" && newValue.ToLower() == "extension")

{

XPathNavigator root = MainDataSource.CreateNavigator();

root.SelectSingleNode("XPATH to ReferenceVariable", NamespaceManager).SetValue("true");

}

//if the status changes, then set the referrence variable value to true.

}

public void FormEvents_Save(object sender, SaveEventArgs e)

{

//while saving the form,check if the reference variable is true.

//if true, dont allow user to save the form.

XPathNavigator root = MainDataSource.CreateNavigator();

string ddlEngagementTypeValue = root.SelectSingleNode("//my:ddlEngagementType", NamespaceManager).Value;

XPathNavigator root = MainDataSource.CreateNavigator();

string isTrue = root.SelectSingleNode("XPATH to ReferenceVariable", NamespaceManager).Value; if (Convert.ToBoolean(isTrue))

{

e.CancelableArgs.Cancel = true;

e.CancelableArgs.Message = "U Cant Save";

e.CancelableArgs.MessageDetails = "U cant save as the status is Extension";

//if ddlStatus is Extension Don’t allow the user to save the form

}

Not sure what I'm looking for here. I can do HTML but this stuff is a strech for me :-)

Re: Disable Save fetaure based on the changing of a drop down value.

Hilary Stoupa — Fri, 25 Jul 2008 20:11:46 GMT

You replace "XPATH to ReferenceVariable" with the xpath to the field you've added as boolean. Earlier, in the code connected to the drop down box, you set the value of a boolean field to true if certain conditions are met. The xpath to that field needs to go in quotes in place of the phrase "XPATH to ReferenceVariable".

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Fri, 25 Jul 2008 20:05:42 GMT

I can't give up that easily. So I got Infopath 2007 and switched it to C# and I have inserted the code you supplied inserting the xpath to the dropdownlist. One part i'm unsure of in your code is the xpath to the referencevariable. what does that mean and what is it?

Ex: string isTrue = root.SelectSingleNode("XPATH to ReferenceVariable", NamespaceManager).Value;

Also, I get "The type or namespace name 'XMLEventArgs' and 'SaveEventArgs' could not be found."

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Thu, 24 Jul 2008 20:47:19 GMT

Thanks for all your help but we can close this. Since the users are opening the document from sharepoint and making the changes, even if we disable save, it's still going to prompt to save after they submit because the file has changes. I just don't see anyway to get that to work.

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Thu, 24 Jul 2008 19:32:12 GMT

Srikrushna

I'm starting to get the feeling this is specific to Infopath 2007. Since I see C# listed in Infopath 2007 and it looks like the XmlEventArgs are part of the Microsoft.Office.Infopath namespace which MSDN says is in 2007. I dont know what any of that means but I have a bad feeling in my stomach. Can this be done in VBScript in 2003? Thanks to anyone and everyone who reads this.

Eric

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Thu, 24 Jul 2008 19:00:40 GMT

C#? I only have JS and VBScript listed. What do i do?

Re: Disable Save fetaure based on the changing of a drop down value.

e_stylzz — Thu, 24 Jul 2008 18:50:17 GMT

Sorry, I freaked out beore looking around. Found my problem here: http://support.microsoft.com/default.aspx?kbid=828853

Thanks guys. I'll test the code and let you know.