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,836

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

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 .

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

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

Was this reply helpful? Yes No