[Feature] Access old field values in webhooks

[rallisf1]

Need for this feature
Most times I only want to be notified when a certain change is made: e.g. when a status changes from pending to completed. Right now we only have access to the latest field values both in the webhook body and conditions, thus we can never know what the old field values were. e.g. If I update any field value in a row but not status which is already completed my on update webhook whose only condition is where status is equal completed will still fire and that is wrong for my usecase.

Describe the solution you'd like
I'd like to access old field values both in the webhook body (e.g. with prefix old.) and in the conditions (e.g. an "Old Values" optgroup inside the dropdown).

Describe alternatives you've considered
The only dirty workaround is to keep historical data in a separate table, write the condition logic in my own middleware backend and update the historical data via the API.

[o1lab]

Ok, makes sense - we will think about this.

Within audit ( team & auth > audit ) there will be history of all edits. Just a hint, if you think to build something around it.

[DarkPhoenix2704]

Hi @dstala , May i know if this is in your roadmap for future releases?

[dstala]

to be tracked under #3869