Adding Logs to App Side

Introduction to App-Side Logging

App-side logging allows you to view logs that are usually only visible from the Builder on the front end of your app. This is a powerful way to offer users insight into specific types of logs relevant to their activity. Whether it’s tracking page views or monitoring login attempts, app-side logging provides a transparent way to surface critical data for your users.

This feature is available on Tadabase Pro plans and higher

Important Considerations

When adding logs to the app side, it's important to remember that logs can contain sensitive information. Think of logs the same way you think of app data—ensure that they are displayed only on secure, protected pages. This precaution helps avoid unintentionally exposing sensitive details to unauthorized users.

Filtering App-Side Logs

One of the key features of app-side logs is the ability to filter them. Depending on the type of logs you're working with, you can apply filters based on the logged-in user, their IP address, parent or child page details, and more. For example:

• User Login Logs: Filter by the logged-in user’s IP address to show logs relevant to their activity.
• File Access Logs: Filter by record ID to display logs tied to the specific details of the page being viewed.
• Page View Logs: Show logs that correspond to the page the user is currently viewing.

We’ll dive deeper into filtering options later in the guide.

Adding Logs to Your App

In the next section, we’ll walk through the steps to add logs to your app interface, complete with screenshots for easy reference.

1) Add Logs Table

Select the logs table from the list of components: 

2) Choose the Log Table

3) Add the columns and filters

---

Types of Available Logs

App-side logging supports a wide variety of logs, and each type provides different insights into your app’s activity. Below is an overview of the main categories of logs and their specific details.

1. Security & Access Logs

• Page Views: Tracks all page views within the application.
• Blocked IP Logs: Records IP addresses blocked due to excessive login attempts with non-existent accounts.
• Blocked User Account Logs: Logs of user accounts blocked after too many failed login attempts.
• User Failed Login Logs: Captures failed login attempts along with metadata (this requires User Login Logs to be enabled).
• User Login Logs: Records all successful login attempts.
• Magic Link Token Access Logs: Logs access attempts via magic links.

2. Data & Record Management Logs

• Delete Record Logs: Logs records that were deleted when the "Log Deleted Record" setting is enabled for a table.
• Record Change Logs: Tracks updates made to records when 'log record changes' is enabled.
• Equation Logs: Captures equations being run within the app.
• Task Record History: Logs record updates triggered by tasks.
• Import Template Logs: Tracks import templates that have been executed.
• Task Run History: Logs details about tasks that have been executed.
• Email Logs: Records all outgoing emails sent from the app.
• File Upload Logs: Logs files that have been uploaded to the app.
• Secure File Download Logs: Tracks files that have been securely downloaded.

3. Builder and App Activity Logs

• Builder Activity Logs: Logs updates made to data tables, fields, and other builder activities.
• Page Version Logs (Page Change Logs): Tracks changes and comments related to page versions.
• App Restore Logs: Logs the successful completion of app restores.
• Backup Logs: Tracks both manual and automated SQL backups performed for the app.

Filter Options

Some log tables have unique filter capabilities and can be used to filter logs based on unique conditions. 

Page ID/Page Name

When viewing logs that have Page Details, for example Page View logs you can filter the logs to only show record that match the page this log was added to. For example, add a logs table to show who viewed this very page. 

This filter option is available on the following log tables: 

• Pageviews

App User

When viewing records that are connected to the user you can add some advanced filters like: 

• is a specific hard coded user
• is the logged in user
• is not the logged in user
• is connected to the logged in users role. Meaning, any pageview that the pageview happened by a user who has one or more of the same roles as the logged in user. For example, all pageview of just Admins.

This filter option is available on the following log tables: 

• Pageviews

IP Address

When viewing logs that have the IP address field present, the additional filter parameter is 'user's IP Address'

This filter option is available on the following log tables: 

• Pageviews
• Blocked IP Logs

Columns Per Log Table

Security & Access Logs

Page Views

Field Name	Field Type	Special Filter Option
App User	Connection	Logged In User
Page ID	Connection	Page Filters
Page Name	Connection	Page Filters
City	Text
Region	Text
Country	Text
Timezone	Text
Latitude	Text
Longitude	Text
IP Address	Text	User's IP Address
Browser	Text
Platform	Text
Created At	Date/Time

