Maintain & Track Important Data
MangoApps trackers act as a modern database, allowing users or admins to maintain and manage crucial information. Users and admins get access to flexible data tables just like spreadsheets, with powerful database tools allowing users to search, share, modify, import/export, share, or use the data in a number of ways. Team admins or tracker creators can also easily relinquish or transfer ownership rights.
Secure Data Collection With Forms
Rather than making contributors access the database, or even reveal sensitive data, custom forms make it easy to collect information from anyone, saved directly into the tracker. Forms are easy to create with fields that can be named, described, or rearranged, and can even be assigned default values or set to required. Any number of forms can be created for a tracker, allowing for different views or points of data entry depending on the user.
Easy To Create With Custom Fields
The online tracker designer makes it easy for anyone to create trackers and forms from scratch. Set rules or reorder fields with a simple drag and drop. Customizable field options include: Text or Rich Text, Numbers, Drop-downs, Checkboxes, Radio Option Buttons, Date, Price, Smart Formulas, File Attachments, or a pre-populated look ahead list. Fields can be set with default values that can even be applied in bulk to blank fields if done after the fact.
Ready-To-Use Tracker Templates
MangoApps comes shipped with 20+ ready-to-use tracker templates to cover a range of use cases including applicant tracking, time tracking, expenses, asset/contract management, payroll, meetings, requests, bugs & issues, content planning, customer tracking, and much more! Save time and see better consistency with ready-made and customizable templates.
Create, Edit, and Track Data From Anywhere
Users can create, edit, and add to existing trackers right from the mobile app. This means that collecting data or accessing important information can be done from anywhere, on any device.
Import From Excel, Google Sheets, or CSV
Users can import existing entries right from a Microsoft Excel, Google spreadsheet, or CSV file to add new rows to an existing or new tracker. Templates can also be created by importing a spreadsheet to bring in data using the columned mapping of fields.
Keeping Data Clean
To ensure that collected data is clean and clear, when designing a tracker fields can be set to required or even specify a valid acceptance range. MangoApps will take care of enforcing validation on the input data, with error prompts for users to guide them in fixing the data input.
Compliance Track and Audit Assets
Track items and audit lists and compliance checklists with capabilities such as locking or archiving rows, export capabilities, and immediate change notifications.
Powerful Search To Find Useful Information
Use the built-in search tool to search tracker entries and get right to the necessary information. Active filters make searching the database targeted, while sorting options present data in any necessary order.
Multiple Tracker Views
Give users access to relevant data, or limit prying eyes by creating unique tracker views. Enable or disable columns as needed, and even create filtering conditions that ensure only the necessary data is displayed. This makes it easy to share a tracker view with an entire team or organization, but limit individual view permission based on ownership or other filters.
Smart Formulas
Similar to the power of a traditional spreadsheet, configuring smart formulas is easily done by selecting a ‘formula’ column-type, and creating formulas utilizing field names. Formulas include addition, division, multiplication, comparison functions, percentage, and date/duration calculations.
Link Cells, Connect Projects, and Reference Crucial Data
Link rows and pull values or data from another tracker to share real-time information across projects. Track cross-project date dependencies and consolidate information across multiple trackers to create a master database.
Drill Down With Filtered Data and Sorted Information
Users can filter and sort columns using a range of pre-defined conditions or values to drill down data for their needs. Multiple filters can be applied at once, effectively hiding entries until cleared or refreshed. In the master tracker view, filters are set only temporarily and will impact the view of other users.
Keep Track of Changes With An Activity Feed
Every tracker keeps an activity feed to update relevant team members of new entries, edits, deletions, or notes. Admins can set the behavior of these events in the newsfeed, additionally allowing comments to be posted on the feed post. A tracker log keeps a running record of changes to the table or forms and notes the user and time/date.
Stay Organized With In Context Conversations
View and share comments, react, reply, and mention other users in the newsfeed or on specific rows to keep conversations together with data. Additionally, users can use chat to eliminate the need for separate conversations or emails away from the heart of the data.
Consolidate Key Data Across Trackers and Build Master Reports
Manage and bring together data across multiple trackers to guide project management, spot trends or crucial issues, and much more. Get a shareable link or export tracker data in PDF or XLS for external use cases. Admins also get access to a tracker log that keeps a running report of all tracker changes.
Integrate Trackers with Calendars
Entire trackers or specific table views with one or more date field entries can be added directly to the MangoApps calendar. Entries will be visible to the user submitting the entry and their manager. Trackers become an ideal resource for event planning, schedules, tracking milestones, and more. The calendar can be filtered to only display tracker created events or discerned by color.
View Forms and Tables Directly On The Dashboard
Embed tracker forms or tables directly on the user dashboard. Widgets give users easy access to their team forms and tables, or those that have been set by default by admins. Users can also easily access these forms and tables from the mobile app, making it easy to use on the go.
@Mention and Notify Users
User lookahead allows for @ mentioning of a user in a tracker cell. When a user is mentioned, they will get a notification and will see the record feed and any comments/activity. Establish data ownership, assign roles, and ensure that stakeholders don’t miss a beat.
Specific Column Types Every Data Type
When creating or modifying a tracker, the creator sets a column type for every column that is inserted. These align with the type of data that will be entered in and changes the behavior of the column accordingly. These column types accommodate numbers, amount, check boxes, date, email, phone number, rich text, URL, radio box, user/team look ahead, and tracker lookup/reference. Trackers also include system columns which identify data by submission/modified user and date and can be hidden as needed.
Save Column Width and Height For All Users
Tracker creators and admins have the ability to set column width and height to be applied to all team members. Rows can be set to short, medium, tall, and extra tall heights, while column widths are set freely on column borders. When changes are made, a save button appears on the top bar to apply the change. These can also be set differently for each table view within a tracker, ensuring that settings best match the visible data.
Apply Bulk Row Operations
Rows can easily be selected in bulk with an option to ‘select all’ up to 500 records at once. Bulk actions include the ability to lock/unlock, archive/unarchive, or delete entries. Archived entries can be accessed by selecting the archived view from the table view dropdown. Bulk actions will require a confirmation to ensure that large scale changes are made thoughtfully.
Additional Tracker Features
How Our Customers Use Trackers
-
1
Track and maintain important business data
-
2
Quickly and easy gather data or submissions using forms
-
3
Search, share, or use tracker data based on business or team needs
-
4
Manage notifications and set permissions for internal or external user editing
-
5
Export data with ease in a number of usable formats
-
6
Track and manage the response of change requests, purchase requests, and issue reporting
-
7
Maintain facility and office inventory or assets
