As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2063911
timestamp for column
Closed

Comments

  • Julie started the conversation

    Hello,

    Is it possible to define a datetime column that auto populates with the current datetime?


    Thanks,

    Julie

  •  2,576
    Aleksandar replied

    Hello again Julie.

    I am sorry to disappoint you, but unfortunately this is not implemented in the plugin's built in features. However, there is a workaround for this.

    For example, I created a simple manual table:

    9084543304.png

    wdt_ID column is being automatically generated, and is usually hidden, but I've displayed it here for explanation purposes.

    When I created a table, and added the first row, I could then modify it. So, in order to set the Datetime column to be auto-populated, I had to open the table in the database. It is being stored as wp_wpdatatable_6, and you can see its database name in Editing tab in the settings above the table:

    8975736742.png

    Then, in PHPMyAdmin, I opened the table, and ran the following query:

    ALTER TABLE `wp_wpdatatable_6` CHANGE COLUMN `datetime` `datetime` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP;
    
    7657773118.png

    After that, again in the Editing tab, above the table, I changed the "ID column for editing" from "wdt_ID" to "datetime" (as you can see in the screenshot above). Then I disabled editing for "wdt_ID" in the column settings:

    4393899573.png

    datetime column, being the "ID column for editing" automatically cannot be edited, but is automatically filled.

    You can also choose to hide it from view if you'd like.

    I hope this helps.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables