Timestamps are crucial for tracking when records are created or modified, making it easier to maintain, audit, or rollback data in your applications.
CodeDesign allows you to connect forms to databases where upon submitting the data through forms, the data will be stored in the CodeDesign database. Timestamps will help you get the exact time of submission of each entry made by visitors on your website.
Let’s walk through the process step-by-step.
What You'll Need
A CodeDesign project with an active database.
A form integrated with Database where form entries are saved to database on clicking the submit button.
Adding Timestamp Fields on CodeDesign Database
Head to the 'Database' workspace from the bottom menu of the builder and then
navigate to the 'Field' Section.
Now click on the 'Add Field' button to add the field for the timestamp.
Now give a name for the field and then select 'Created On' from the dropdown menu for data 'Type'
Now, choose your desired date and format by clicking on the 'Update Date Format' option. Save once the format is set.
Finally, click on 'Save Fields' and your new 'Created on' field will be saved to the database
Once this is done, your database will store the time in this field when ever a new data is entered via forms or directly.
Video Guide - Adding Timestamps to Database
Here's a short video that walks you through the steps to add timestamps. If you have any questions, please don't hesitate to reach out to our support team. You can do so by simply clicking on the messaging option at the bottom right of the screen. We are here to help!