Skip to main content
saurabhs0003
December 21, 2021
Question

How to update modifiedby in database through sail

  • December 21, 2021
  • 2 replies
  • 0 views

Hi All , I have an editable grid from where i am populating data from the db object and also i have an option to add new column . When a user change on existing column then i have to update modified by in database . can u please tell how can i achieve this 

    2 replies

    stefanhelzle0001
    Brainy
    December 21, 2021

    What is your current level of experience in Appian?

    Without knowing any details, I would try to add an additional a!save to the saveInto parameter of the fields. That a!save can then update other fields in that row, including the modified time stamp.

    docs.appian.com/.../fnc_evaluation_save.html

    davel001150
    December 23, 2021

    You simply save the output of the now() function into the updatedOn, and save the output of the loggedInUser() function to the updatedBy.

    You can either do that when they click the Add Row button (so it would be part of your type constructor), or you can do it when you save the form by putting it into the saveInto of your submit button.