Filter the embedded HTML table report in Joomla using the username

  • aptus
    Asked on August 23, 2014 at 5:57 AM

    I am trying to use your api and I am using the correct json structure. tried filtering the results with every possible name of question. nothing worked

    Jotform Thread 419614 Screenshot
  • KadeJM
    Replied on August 23, 2014 at 4:12 PM

    I believe I understand your issue is about filtering the answers with the name or email?

    Are you trying to do this directly on your form? Where are you trying to filter this data to? Anywhere inparticular? Or? 

  • aptus
    Replied on August 24, 2014 at 4:52 AM

    I wanted to embed the report HTML grid, into my joomla but only the user who already signed in in Joomla will be able only to see this results and that's by filtering that using his username. 

    So the joomla user name should match the grid report user name and show only his results. 

  • jonathan
    Replied on August 24, 2014 at 10:06 AM

    Hi,

    I am sorry, but you cannot achieve that using only the HTML table report.

    I am not sure what is the application you used in Joomla to filter and query the data of the HTML report, but somehow I don't think you can do this dynamically as the HTML report cannot function as a repository where you can do a query or filtering function.

    What I think you can do instead is to POST the form's submission data into the database (as back-end) then use Joomla as the front-end application that can query the database. If you have a search application/plugin in Joomla, you can use this to search the created database to allow then the Joomla user to have a filtered results(using joomla username and the username in the submission database)

    You will most like need this user guides

    1. http://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

    2. http://www.jotform.com/help/237-PHP-Forms-Explained

     

    Hope this help. Inform us if you need further assistance.

    Thanks.