Forms & Trackers
Forms and trackers can be added to your workspaces to collect and store data Trackers are searchable databases that archive information.
Trackers have a variety of exciting features:
Out of the box tracker templates for common tracker use cases
Familiar and flexible view to easily sort, filter, search and support for specialized column types like email address, currency, date, people, teams and more
View & share comments, @mention a person on specific rows in the tracker enabling you to keep the conversation together with the data
Built-in support for formulas, link to a row, team specific views to a tracker, attachment support and many more capabilities to empower your users
Full screen view of the tracker to make it easier to work with
Available in the MangoApps mobile apps to maximize productivity wherever you work
A tracker captures all the information you need to track and manage different kinds of data in your organization. It’s kind of like the traditional spreadsheet but with the power to
Easily create multiple tables (which gives different filtered views of data),
Create online forms (which allows to submit structured data),
Share comments & mentions (which enables having a conversation on data in context) and much more
Users who have permissions to create can create a new tracker from a
System or Custom Template
Microsoft excel, Google spreadsheet or a CSV file
Users who have permissions to create can also clone an existing tracker to get started. Cloning a tracker gives a choice to
Copy only the structure (columns, tables & forms) or
Copy both the structure & data
Ability to move, archive or delete a tracker is available to the tracker creator and team admins
Admins are able to create and edit tracker templates for use.
Creating a Tracker template helps ensure continuity in your forms and trackers. By creating templates your users will be able to to create their own trackers that contain all the information you require. This makes it easier to share data since everyone's tables will contain the same general information. MangoApps comes with several templates right out of the box, but by creating your own custom templates, you can ensure that your company's unique needs are met.
From your Admin Portal, click on Modules. Next, select Trackers. Finally, click on New and select either Create from Scratch or Create from Spreadsheet.
Provide a Template Name. It can 100 characters or fewer
Select the Icon and Color
Provide a short Template Description. You description must be fewer than 500 characters
Click on Save
When you create a tracker, it is not activated until you manually activate it by clicking on Activate Template.
To customize your template, click on the Tools dropdown.
Click on Add New Columns to add columns to your tracker template
Insert, Modify, and Delete Columns shows you a video on the process
Edit the columns and rows on your table. You can also create filter for your tables
Duplicate the table
Download and XLS or PDF version of the table
To start, navigate to the Admin portal and click on Modules. Then, click on Trackers. On this screen, you will see Tracker templates.
To clone, edit, or deactivate a tracker template, click on the three dots.
Domain admins have the following settings to customize the trackers module
Who can create new trackers?
Can tables & forms be shared publicly on the internet with no sign-in requirements
Automation message (e.g., confirmation message when a form is submitted) to be sent from which user
Name for the trackers module
Ability to add the trackers module to the primary navigation for all users is available (like it is for other modules in MangoApps)
To configure tracker settings, click on Settings
If desired, modify the tracker label
Set who can create trackers
Any user can create one
Any network user can create one
Only domain and team admins can create one
Set public sharing settings
Allow grid views to be shared in public with no sign in required
Allow form views to be shared in public with no sign in required
Click on Save once satisfied
If you already have a spreadsheet that you are currently using, you don't have to repeat all the work you did when you originally set it up. By importing the spreadsheet you created, into MangoApps, you can easily create a tracker and even a form that can be used to gather and breakdown your data.
If you create a tracker from an imported spreadsheet, the data in the spreadsheet will be imported as well.
To start, from the admin screen, click on Modules, then Trackers. Next, click on the dropdown menu in the upper right hand corner of the screen, and select Create from Spreadsheet
Choose a .csv/.xls/.ods file from your computer
Select if you want set the first record as the header
Designate a Template Name Your title must be 100 characters or fewer
Select icon and color
Input a template description. Your description should be 250 character or fewer
Click Create to create your tracker
To ensure that your file is in the correct format, we recommend you download the sample .csv file on the screen.
Your tracker is now created. To make your tracker available, it will need to be activated first. To activate your template, click on Activate Template.
Team members based on their role can be given specific permissions that determine what they can and cannot edit in the tracker. Permissions are an important part of healthy team and with the right permissions, you can ensure that only certain people are permitted to change the information in your tracker.
Permission users have on a tracker can be different than the permission on another tracker in the team.
In a project, group or department the following permissions by role are supported
Creator
User who creates the tracker has full access on all tracker actions
There can be only one user with creator permission
Creator can grant permissions to team members on the tracker
Creator permission can’t be transferred at this time
Team Admin
All team admins have full access on all tracker actions
There can be multiple team admins in a team
Team admins can grant permissions to team members on the tracker
Team admin permission can be given / removed from a team member
Team Member who is a Network User
By default can add or import entries in the tracker
By default can edit, lock and archive any entry in the tracker
By default can delete any entry in the tracker
By default can share table & share form with non team members
Tracker creator/ team admins can give or revoke the above 4 permissions from all team members who are network users
Team Member who is a Guest User
By default can add or import entries in the tracker
By default can edit, lock and archive any entry in the tracker
By default cannot delete any entry in the tracker
By default cannot share table & share form with non team members
Tracker creator/team admins can give or revoke the above 4 permissions from all team members who are guest users
Non Team Members
By default in a private or unlisted project, group or department, non team members have no access to the tracker
By default in a public project, group or department non members have a view only access to the master table only
Refer the “Sharing” section below for how to give non-members permissions to specific tables & forms
You can set custom settings for each tracker.
From the tracker, click on the three dots.
Click on Edit Template Properties to modify the tracker
Here, you can edit the template name, icon, colors, and description.
Clicking on Manage Template Permissions will allow you to set various permissions for the tracker.
You can specify what type of users can:
Add/Import Records
Edit/Lock/Archive Records
Delete Records
Share Views
When you have made selections, click on Close
Clicking on Notification Preferences allows you to set up default notification setting for the tracker.
Your users are still able to modify their notification settings based upon their personal preferences.
