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 |