prepopulate a Sharepoint dataview new form with default fields RRS feed

  • Question

  • I have a Dashboard showing help desk tickets.  There are links to a detailed view of the ticket with a section for comments. The data is from a SQL Database and I want to allow users to add new comments. I have a form to do this. The form is a Dataview new form using a database connection (which I need for the insert). I would like to know if there's a way top prepopulate fields on the form from other data sources. I've managed to get dropdowns working from other SQL Database connections, but I need to plug the ticket # field from a querystring, created by field from the [Current User], etc. So far, nothing I've tried works.
    Thursday, July 23, 2009 9:48 PM