Solved

Field level audit

  • 8 February 2018
  • 2 replies
  • 4 views

Hi,

 

I would like to create a Field level audit in my smartform to track form changes in approval state and so on. In my case i dont have an application DB or do not have the liberty to create stored procedures to do audit trail  and i have to manage all this within my smartobject and smartform logics.

 

What is the best way to achieve this in smartform rules and smartobject?

 

One lengthy way to do this is --> Write this rule for all control -- if control on my form changes, call the unbound rule which will create record in my audit smartobject.

But this way is cumbersome as i may have more than 200 fields in my smartform and i need to call this rule on all my control changed rules.

 

Any ideas to implement this with least effort?

 

icon

Best answer by Ziqing 9 February 2018, 07:05

View original

2 replies

Badge +9

Why on the control changed rule? If someone opens the form and plays around with the values and doesn't save or submit it, you still want to capture those changes? 


 


Isn't it easier to just save all values in a new record or something on an audit table each time the form is saved or submitted? 

Hi Ziqing,

 

This idea may do my job. Thanks!

Reply