Title: Query field Problem
Last modified: August 24, 2016

---

# Query field Problem

 *  [Johndesu](https://wordpress.org/support/users/johndesu/)
 * (@johndesu)
 * [11 years ago](https://wordpress.org/support/topic/query-field-problem/)
 * 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/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

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

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years ago](https://wordpress.org/support/topic/query-field-problem/#post-6056252)
 * 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](https://wordpress.org/support/users/johndesu/)
 * (@johndesu)
 * [11 years ago](https://wordpress.org/support/topic/query-field-problem/#post-6056253)
 * 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](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years ago](https://wordpress.org/support/topic/query-field-problem/#post-6056340)
 * 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](http://cfdbplugin.com/?page_id=93)
   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](https://wordpress.org/support/users/johndesu/)
 * (@johndesu)
 * [11 years ago](https://wordpress.org/support/topic/query-field-problem/#post-6056439)
 * 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](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years ago](https://wordpress.org/support/topic/query-field-problem/#post-6056465)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [11 years ago](https://wordpress.org/support/topic/query-field-problem/#post-6056465)
 * Status: not resolved