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. 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.

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      2 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…

      1 vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        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
          I agree to the terms of service
          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
            I agree to the terms of service
            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
              I agree to the terms of service
              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
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                2 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
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
                • 1 vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
                  • Change a record field from "required" to "not required" without losing data

                    We have a field on an existing record which is no longer required.

                    However, we want to keep the field, and the existing data intact.

                    If we edit the record, uncheck the field's "required" box, and then save the record, Will we retain the existing data?

                    The goal is to be able to remove the previous contents of the field, and not be required to enter it for new data going forward.

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      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
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
                      • see my gantt chart on phone app?

                        When I view my chart on mobile device it appears as grid view instead of chart...

                        3 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  mobile  ·  Flag idea as inappropriate…  ·  Admin →
                        • Distinguish text from number

                          We track houses being built and need to enter lot number to generate lot IDs. sometimes these lot number have letters in them like lot 3A & lot 3B for a duplex. the field is currently a string and not number for this reason.

                          the issues come to sorting. since it is a string field the houses show up with lot 1, lot 10, lot 100 before lot 2 because of how numbers are treated alphabetically.

                          i fixed this with the code below:
                          if({Lot Number}<10,concatenate("000",{Lot Number}),if({Lot Number}<100,concatenate("00",{Lot Number}),if({Lot Number}<1000,concatenate("0",{Lot Number}),{Lot Number})))))

                          it makes lot 1 lot 0001 so that we…

                          3 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                          • Use the edit and view choices for a flow task?

                            I'm not sure how to use the edit and view options with the new Flow feature.

                            How do I edit an existing record? I tried using the variables but that just seems to create a new record with the same record ID.

                            As for the view option, maybe I just don't understand the point of it. Could you provide some examples of what you would use the view choice for, within a flow? Also when you are at the view step, you have to click into a record to move to the next step, but there doesn't seem to be…

                            0 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
                            • Show a calculated date only using WEEK days

                              Show a calculated date only using week days, so two days from Thursday would show the Monday's date, so today is Thursday the 13th July 2017, I want to show the calculation of two additional week days, so present Monday 17th July 2017

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
                              • Set up a multiple layered conditional filters?

                                Hello everyone,

                                I would like to know if there is a way to set up a filter where there are 3 layers of condition filters. At the moment I can only seem to manage to have a two layer filter. I am not sure how to explain it so I hope everyone understands what I mean.

                                Thank you.

                                3 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  4 comments  ·  filters  ·  Flag idea as inappropriate…  ·  Admin →
                                • Import an address into "Location" field?

                                  I have received errors on my attempt to import locations: "Invalid POINT value". I have old data with addresses that I would like to tie to the location field....how do I do this?

                                  3 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Saving a new record - default form fails to load

                                    I have created a form for users to enter new records into a table. The form contains the specific fields they need to work with. I do not wish to grant the user access to the "default form" as there are fields in there I do not wish to grant them access. When a user enters a record and they hit save they are presented with a "permission denied" alert. The record does save.

                                    Best I can tell, trackvia always loads the "default form" after a new record is saved. Is this accurate? Is there any way to change this?

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      2 comments  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
                                    • auto-populate from parent table

                                      I have company to contact related tables. When someone creates a contact in a company, can I make the address fields in the contact table auto-populate with the data from the address fields in the parent company?

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        1 comment  ·  table relationships  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Alphabetize Dependent Drop down Choices

                                        I have set up a dependent drop down of Counties and Cities. When I pick a county the city choices are not alphabetized. Is there a way to make this happen?

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  table relationships  ·  Flag idea as inappropriate…  ·  Admin →
                                        • How do i search on a specific field in a view using the API?

                                          I need to search for a specific value in a field using the API. How would i accomplish that? what would the query string be?

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

                                          Feedback and Knowledge Base