Blocked IP Logs

Field Name	Field Type	Special Filter Option
IP	Text	User's IP Address
Blocked From Time	Date/Time
Blocked To Time	Date/Time
Status	Text
Uploaded At	Date/Time

Blocked User Account Logs

Field Name	Field Type	Special Filter Option
User Name	Text
Blocked From Time	Date/Time
Blocked To Time	Date/Time
Status	Text
Uploaded At	Date/Time

User Failed Login Logs

Field Name	Field Type	Special Filter Option
Uploaded At	Date/Time
User Name	Text
City	Text
Region	Text
Country	Text
Timezone	Text
Latitude	Text
Longitude	Text
IP Address	Text	User's IP Address
Browser	Text
Platform	Text

User Login Logs

Field Name	Field Type	Special Filter Option
Uploaded At	Date/Time
User ID	Connection	Logged In User, Connected To Any Logged In User's Roles
User Email	Connection	Logged In User, Connected To Any Logged In User's Roles
User Name	Connection	Logged In User, Connected To Any Logged In User's Roles
Type	Select
City	Text
State	Text
Country	Text
Latitude	Text
Longitude	Text
IP Address	Text	User's IP Address
Browser	Text
Platform	Text
Screen Width	Number
Screen Height	Number
URL	Link

Magic Link Token Access Logs

Field Name	Field Type	Special Filter Option
Uploaded At	Date/Time
Magic Link Id	Id
Magic Token Id	Connection
Status	Text
City	Text
Region	Text
Country	Text
Timezone	Text
Latitude	Text
Longitude	Text
IP Address	Text	User's IP Address
Browser	Text
Platform	Text

---

Data & Record Management Logs

Delete Record Logs

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Source	Text
Data Table ID	Connection
Data Table Name	Connection
Data Record ID	Id	Connected With Current Record
IP	Text	User's IP Address

Record Change Logs

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Source	Text
Data Table ID	Connection
Data Table Name	Connection
Data Record ID	Id	Connected With Current Record
IP	Text	User's IP Address

Equation Logs

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Data Table ID	Connection
Data Table Name	Connection
Field Name	Connection
Start At	Date/Time
End At	Date/Time
Duration	Text

Task Record History

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Task ID	Connection
Task Name	Connection
Data Table ID	Connection
Data Table Name	Connection
Record ID	Id	Connected With Current Record
Start At	Date/Time
End At	Date/Time

Import Template Logs

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Import Template ID	Connection
Import Template Name	Connection
Data Table ID	Connection
Total Success	Number
Total Failure	Number

Task Run History

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Task ID	Connection
Task Name	Connection
Data Table ID	Connection
Run Type	Text
Total Record Proceed	Number
Start At	Date/Time
End At	Date/Time
Status	Text

Email Logs

Field Name	Field Type	Special Filter Option
Date	Date/Time
Unique ID	Number
Email To	Text
Subject	Text
From Name	Text
From Email	Text
Page URL	Link
Status	Text
User IP	Text	User's IP Address
Browser	Text
Data Table ID	Text
Data Table Name	Text
Data Table Record Id	Text

Delete Record Logs

Record Change Logs

Equation Logs

Task Record History

Import Template Logs

Task Run History

Email Logs

File Upload Logs

Secure File Download Logs

---

Builder & App Activity Logs

Builder Activity Logs

Field Name	Field Type	Special Filter Option
Uploaded At	Date/Time
User ID	Id
Type	Text
IP Address	Text	User's IP Address
Region	Text
City	Text
Country	Text
Timezone	Text
Latitude	Text
Longitude	Text
Browser	Text
Platform	Text
Screen Width	Number
Screen Height	Number

Page Version Logs

Field Name	Field Type	Special Filter Option
Date	Date/Time
Page ID	Connection	Page Filters
Page Name	Connection	Page Filters
Type	Select
Comment	Text

---

App Restore Logs

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Created By	Text
Start At	Date/Time
End At	Date/Time

---

Backup Logs

Field Name	Field Type	Special Filter Option
Created At	Date/Time
Created By	Text
Start At	Date/Time
End At	Date/Time