How-to questions

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

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Reset an Auto Counter?

    Is it possible to completely reset the auto counter for a table?
    I have tried deleting a current one & creating a new one, but the numbers don't reset.
    I know that I can "reset" it by re-creating the same table, but I'd like to avoid that.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  2. bulk

    Bulk Editing, any updates on fixing this bug? It's getting beyond a joke now and I've been asked to explore options for an alternative to your system because it's still not been fixed.

    It's actually quicker to export a table to Excel and re-import with changes, which completely defeats the point of the whole system.

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  3. export document field

    Is there a way to download all of the documents for a table? An export gives me an excel file and one of the columns in that is the name of the document in that field but I need a way to get all of the actual files. Is that possible or do I have to go through one by one and download them?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  5. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  6. How do I set up alerts, if possible, to my email account?

    Every time, someone enters a new order to be shipped, it would give you an email notification, that way you wouldn't miss RUSH/OVERNIGHT shipments

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  7. Apps Script

    I'm looking for an Apps Script to auto-populate a User Field (Requester) with the name of the currently logged in user - the one creating the record.

    I've followed the sample in the Dev Apps Scripts page (below), but the field is not populating.
    The scripts is saving with no errors, and I've tried both Before Insert and After Insert. I want the name to display before saving the record so the user will have one less field to click on (unless they want to change the name).

    How do I change a value in the current record ?
    currentValues["Status"]…

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  8. automated recurring "share view"

    I love the new "share view" feature and find it very useful. It would be even more useful if I could set up a view to be automatically sent to a set of emails on a recurring basis. Can this be done?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  10. Use TrackVia for contract management

    What solutions can TrackVia provide for managing multiple government contracts (with multiple modifications and expiration dates each)? Goal = listing basic contract data and alerts when contracts are about to expire.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  11. Track Via Capabilities. A little confused.

    The one thing that would make TrackVia near perfect for our business would be the ability to easily customize the list for export based on factors.

    For instance, we have mailing to go out and we want to target a certain market, number range etc. we can just pick each database row and customize the export parameters.

    ie. Mail to A-J last names on our list, in Phoenix and Scottsdale, unit counts 50-250 who haven't been contacted in 4 months. (all current categories tracked in TV) Just easily go in create the list and export it.

    Would this program be…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  13. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  14. Is there a way to scan the data for duplicate entries?

    I have to import some new contact lists where some of the customers may already be in the system and dont want to double up.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  15. How to RESTfully add a record that references a record in another table?

    I am developing an interface from a C# web application to TrackVia that will maintain [Work Orders] and [Work Order Line Items] in lock-step with our web application's SupplyRequest and SupplyRequestItem tables. We will use your REST API to perform CRUD transactions. The [Work Order] view includes foreign keys to the Locations table. The [Work Order Line Items] view includes foreign keys to the [Work Orders] and [SKUs] tables. Can you point me to an example of how to insert and update records that include foreign keys? I'm guessing that we need to specify the integer record ids of the…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  16. delete

    I want to delete all my data and start from scratch.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  17. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  18. In table view, why does my table automatically and slowly scroll to the left when I select a field?

    In table view, why does my table automatically and slowly scroll to the left when I select a field?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  19. export my TrackVia database from my old website to a new WordPress website

    Exporting TrackVia databse into new WordPress website?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base