Edit Infopath field in Datasheet view

[meongroup]

I am having a infopath form published on sharepoint. Two columns are
published. I changed properties.xfp file and made the two columns
ReadOnly="FALSE". Now when I go in "Edit in datasheet" and try to edit
column values, it is edited, but when the pointer goes out of focus,
the status bar shows "Pending changes" and the value is again changed
back to the original value.

I want all these changes to be retained in the form? How can I achieve
that?

Thanks,
Monu

 

[Greg Collins [InfoPath MVP]]

Those changes will not directly affect the InfoPath XML files. They only affect the SharePoint property values.

 

[meongroup]

Hi Greg,

Thanks for your feedback. In the mean time, I searched on groups
regarding this kind of problem. Somewhere it was mentioned that a
column in sharepoint needs to be created corresponding to Infopath
column and we can modify the sharepoint column instead of Infopath
column. At the time of opening the infopath form, programmatically get
the value from sharepoint column and assign that value to infopath
column. At the time of saving the infopath form, programmatically save
the value of Infopath form to sharepoint column. I am using javascript
as scripting language. At the time of opening and closing the form, can
I get/set value of sharepoing portal column? If yes, can I achieve it
with javascript or do I need to use Visual studio toolkit for Infopath?
I would highly appreciate If you forward example / link of example to
do the same.


Thanks.

Monu