How to update a field in Editor automatically upon update of another field

How to update a field in Editor automatically upon update of another field

safaviasafavia Posts: 36Questions: 14Answers: 0

Hello friends,
How can I update a field in Editor automatically once another field is updated?

I have the following price table in SQLServer and I want username in "Last Updated By" field automatically get updated anytime someone updates the any of the other two fields. Note: The username is ASP.NET web application's user. Not SQLServer database user.

I also want to set the Editor as such that the user cannot update "Last Updated By" field manually as this field must get only updated automatically once any of the other two fields are updated by the user.

Thanks so much,
Alan

Answers

  • allanallan Posts: 61,451Questions: 1Answers: 10,055 Site admin

    A server-side event is the best way to do this. That way there can be no interference from the end user.

    Allan

  • safaviasafavia Posts: 36Questions: 14Answers: 0

    Hi Allan,
    Do you have any example code? I'm totally newbie!

    Thanks so much!
    Alan

  • allanallan Posts: 61,451Questions: 1Answers: 10,055 Site admin

    Hi,

    There are a couple of examples on the page I linked to.

    There are also a couple of examples in the blog post that introduced this feature.

    Allan

This discussion has been closed.