binding form fields to a different SharePoint list

SharePoint 2010

I have the standard CRUD for an SP list. However, I want the user to click a dropdown list and select a value. Based on the selected value, I want to use jQuery in a CEWP to dynamically show additional EMPTY fields based on the selection made that correspond to columns on another list. i can do all of the jQuery stuff, but I think the biggest problem is how to set up the binding for these fields so that they will submit the data to a different list on the same site collection, not the current list. I do not want to use InfoPath, if possible, as I understand this is being phased out. I do not want the additional data entered to show up on the list that launched the form and i would rather not have it associated with it at all, it is purely for entry convenience because one list's data should cause entries in another list.  It is possible and easy to use workflows to submit the data to the other list, but if those form fields are being dynamically generated via jQuery, and none of those values are being written to the current list, then the workflow doesn't have the data it needs.

So is it possible to set the binding in code for additional form fields, not bound to any column on the current list, to columns in another list instead? Seems like CQWP is good for viewing data from multiple lists, but not for submitting data to multiple lists simultaneously. I'm looking for a "binding" property and hoping I can enter in a column from another list rather than the current one. Don't know how the external address part of the other SP list would be handled as I'm sure I need that info provided, as well as the actual column name.
LVL 9
BobHavertyComhAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

colly92002Commented:
If I understand your question correctly, then I think you should be able to utilise Sharepoint 2010's ECMAScript to write data to a second list.  Provided you can get your UI working in jQuery, it should be relatively painless to insert into another list in the same site using this.

Here is a general overview - have a look and see if this fits the bill for what you want to do:
http://msdn.microsoft.com/en-us/library/office/hh372944%28v=office.14%29.aspx

Here is an example of inserting into a list:
http://blogs.msdn.com/b/sharepointdev/archive/2011/07/25/working-with-the-ecmascript-client-object-model-jsom-in-sharepoint-2010-part-4-nikhil-sachdeva.aspx

This technology is pretty much what Sharepoint 2013 apps are based on (jQuery + ECMA script) so it's worth investigation.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BobHavertyComhAuthor Commented:
I didn't have to time read through it all yet, but I can certainly understand it as I am familiar with the SP obj model and very familiar with Javascript and JSON, so I can figure this out. Didn't know that SP has it's own version of Javascript. and JSON  Looks like the right solution because it's lightweight, and as I understand it, SP 2013 does use a lot of this, and the article your linked was for SP 2010. So it looks like this is going to work and is the best way to do it given they eventually adapted it for 2013. Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.