Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
7 months ago

Audit Logs Number of Times a Record is Added or Modified

I am trying to find out how many times a record is added or modified in an app.  I don't want a list of each time this happened I just want a number totalling for each time a record is added and a number for when a form is modified for a particular time period.  Is this possible?

Thanks,

Brian

1 Reply

  • Denin's avatar
    Denin
    Qrew Captain

    You have a few options:

    You can filter a summary or gauge report by the time period you want on the Date Created field. Same thing for Date modified, that would show you number of record added/modified.

    Another option, if you can use Pipelines, then you could create numeric fields in a stats table, and then increment it each time a record is added/modified respectively. Since you want to filter the number of add/change by the time period, you could also do something like:

    • when record added, create a record in stat table with type = record added and numeric field = 1
    • Then you can just create a summary/filtered report for the period you need and see the quantity of changes for that period.

    A third option, you can go to App settings -> App management -> Show audit logs and then filter the logs by the time period you want and the actions to either:

    • record_edit
    • record_add

    If you download (button in top right), the number of rows in the downloaded csv will show you the numbers. Can do something similar from admin console if you have access to that.

     

    If you want to show how many times a specific record was modified was on the form itself, you can make a hidden read only field and maybe use form rules to increment it by 1 each time the record is modified.