Menu

Solutions to Problems or Custom Needs in a Website

Many solutions we create for one site can be used and appreciated on other sites also.

Have a look at this list of components and solutions we have developed over time and if you could benefit from any of them you are welcome to them.

Please let us know if you would like to discuss the details or would like some help getting one installed.

Mark Buelsing
/ Categories: Action Form

Getting Action Form Data and Reports

Link to prefill form submissions. 

http://domainname.com/ACA-Fest?entry=5da0b1e8-8332-49a6-b76f-94b74caab84f

The GUID that you put in the link can be found in the action form reports table, avtActionForm_Reports.

Here is the token to insert in an email to get a link  back to the form with the content inserted:
[_EditUrl]


Here is a sample SQL query to get that data for a submission

SELECT 'ReportEntryId: ' +
      CONVERT(nvarchar(10),ReportEntryId) + ' UserID: ' + 
      CONVERT(nvarchar(10),UserId) + ' submitted on: ' + 
      CONVERT(nvarchar(11),DateSubmitted, 102) + '|' + 
      CONVERT(char(36),ValidationKey)

  FROM db_Name.dbo.avtActionForm_Reports
  WHERE ModuleID = 1037
   ORDER BY ReportEntryId desc

This query could be improved by including some data from the form submission, like a name of the person submitting the form. That data is stored in the record in an xml format.

Print
2676 Rate this article:
No rating
Please login or register to post comments.
RSS
1234