function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12 

2 fields have lookup to user object

Hi,

I have 4 fields

-> 2 fields have lookup to user object.
-> 2 fields have date/time.

but my scenario is when we will enter lookup user at that time need to display current time/date in another field also.

Regards
kumar
hitesh90hitesh90
Hello,

You have to use javascript for auto-populate current time/date in another field as per your scenario.

Thank You,
Hitesh Patel
SFDC Certified Developer & Administrator & Advanced Administrator & Sales cloud consultant
My Blog:- http://mrjavascript.blogspot.in/
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Hi,

i need without coding is it possible.

Thanks
Ashish_SFDCAshish_SFDC
Hi Kumar,

Did not quite understand the requirement. 

Are you trying to track the time when the User is doing a Look up Search?

Regards,
Ashish
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
My requirement is,

I have 2fields(Approving Manager & Approving Manager Date) 
-> When i select Approving Manager, Automatically current time need to display on this filed Approving Manager Date.
Damien Phillippi033905702927186443Damien Phillippi033905702927186443
You need to use code to do it in real time.  If you want it to happen AFTER you save the record you can use workflow rules I believe.
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Through coding(apex,Visualforce) it's working fine but i want Formula field or validation or workflow.

Thanks
justin_sfdcjustin_sfdc
Hi Kumar,
Is it ok to show the Approving Manager Date on the detail page only and not in the edit page. If so then your Approving Manager Date can be defaulted to Today(), which will basically capture the date of the creation of that record, but if you want to update it everytime the record is updated then that field would be a formula field, value being equal to "Last updated Date" field, and again if you want to update it everytime the Approving Manager is changed then you would do it based on Workflow and field update where your condition would be isChanged(Approving_Manager__c).

Let me know if that works for you.

Thanks,
justin~sfdc
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Please explain more.
Ashish_SFDCAshish_SFDC

Hi Kumar, 

This can be achieved through a workflow, i just tested this one in my test org and it worked fine. 

This is what i have, you may change the field names and let us know how it goes. 

Workflow 

Rule Criteria ISCHANGED(Approver__c) 

Evaluation Criteria Evaluate the rule when a record is created, and every time it’s edited

Workflow Action - Field Update 

Field Data Type Date/Time

Re-evaluate Workflow Rules after Field Change Not Checked

Formula Value NOW()

Where approver is the Look up field. 

Regards,

Ashish

kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Hi all,
 i have 2fields 1field is lookup(related to user), another field(text or formula field) when i click to lookup automatically need to display in current date/time.

Please help me anyother using formula field or input filed(text). 

kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Please help me anyother
kumar.fdc81.3902978579608325E12kumar.fdc81.3902978579608325E12
Please help me anyone
Ashish_SFDCAshish_SFDC

Hi Kumar, 

I have already documented the Workflow details in my earlier post above. 

I have also tested that workflow in my test Org. 

When ever you do Edit the Field then that time is updated in the Field specified. 

Let me know if you have questions. 

Regards,

Ashish