Read Only Time Stamp

[chrislynch8]

Hi,

This is what I want to achieve. When the status of an Account is set to complete I when the Date it was set to complete filled into the custom date field automatically and only once and the User who set the Account to complete is also added to another custom field that will be read only.

For example, when the Account is edited and set to complete that the date is then filled in, but if another user logs in and edit the Account Again the date will not change..

Is this a job for Workflow or a custom Hook.

Rgds
Chris

[ros.vol]

Hi,

It seems that you can use customCode for this.

So when status is set "Copmlited" nobody cant edit the date?

[chrislynch8]

Yeah.

I have a custom date field that I am only showing in the detail view? Same as the last modified date. I have a custom relate field to user, that I will also set read only nad have the user that set it to complete in there.

Rgds
Chris

[ros.vol]

try to use in field definition:

'customCode' => " {if $fields.your_status_field.value = 'you_value' } call javascript function that will set needed fields as ReadOnly {/if}"

[chrislynch8]

Maybe I should have mentioned I have the Pro version so I can set the fields to read-only via Fields Level Security.

I think it will be safer and easier to do with the Workflow.

When status from any other the other options to Complete.
Set date in customfield to Now
Set User to logged in User.

Rgds
Chris

[ros.vol]

Ahh, sure it would be better.

[chrislynch8]

Taking this one step further how can I create it so instead of having two fields, I can show it the same way the modified date is show by default.

(date_time) by (user)

Where is the code that set this field up. NEVER MIND FOUND IT.

Rgds
Chris

[chrislynch8]

Ok.

Looks like I cannot do this via Workflow as I am unable to set the date of the datefield and I am unable to get the user that edited the Account when it was set to Complete

How can I do the following in Logic Hook. Only run code if Account Status changed from (defined values) to Complete, as I would with a workflow???


Rgds
Chris

[heta]

print $bean->fetched_row['status']; // this gives u the status saved earlier
print $bean->status; // this is the status which has been selected this time

ur condition depends on these values.

hope this helps.

[chrislynch8]

Thats perfect, thank you very much.

I was able to define old values and the new one....

But I am unable to get the user name of the currently logged in User who is editing the file.

I am using the following

$current_user = $bean->user_name; but it doesn't get the user name of the user who is currently editing.
Rgds
Chris