locked
Calculate age for all records in one entity RRS feed

  • Question

  • Hi All,

    I have one requiremnt. Can you please post any suggessions.

    Need to calculate age for each contacts.(It should be dynamically. User dont want to trigger it manually) contact is  having dob field. So age field should be update on every year automatically for all contacts. We are using online crm. So we can't schedule exe. 

    So we have written one workflow to update the age field, it will run on every day but this recurring workflow is failing after 7days.

    Please let us know if you have any other ideas.

    Thanks,

    Sravan.J

    Friday, November 11, 2016 11:08 AM

All replies

  • Why is it failing after 7 days? it should be running without any issues, but however that is not a viable solution. In CRM Online any custom code will run for 2 mins post which it will be errored out, so the age calculation may not succeed.

    You can have a calculated field if you cannot have an EXE running.


    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Monday, November 14, 2016 6:05 AM
  • Hi,

    For a recurring workflow you could use this workaround:

    Create a new Goal record (a fake one which is used to trigger workflows). Goal records would be updated every 24 hours. So, run your workflow on the update of the goal. You could also put a check condition on the workflow to prevent running workflow on update of other goal records.


    Persian Dynamics CRM Community | انجمن متخصصان فارسی زبان

    Monday, November 14, 2016 7:30 AM
    Moderator