Logo
For example "scheduled tasks"
Search
Info
Content
Category Navigation
  • 🎯  Solution Guides

  • Low Code Solutions

    Add "Tabs" to your app

    ID Target Link

    Use an address field to display a static street view thumbnail

    Turn your menu into a fixed menu

    Auto close mobile menu

    Display record information in a card

    How to add a back button to your app

    Add a collapsible accordion element to your app

    Code Snippets

    PHP Curl Create New Record

    PHP Get Records With Filters

    Google Scripts - Get record and create new records from connected table

    Save Tables and Fields into Spreadsheet

    Google Scripts - Export all records

    Webhook to save deleted records

    Send Messages to Slack

    Restrict Space and Force Uppercase in a Form

    Building Advanced Features

    Use Validation Rules to Ensure Unique Votes Per User

    Use Record Rules to Create an Audit Log

    Track current inventory with transactions

    Schedule Bookings and Prevent Double Bookings

    Create orders with multiple items and varying quantities

    2 Step Forms

    Unique Record Validation

    Restrict Editing Records to Record Owners

    Sum date/time field

    Duplicate Records

    Advanced App Customization

    How to embed a Tadabase page on another website

    Adding external fonts

    Custom Favicon

    Making apps mobile friendly

    Show date/time as a countdown

    Importing many images at once

    Adding QR Codes

    Adding charts to PDFs

    Customizing your app shortcut for mobile phones

    Animate parts of a page

    Design Customization

    Changing background colors

    Set background colors to the edge of a page

    Change the background of a column

    Add padding around a component

    Using an image as background for a page

    Adding a background image to a row, column, or component

  • Duplicate Connected Records

Categories
🎯 Solution Guides
Building Advanced Feat...
Use Record Rules to Cr...

Use Record Rules to Create an Audit Log

You can use record rules to create and track audits in your app.

 

Before we begin, we will go over what we are trying to accomplish in this demonstration.

Say you have several projects and you have users with login access to change or update the projects, you may want to create an audit log to track all updates, edits, and deletes being made to your projects. 

 

By creating a form within the project details page we can use the form to edit the project and with the form's record rules we can create a new connected record within the audit logs page with the Auditor's details.

 

Now that you have a general understanding of what we're trying to accomplish let's get into the specifics:

 

The first step is to go into the data builder and create two data tables: Projects and Audit Logs. In the Projects Table you can add a few fields such as: 

  1. Project Name
  2. Due Date
  3. Project Details

 

7EJxVXYpUuqqfAaLhxilCKaEJ37O4zvJsw.png

 

In the Audit Logs Table you can add: 

  1. A text field called "Auditor Name"
  2. A date/time field called "Audit Occurred at." 
  3. A connection to Projects
  4. A connection to Users

 

HTyRwKkmkuJ5U4H9L21hNDKRN3yH6NdciA.png

 

 

Now that we've built our data structure let's move on to the Page Builder to design how our data will be displayed. In the page builder, add a page with a table component and select the Projects Data Table. Then select Quick Add and choose the first three options which should consist of: a form to add projects, a details page, and a table of connected audit logs within the details page.

 

v8_LRB-9qR1e8P1ErecGg2Yo6A46iy93Eg.png

 

 

Now the you have created the projects and details pages, you can to go into the details page and select to add a component. You can choose a Form and select to update this page's projects and click Quick Add.

 

-lo2L4vdZtd2OkA-h7Fpp-hvEYuq2lG1VA.png

 

 

 

Now you can go into Form Rules, click on Record Rules and select Add New Rule. Then select to Insert Connected Record >Audit Logs and set three rules:

Set >User Name to Auto Logged User

Set >Auditor Name to Logged in User's Field of Name

Set >Audit Occurred at to Current Date and Time

 

_IgKj0am-eM3yAiPfkDV2AIxRk9myZJR1A.png

 

 

Now you have created the rules necessary to track changes on your app. To test this feature on your app, first create a user by heading to the Users Tab. You'll need to be logged in to a user in order for the app to know who is making any changes.

 

Wt_vvz0uZbKTagLxagCfcZdueDXcLlwyrQ.png

 

To test your app, simply login, create a project and make an edit. 

 

How did we do ?

Previous Article
Use Validation Rules to Ensure Unique Votes Per User
Next Article
Track current inventory with transactions
Back to top
API
100% Operational
Apps
100% Operational
Builder
100% Operational
Overall Status
100% Operational