binding form fields to a different SharePoint list
Posted on 2014-08-19
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.