Quick Tip Friday - Track Changes to Records in Your App

[@agustinsantiagocosentino1061]

Can you provide the field with the long fórmula?

[@GamingMemories141]

Thank you! Very informative

[@fais687]

Sir, the link in description cannot open

[@evanpfister599]

Here is the formula he uses.
left([Updated By], find("@",[Updated By])-1)&if(count([Related Logs])=0," | NEW",if(lookup(index(orderby([Related Logs],[Last Updated],true),1),"Log",Log ID, Title)=[Title], "", " | [Title] from "&lookup(index(orderby([Related Logs],[Last Updated],true),1),"Log",Log ID, Title)&" ➔ "&[Title])&if(lookup(index(orderby([Related Logs],[Last Updated],true),1),"Log",Log ID, "Date")=[Date], "", " | [Date] from "&lookup(index(orderby([Related Logs],[Last Updated],true),1),"Log",Log ID, "Date")&" ➔ "&[Date])&if(lookup(index(orderby([Related Logs],[Last Updated],true),1),"Log",Log ID, "Type")=[Type], "", " | [Type] from "&lookup(index(orderby([Related Logs],[Last Updated],true),1),"Log",Log ID, "Type")&" ➔ "&[Type]))
I used the link in the description: www.appsheet.com/templates/Inline-Log?appGuidString=a6970f26-6117-4e0f-a953-907f6d18495e
Then clicked "Look Under the Hood" and went to the automation tab. From there you can copy the formula, though you wont be able to edit it on screen.