Setting Up KTL Record History in ⏱️10 Minutes

In this tutorial, I'll demonstrate how to enhance a basic clients' table by adding a column for record history. You'll learn to set up a new table in Knack to store record histories, configure various fields, and use specific keywords and parameters for functionality. Additionally, the guide covers creating pages to view and manage the history, ensuring only authorised users can access them.
Watch the video to master tracking changes and updates to your client records efficiently.
Let's dive in!
Add Record History CSV Template: 📁
github.com/cortexrd/Knack-Toolkit-Library/wiki/Keywords#_arh---add-record-history
Add the below to the table you want to have record history on:
_vrh=[History, fa-history], [ktlRoles, Developer, Admin], [align, center]
Add the below to the Edit form:
_arh=[context, Edit Client], [expiry, 90d]
🆓Sign up with Knack for Free 🚀: www.knack.com/r/chprojectsupportltd
(Affiliate Link)
📌Timestamps:
0:00 - Introduction
1:12 - Adding table for record histories
3:45 - Setting up required fields and attributes
6:20 - Connecting fields and setting up attributes
8:55 - Configuring display settings and field formats
10:00 - Conclusion
🛠️Knack Toolkit Library (Github)
github.com/cortexrd/Knack-Toolkit-Library
🌐KTL Discussions (Github)
github.com/cortexrd/Knack-Toolkit-Library/discussions/47?sort=new
Cortex R&D KZbin Channel: www.youtube.com/@cortexrdinc.4479/videos 🎥
Cortex R&D: ctrnd.com 🌐
CH Project Support Limited: www.chprojectsupportlimited.com 🎥

[@djaphotic]

Note that when importing the CSV (not demonstrated in this video), Auto_Increment is not supported as a field type or option. You have to manually replace this field after import with an auto incrementing field type as you cannot convert it (conversion is not supported).

[@djaphotic]

After some more research, it looks like you can convert the field (after import) but it displays a warning that requires you to tick a small box (that warns you existing data will be deleted) before you are given the option to save.

[@chprojectsupport]

Agreed 👍