Query field Problem

  • Johndesu

    (@johndesu)


    11 years ago

    Hello,

    I have an urgent problem that i need to know if there is a way to fix it.
    I got the plugin and bought the edit mode as well.

    This service has a super admin and a normal user. The normal user submits a form that will be added to the table. That table will have an unique ID which is the Submit time like this: 1429895167.1110.
    The problem here is that when a normal user submits that, it needs to query that number for him (Like the successfull message). Is this possible?
    If not, can i use a table list that shows only the submit forms of the current user? This way i can write on the successfull message to check the table list of his submits…

    Please help! This is really urgent!

    https://wordpress.org/plugins/contact-form-7-to-database-extension/

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

    (@msimpson)

    11 years ago

    On the CFDB Options page, there is an option for Generate [submit_time] tag for Contact Form 7 email. This means that in CF7, you can put [submit_time] in your email template and that value will get populated. But there isn’t a way to feedback that information through the CF7 successful submission message.

    Thread Starter Johndesu

    (@johndesu)

    11 years ago

    Hello Michael.
    Thank you for the quick reply.

    This is what i tried to work around this problem.
    When a user submits the form it will redirect to the page that queries the table of the current user logged. That way he can see the ID immediatly when he posts it. Is there a way to change the Field submit_time to “ID” and change the styles of that particular cell?

    Plugin Author Michael Simpson

    (@msimpson)

    11 years ago

    I assume you mean that on the redirect page, there is a short code to query the user’s posts. Sounds like you are using [cfdb-table use attributes like “headers” and “style”]. Something like this:

    [cfdb-table form="your-form" headers="submit_time=ID" show="submit_time,/.*/" orderby="submit_time DESC" limit="1" id="mytable" style="#mytable td:nth-child(1) { /* your CSS here */}"]

    Thread Starter Johndesu

    (@johndesu)

    11 years ago

    Thank you very much for the support Michael.

    I only have 1 last problem (which is still important).

    When i export the database to excel, how can i get the submit_time in the number format like “1429895167.1110”? Since we’re working with submit_time as an Unique ID is important to be shown on the excel format as well…

    Plugin Author Michael Simpson

    (@msimpson)

    11 years ago

    Format cells in that column as “Text” to stop Excel from changing how the value is displayed.

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

The topic ‘Query field Problem’ is closed to new replies.