You need to sign in to do that
Don't have an account?

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
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
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/
i need without coding is it possible.
Thanks
Did not quite understand the requirement.
Are you trying to track the time when the User is doing a Look up Search?
Regards,
Ashish
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.
Thanks
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
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
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).
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