How-to questions

Hi! Don’t forget to take a look in the Knowledge Base for answers to common questions :)

How do I...?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Is there a toggle for case-sensitive?

    I know that the search function is not case-sensitive, but uploading records to the database seems to be. We use email address as a unique identifier when uploading new info and will always end up with duplicate records when someone enters their email address differently than previous. For example, Ta305@gmail.com versus ta305@gmail.com would create a dupe.

    Is there a toggle somewhere to tell the DB to ignore upper case?

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • How do I filter views based on business days?

      We have a view that is shared with our contractor showing jobs completed today as well as jobs due tomorrow. We do not work on Saturday so Friday's view doesn't have anything due tomorrow. I set up and shared another view to show the jobs with a due date 3 days from now to help account for this issue on Fridays. Is there a way to combine both views by showing only the next "business" day?

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        2 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
      • Add working days to a date

        We need the ability to add working days to a date, at the moment the only unit available is 'd' which includes weekends.
        Please note - i dont need to work out the number of working days between 2 dates, rather add working days to a start date, in order to determine the end one. Any ideas?

        3 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          1 comment  ·  Flag idea as inappropriate…  ·  Admin →
        • Select the notifications I will receive

          Since signing into Trackvia 2.0 I have been receiving a notification each time someone else submits a request. How do I filter out the irrelevant notifications and choose which ones I want in my inbox?

          - Regular user (not an admin or power user)

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
          • API and Calculated text field

            Hi we have a table that has calcualated fields, we are importing data into the table via API but the calculated fields are not calculating? Does anyone have an easy fix

            1 vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
            • Share all pages in a view

              I have views that contain more that one page. When I try to share or print, only the first page is displayed. I need to be able to include all data in a view when sharing and printing.

              5 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                1 comment  ·  Flag idea as inappropriate…  ·  Admin →
              • 1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  planned  ·  1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
                • 1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
                  • Make the time range on a calendar view smaller

                    We have a calendar view where record are always no more than 90 minutes long, and they all start after 8 AM and end before 9 PM. On the calendar, when I select "Day" or "Week", all the records are bunched together in the middle, which does not make for easy reading. Would it be possible to set a timeframe so that the Day and Week views would start at 8 AM and end at 9 PM, for example?

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      1 comment  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
                    • Invisible Characters in Link-To-Parent Fields??

                      Is there any invisible characters in an unpopulated Link-To-Parent field?

                      I am attempting to use Show/Hide Rules to only display this field is it is blank (or populated), but it appears there is something in a blank field that the application is recognizing so not considering the field blank/null.

                      Example: if(isblank({LTP Field}, 1, 0) is returning 0.

                      Is there another formula to find visibly blank fields? I even tried if({LTP Field} = null, and the same results.

                      1 vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  table relationships  ·  Flag idea as inappropriate…  ·  Admin →
                      • See ALL active notifications in ONE place.

                        I would find it extremely helpful to have the ability to see ALL active notifications in one place.
                        I imagine a notifications tab/page categorized by tables, that shows all underlying views with active notifications -each view having the ability to expand and show all associated notifications, and each notification having the ability to expand and show all users receiving that notification.

                        3 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • Can we copy formulas when we create new tables?

                          We utilize TrackVia for research and the copy table function was very useful in Classic because we could choose to copy formulas and they'd all come over without data. Is there a work around. Is this in the mix for an improvement?

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
                          • Issues with tablets - App Update or Mobile Compatibility of Website

                            We are utilizing iPads and Samsung tablets in the field with the TrackVia app. The app does not allow filtering within views like the desktop site. So in some instances we are having to log into TrackVia through Chrome on the tablet. When we do this there is no scrolling through a view. It is very annoying and limiting the amount of information our people can readily access.

                            Either the scroll issue on tablets needs to be addressed or filtering added to the app. Both would be optimal, but one or the other to remedy the lack of access to…

                            3 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              2 comments  ·  mobile  ·  Flag idea as inappropriate…  ·  Admin →
                            • Use location as a Table ID or pull address from location field and put into a separate field

                              When creating a record in my table, I use the location field (from google maps). I am not able to use Location as table ID. A possible work around would be to create a separate address field and populate it with the address from the location field. However, I am having trouble doing this.

                              4 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                4 comments  ·  table relationships  ·  Flag idea as inappropriate…  ·  Admin →
                              • Sending/sharing/emailing a record or scheduled report as an attachment

                                Hello,

                                I work for a healthcare organization. One of our departments uses TrackVia on a near daily basis. We have very recently upgraded from the classic version to the Enterprise+ version.

                                Is there any way that we can use the "Share Record" feature, but instead of TrackVia printing out the data in the body of the email (the users have told me this can't be done for HIPAA reasons), the data can be sent as an attachment? Either a Word document or .csv or Excel spreadsheet is fine; it's just for our purposes, we cannot have the data printed out…

                                2 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
                                • Implement a Refresh Token for View URL?

                                  The information regarding RESTful API at:
                                  https://developer.trackvia.com/tutorials/hello-world
                                  does not discuss how to use "refresh_tokens".
                                  I want to know how to implement the refresh token for the sake of acquiring a View ID URL that does not expire.
                                  Please help.

                                  3 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    2 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • 1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        4 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • expand view

                                        How do you set a view to open expanded?

                                        7 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          4 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Save my customization of Views & Dashboards?

                                          Hello...

                                          Whenever I customize any view (e.g., resizing or moving columns)...that customization IS NOT automatically saved (as the help files suggest it is supposed to be). Next time I come back to that view, it has reverted back to default. Really need to have this problem rectified, as it is really slowing me down.

                                          thanx,

                                          Mark Forman

                                          1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            1 comment  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 11 12
                                          • Don't see your idea?

                                          How-to questions

                                          Feedback and Knowledge Base