Deleting Records in Tables

  • I am using Plugin: SurveyMe for a weekly survey. I want to be able to regularly delete the 100 records I receive each week from the table, so I have a “clean slate” every week. How can I do that?

    I fear that if I delete the entire table, it will cause me problems. Is that true?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author DCoda

    (@dcoda)

    Deleting the table will not be a problem.
    It is checked for each time something is submitted, to make sure it is there and that the fields in the form have not been changed since it was created.

    Regards
    D

    Thread Starter KAP10

    (@kap10)

    Thank you for the answer. I have just two questions for further clarification.

    #1 It appears that I still “lose” a record sometimes when I alter the survey instrument slightly – like if I modify the “Response” confirmation message that is sent when the form is submitted, or if I modify some questions (or the answer options) to some of the questions. By “lose” a record, I mean that I still get e-mailed the complete set of answers, but they just don’t appear in the table. It seems like this only happens for the first record after I have made a change like the ones I have described. Subsequent tests after the first one seem to perform just fine. Any ideas?

    #2 When I examine the data in the table, the “info[form_sent]” and “info[form_received]” fields are consistently 4 hours ahead of the actual time. If the correct time is 10:00, it is being recorded as 14:00. I have double-checked the site wide clock and it is correct. Is there a separate control for the time reflected on forms through SurveyMe?

    Thank you so much for your help.
    Kev

    Plugin Author DCoda

    (@dcoda)

    #1.
    I am not at all sure why you would loose a record when you have changed the form.
    The only possible thing i can thing off is that , users can only submit things once. If they resubmit it will be lost.

    #2. The time recorded is UTC / GMT. This is world time, this was done so the time is relevant without having to know the timezone to which the blog is set.

    Thread Starter KAP10

    (@kap10)

    One final question. I promise.

    Is it possible to allow users to submit the form more than once and without having to wait a period of time?

    MY SETTINGS . . . For my form, the “Status” setting is set to “open”. The “Privacy” setting is set to “public”. The “Cookie” setting is NOT checked and I do not appear to be allowed to check it. The “Duration” setting appears to be set to “1 minute”, but it cannot be changed. In actuality, the duration appears to be longer than one minute. The page on which I have installed the form is Password protected.

    Plugin Author DCoda

    (@dcoda)

    There is a known glitch on that settings page. So currently it is not possible.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Deleting Records in Tables’ is closed to new replies.