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. 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…)
      0 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 value of a checkbox with app script?

            Is this possible? I've tried testing for null and empty string both with and without [ ] like you need around ['Yes'] when testing current value.

            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…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • can any one help me Calculate working week-days?

              I am trying to calculate the number of working week-days from two dates, at the moment it is giving me the full 7 days per week.

              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 →
              • British date format

                Please can someone tell me how to get a British date format on Track Via i.e. 30.03.2018 rather than 03.30.2018? It's driving me nuts!

                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 →
                • Apps Script 'Event' Explanation

                  Can anyone explain or direct me to a link of the explanation of what the different 'Event' types indicate, and when you would use them?

                  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  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
                  • Issues with Iphone 7 uploading files.

                    We are currently using the mobile app in andriod and Apple products. We have rolled this out across our company and have come across the following issue. On the iphone7 the person is prompted to upload from dropbox (they do not have an account with dropbox.) It should just prompt them to their gallery. I have attached a picture for reference. Its for only these 2 upload spaces. All others are prompted to a gallery or files.

                    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  ·  mobile  ·  Flag idea as inappropriate…  ·  Admin →
                    • Create public views? In classic TV I could create a view that was public to anyone with the link. Is that possible in new TV?

                      Can I create public views? In classic TV I could create a view that was public to anyone with the link. Is that possible in new TV?

                      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  ·  permissions  ·  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  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
                        • Sort field results in the x axis on a chart?

                          I have results from a table I would like to have a bell curve on, however I cannot figure out how to sort the results data without doing highest/lowest.

                          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 →
                          • Summary Form

                            I am trying to replicate a view from the old version to the newest version of Trackvia. I am not having much success. Attached is a photo old vs new. Old version is shown on the right. Old version allows me to see when weeks are not populated shows availability. ANy ideas how to set up to show in landscape form?

                            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  ·  views & charts  ·  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…)
                                0 comments  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
                              • How do I delete tables?

                                I would like to delete some of my tables but do not want to delete the whole app / all my data. Is there a way to do this?

                                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  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
                                • Count the number of child records with specific data in a field

                                  I have child records with "Available" as a field. I want to count the number of records that contain "Yes" in that field and ignore the rest.

                                  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  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
                                  • DELETE /openapi/views/123/records/all returns 401 unauthorized

                                    Hi,

                                    I want to delete all records by using the API /openapi/views/123/records/all. It returns 401 unauthorized error.

                                    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  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
                                    • DELETE /openapi/views/{viewId}/records/all returns 401 unauthorized

                                      Hi,

                                      I want to delete all records by using the API /openapi/views/{viewId}/records/all. It returns 401 unauthorized error.

                                      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  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Scripting: If currentValues[] is a Map, why does .values() give me an error?

                                        If currentValues["Total"] is a Map of name/value pairs why does assigning it to m1 and then calling m1.values() not return the value?

                                        e.g.
                                        def m1 = currentValues["Testing"]
                                        m1.values()

                                        How else can I reference the value in currentValues["Testing'] ?

                                        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…)
                                          2 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Scripting: How to use logger.info()

                                          Can anyone tell me how this works in the table scripting? I wanted to verify the value of a calculation but I can't get it return a variable, just a static value. Returning a variable always gives me an error even if the variable successfully writes to a field.

                                          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  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 10 11
                                          • Don't see your idea?

                                          Feedback and Knowledge Base