Hiding or removing duplicate entry using filter

  • Hi Michael,

    Still, wonderful plugin, and thank you for your unparalleled support.

    Is there any filtering options that let me hide/remove duplicate entries?

    On my site https://www.myanmarbizconference.com/b3m-list-of-topics/ – there’s a Suggest Topic registration button and will be redirected to a form. Once done filling the registration and submitted, the suggested topic will then be shown on the list (Topics Suggested by Attendees). If someone is interested to speak on that topic, he will just click on one of the suggested topic and will be redirected to Topic registration form, with pre-filled topic name field. After submission, the suggested topic will now be included on the “Topics being Presented” list. The problem is the topic that has already a presenter is still visible in the “Suggested Topic List” and open for another clicking. The said topic should be transferred to the “Topics being Presented list” and removed from the Suggested topic listing. I need to have a filtering that when the suggested topic is grabbed by an interested speaker, it will not show or should be hidden or maybe removed from the suggested topic list to prevent duplicate registration.

    Is there any workaround on this or possible solution using your plugin?

    Again, best plugin so far for my task.

    Regards,
    Rovic

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    You can address duplications (1) going in or (2) going out.

    (1) you can write code to prevent duplication submissions

    (2) You can filter out duplicates from a short code by writing a Transform Class that checks for duplicates.

    Thread Starter rovichonrado

    (@rovichonrado)

    Hi Michael,

    Thanks for replying, as always…

    I’m sorry but my coding skills is not yet solid. Can you elaborate more the 2 suggestions that you said? Or do you have sample codes that fits on my requirements?

    All I need to accomplish is to remove the topic on the suggested list automatically when someone wants to be the speaker on that. Say the topic is the Suggested list, when I click on the link, it will open a topic registration page, once submitted, the topic will be removed on the suggested list and will be visible on the list that already has presenter.

    Thanks again in advance. More power to you.

    Rovic

    Plugin Author Michael Simpson

    (@msimpson)

    This is not simple to do. CFDB is designed to capture and report back submissions but not to edit and delete them. (Example of a hook, but it is not for delete)

    To go the delete route, you would need to add a hook into the topic registration where you would put in code (SQL) to find and delete the suggested topic. You would have to understand the DB structure. Each form field is a row in the DB, so to delete an entry you have to delete all its rows (all with the same submit_time).

    Or instead of delete, set a field to flag it as registered, and in short codes displaying suggestions filter on not-registered.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Hiding or removing duplicate entry using filter’ is closed to new replies.