Finance | Project Operations, Human Resources, ...

To save the comments in field with curuser name and date and time

(0) Share

Report

Posted on by Dineshkarlekar

1,457

hi,

i have a comment box on my form which i kept memo field , now when i put my comment there it should get save with current user name and date and time , and it is not editable to another user and the next user will put his comment below that which will be also get save with user name ,date and time and it will continue like this , and any user cannot edit previous comment but can read who commented previously with comments and their name and date and time ,

it should appar like

/user comment / - name - date and time,

and so onn

please guide me on this ,

thanks ,

Diensh

All responses (5)

Answers (0)

Dineshkarlekar 1,457 on at

Like (0)

Report

To save the comments in field with curuser name and date and time

hi,

I have restore the datasource on form , now i am getting two fields , created by and created date and time , now need to make the row not editable to after saving . when new line is added all the previous line must be non editable only new line is editable , can you please guide me on this To add comments in fields with comma seprator.

thanks , regards ,

Dinesh
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

To save the comments in field with curuser name and date and time

You shouldn't do anything on any relation. What fields a table has is defined by the table itself, not by relations from other tables.
Dineshkarlekar 1,457 on at

Like (0)

Report

To save the comments in field with curuser name and date and time

here is my table relation details , plz let me know what i have to do here to get the user name and date and time with comments after saving .

thanks, DINESH
Dineshkarlekar 1,457 on at

Like (0)

Report

To save the comments in field with curuser name and date and time

hi , martin

Thanks for reply , created date and time property and created property is set to yes

i have added grid to form , i have added user name and date and time field to table .
Suggested answer

Martin Dráb 230,445 Most Valuable Professional on at

Like (1)

Report

To save the comments in field with curuser name and date and time

By coincidence, I already provided a solution in your other thread: To add comments in fields with comma seprator.

Your data model doesn't meet your requirements, therefore you need to change the data model. Instead of putting multiple values to a single field (and violating database normalization rules), create a separate table for the comments (with 1:n relation to the main table). Then enable CreatedBy and CreatedDateTime properties on the comments table to automatically collects the metadata.