Solutions to Problems or Custom Needs in a Website

Using the javascript API you can open Action Form in popup by calling the next javascript method

dnnsf.api.actionForm.openPopupById('1234', {'param':'valueofparam','param2':'valueofparam2'},true)

Also works for simply initializing a form already on the page

dnnsf.api.actionForm.initForm('1234', {'param':'valueofparam','param2':’valueofparam2'})

It appears that [Department:Text] is a backend-only token, meaning it can't be used on the fronted; however, you can do something along the lines of: on the dropdown field under Bind Expressions, On Change/Click use the following code:

form.fields.mytextbox.value = form.fields.dropdown.selected.text;

this will give the text box the value of the dropdown.

There is a SQL Script here to remove all Action Form tables

This will remove the page numbers from the querystring. But as it is, it sometimes causes the page to reload. Thi example sets what it wants the querystring to be.

    setTimeout(function () {
        window.history.pushState({}, document.title, "/" + 'book/BID/1' );}
    ,2000);
    setTimeout(function () {
        window.history.pushState({}, document.title, "/" + 'book/BID/1' );}
    ,3000);

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.