You need to sign in to do that
Don't have an account?
Nikhil Tripathi 13
formula field requirement
I have a requirement to create response time between case(object) creation date and visit (object) visit date field.
But the challenge is that for one case we have multiple visit AND i have to show the response time for only first visit creation.
can it be done with no code. ?? anyone please suggest
But the challenge is that for one case we have multiple visit AND i have to show the response time for only first visit creation.
can it be done with no code. ?? anyone please suggest
Your flow shoold be something as below.
It should be recordtriggerd flow on service visit object
You have to get record of servicevisit related to the service visit and sort it by created date and get the first created service visit.
One you get the service visit record you have to create formula to calculate difference between date fields and update it.
Let me know if you face any issues.
If this solution helps, Please mark it as best answer.
Thanks,
All Answers
Are you okay to calculate it using Flow ? It may not be possible with formula field
Thanks,
I am okay with flow as well .
Please guide.
Your flow shoold be something as below.
It should be recordtriggerd flow on service visit object
You have to get record of servicevisit related to the service visit and sort it by created date and get the first created service visit.
One you get the service visit record you have to create formula to calculate difference between date fields and update it.
Let me know if you face any issues.
If this solution helps, Please mark it as best answer.
Thanks,
This wont reflect for existing records. If you want so you have to dummy update the service visit records using dataloader .
Thanks,
As the flow is on service visit this object data should be updated do that flow gets triggered and it processes the logic.
Thanks,
Sai Praveen ,
Can we connect once , there is some problem with the flow I am facing right now