Developer forum

Hi Ton

Great idea. In the meantime you can add your own field on the database with a default value of now. This way, when a new record is added to the table, a timestamp will be present. Something like this:

ALTER TABLE YourFormTable ADD
	CreatedDate datetime NOT NULL CONSTRAINT DF_YourFormTable_CreatedDate DEFAULT GETDATE()

BR Nicolai

Thanks Nicolao, 

I'll suggest your 'workaround'. Will my request automatically be on the list for RFE's? Or should I submit a case.

Sincerley,

Ton

Its on the list. Do no more :-).

BR Nicolai

Minor question still...:

If we add our own field for datetime directly into the database, will it show in de DW backend (form entries overview)? Because the field definitions in table DMFormField doesn't know about this field. And if we would add the field there, DW would probably insert its own default (blank) value once a form is submitted, so the constraint would not fire..

Hi Ton

I think it will show up. But, you can just add the field and then run an alter statement on the field to set the default value when records are insterted.

Nicolai

Hi Nicolai,

Take a look at http://developer.dynamicweb-cms.com/forum/feature-requests/data-management-form-features.aspx

I suggested some more things a while ago.

Best Regards,