Filtering on user id.

  • Resolved Sandra van der Lingen

    (@svanderlingen)


    12 years, 1 month ago

    Hi.

    I’m looking for plugin which can display visitor relevant information on a page and I’m hoping Tablepress is the solution.

    I have an excel sheet with user id’s (about 9000) and user specific information: date + amount donated + link to website page.

    The user must be able to type his user id and then see only the data which is linked to that. So it’s a type of filtering because you don’t show the entire table but only the information relevant for the user.

    Could this work??

    Thanks!

    https://ww.wp.xz.cn/plugins/tablepress/

Viewing 7 replies - 1 through 7 (of 7 total)
  • jpechon

    (@jpechon)

    12 years, 1 month ago

    I’m looking for the same solution for the same reason.

    Are you using a login for your users? Are you giving them a wordpress login, using a plugin or made your own login? I’m trying to work this out so I don’t have to make pages for each user.

    Thread Starter Sandra van der Lingen

    (@svanderlingen)

    12 years, 1 month ago

    Hi, good to know that I’m not the only one looking for this. No, I have not yet looked at giving them a wordpress login. I first want to see if I can do without one. The issue is really how to display data from specific cells on the web page after someone types in a user id. I hope there are more people around who have dealt with something similar and know how to best do this.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 1 month ago

    Hi,

    thanks for your question, and sorry for the trouble.

    There are two possibilities for filtering here (one using JavaScript, and one using two TablePress Extensions (see http://tablepress.org/extensions/row-filter/ and http://tablepress.org/extensions/shortcode-filter-get-parameter/ ).

    The question here is: How secret is the data? For example, if I have the user ID 123, but I type in the ID 456 in the form, should I be allowed to see that information?
    If yes, then the Extensions are probably the best way. If not, you will need to find a solution based on some login and user accounts.

    Regards,
    Tobias

    Thread Starter Sandra van der Lingen

    (@svanderlingen)

    12 years, 1 month ago

    Hi Tobias, thanks for your prompt response! I’ll dig a little bit further and see if I can use these extensions. The user ids do not have to be hidden because the page will not show any other personal information like name or address. So nobody will know who the person is.

    BTW, yesterday I attended a WordPress meetup and plugin was discussed?? TablePress.

    Cheers,
    Sandra

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 1 month ago

    Hi Sandra,

    thanks for the clarification.
    Then you could actually choose between two solutions:
    You could use a JS solution and invert how the filtering works: http://ww.wp.xz.cn/support/topic/return-no-rows-when-search-string-is-empty?replies=14#post-4155230

    Or you could use a solution with a form on another page that use the Row Filtering Extension: http://ww.wp.xz.cn/support/topic/search-from-another-page?replies=8#post-3862952

    Nice to hear that the meetup featured TablePress! 🙂 Where was that?

    Regards,
    Tobias

    Thread Starter Sandra van der Lingen

    (@svanderlingen)

    12 years, 1 month ago

    Hi Tobias

    Thanks for sharing this. I’ll further explore. The meetup btw was in North Sydney. Perhaps you can join one day.

    Bye,

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    12 years, 1 month ago

    Hi,

    no problem, you are very welcome! 🙂 I hope this helps!

    And yes, Australia is definitely on my list for a future vacation 🙂

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Filtering on user id.’ is closed to new replies.

Tags