Answered

Calculation Date Field that shows Last Edited for a Specific Field

Hi Insightly Community,

We want to be able to create a date field that displays the date a specific field in an object was last edited.

Does anyone know how to do this?

Many thanks,

James

0

Comments

1 comment
  • Hi James, 

    Perhaps you could use the calculated field, although I'm not sure this is possible because Insightly only posts updates when an entire record is edited not when a specific field is edited.

    To my knowledge it would be best to reference historical data to know when the field was updated. In order to get historical data, you will want to push the record's data to a flat file every time the record is updated. Then you can check if the previously updated record has a different value in the flat file, if so, then "today's date" would be the date that that specific field was updated. Lastly, plug that date back into the record using a PUT webhook.

    You could accomplish this quickly with Insightly Workflow Automation, Zapier Webhooks, Insightly API v3.1, and Google Sheets. 

    Let me know if you need any help.

    Thank you,

    Micah Feldkamp

    2
    Comment actions Permalink

Please sign in to leave a comment.