Build an Audit History Log in an App

0:00 Intro
0:23 App Demo
1:58 Tables and Columns
3:24 The Automation
3:57 Construction a Summary Column
6:23 Multiple Fields Logged Demo
7:22 Editing the Inline Log Table
AppSheet has an audit log that can be viewed for each app. However this log is separate from the app itself and only available to app developers. In this video I show how to develop an audit log directly in your application so your users can see the changes for a particular record.
This method is useful for applications centered around approval workflows, project management, etc.
App Template
www.appsheet.com/templates/In...

[@user-to8vd4hb9w]

Thanks so much for this! Really helpful

[@djflexkid]

Excellent clip and exactly what I was trying to implement in most of my apps! I knew to get most of it except for the summary part was where I got stuck. Thanks a bunch for this and all tutorials that you put out. It really helps newbies like us a lot. You saved me tons of hours researching the community forum trying to figure this out. Keep em coming!!

[@appify]

You are welcome. You are right the summary column is fairly complicated. Maybe I'll do some more videos on formula concepts because there is a pattern involved that would make it easier to understand.

[@djflexkid]

@@appify Great! Looking forward to more content from you. 😀

[@djflexkid]

Seem to be running into some issues. The From column doesn't seem to be populating. I have rechecked the expression a number of times. It shows as but returns only to TO column.
left([Updated By], find("@",[Updated By])-1)&if(count([Related Crew Changelogs])=0," | NEW",
if(
lookup(index(orderby([Related Crew Changelogs],[Last Updated],true),1),"Crew Changelog",Log ID, "Gender")=[Gender], "", " | [Gender] from "&
lookup(
index(orderby([Related Crew Changelogs],[Last Updated],true),1)
,"Crew Changelog",Log ID, "Gender")
&" ➔ "&
[Gender])
&
if(
lookup(index(orderby([Related Crew Changelogs],[Last Updated],true),1),"Crew Changelog",Log ID, Date of Birth)=[Date of Birth], "", " | [Date of Birth] from "&
lookup(
index(orderby([Related Crew Changelogs],[Last Updated],true),1)
,"Crew Changelog",Log ID, "Date of Birth")
&" ➔ "&
[Date of Birth])
)

[@djflexkid]

Nantha | [Gender] from ➔ Female | [Date of Birth] from ➔ 06/16/1978

[@djflexkid]

Ahha I found the issue. I didn't think the change column was necessary so i didn't include it. Once i added it, its working as it should. But can i ask why its pulling data from all columns even though only one column was changed.
Nantha | [Gender] from Female ➔ Male | [Date of Birth] from ➔ 06/16/1978
I only changed the gender column but its pulling up date of birth column as well.

[@apsarshaik9407]

Hi this great video and I got to learn something new today, I have tried to build similar stuff for my business, I face two problems, 1st one is everything is NEW in the change column. 2nd I'm not able to see inline history, please guide me if possible

[@RobertGrissom-of6mf]

Hi, thanks for the informative video. I am updating that Main row, it shows the history inline but it only shows what i updated it to, it doesn't show the prior information? Also, it seems to create only one row for that item instead of multiple so it just updates that singular row

[@lbgabon]

Awesome idea and solution. It was perfect timing also. I have one question for you. Right now it writes to the log when any change is made to the main table. How could I adapt it to only write to the log if a certain column is changed for instance if the type column is changed. I am trying to create a log that will show when ever in my case a status column is changed and the time it was changed. I also just watched the follow up video on the formula break down very informative.

[@appify]

Great question. To only run the automation when certain columns are changed, you would want to add the following "condition" formula to the Automation event [_thisrow_before].[ColumnName][ColumnName]. To add multiple checks you would wrap them comma separated with or(). Ie. Or(cond1, cond2,...).

[@lbgabon]

@@appify I just implemented your answer in the test app and it worked like a charm. Thanks so much for taking the time to reply and helping others. Very thoughtful.

[@DhongjunLee]

it looks like the underlying tables are gone. Would you be able to provide the updated appsheet with the underlying data?

[@appify]

Sorry about that. Should be fixed now. 🙂

[@ashwatts6823]

𝐩𝓻Ỗ𝓂Ø𝓈Ｍ