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. Calculating Task Completion Time

    I am looking for a way to capture how long it takes a user to create a record.
    Does TrackVia stamp when a Form is opened? If so, then I can use this value in a datedif formula against the record Create Date/Time to see how long it took to open the form, key in the information, and click Save.

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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?

    6 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. Forms, Default Forms and Child Tables

    When I click on a record and the view is set to the default view, the option to select one of the related child records appears below the form. When I create new form and change it as the preferred Form in roles the child records no longer appear below the form. How can I get the child info to appear when not using the default form?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Months in order

    I am grouping milestone activities with dates into months. On the chart, the months aren't in order. Is there a way to create the chart with the months in order?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  5. Membership/client based website where they need to have notification details of what was done to their account

    Hello we are making a member/client based website where they need to have notification details of what was done to their account sent to them via email etc. when there is account activity made by an admin. Can Trackvia do this, is it the right type of solution?
    Also can the member get notified that we are working on their account.
    Can they also get reports?
    If not, can this be done with Hooks or APIs?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. Auotnumber and Text in calculated text

    Can anyone please explain why this calculated text field formula works when Historic Order Number has a value but not when it's blank. I'm guessing it's something to do with the fact that Historic Order number is a text field whereas Order Number is an autonumber, however I can't find a to string function.

    IF({Factory}="Toplink", "TLKNZ", IF({Factory}="Playmore", "PKNZ", IF({Factory}="Colaro", "CKNZ", IF({Factory}="Vithal", "VKNZ", "")))) & IF({Historic Order Number}="", {Order Number}, {Historic Order Number})

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  7. Required Fields

    If I add a field to a form that is from the parent record, such as a name, how do I mark it as a required field? I only see this option when creating tables.

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow calculated form fields value to be selected/copied

    Unable to select (or copy) values from Calculated Text fields

    The html fields used to display these fields are <textarea> and marked as "disabled". This is preventing me from selecting the text and copying the values (to be pasted in another application/process).

    A few ideas are to:
    1.) Display the text as inline text (no textarea field)
    2.) Use non-disabled textarea's, but override javascript to prevent changing of the text
    3.) Give a copy button to copy text to clipboard (link bit.ly, Box, etc.)

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
  9. Is there a way to add a new dashboard to all roles?

    When I create a new dashboard I often want to assign it to all roles. It's a bit tedious to assign it to each role individually. Is there a way to just assign to all roles?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
  10. Calculating Duration of Time

    Is there a way to calculate Time, (not Base-10 numbers)?

    I have a user who tracks Total Run Time (TRT) for TV Programming, and we need to sum/add the durations of multiple TRT's in the format of HH:MM:SS (Base 60).

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  11. application user nick name

    The application user field gives you a list of the user's name AND email, which is cluttered when there are several users in the list.

    I would like to be able to rename to exclude the email address or create nick names for the users. Is this possible?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
  12. Create a Message Board

    Is there anyway to create a message board on an app? Like a discussion board for a project?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  app building  ·  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  ·  Flag idea as inappropriate…  ·  Admin →
  14. Combine the drop down menu and single line text?

    I have 6 options that I need in a drop down menu. I would like to include an "other" option as well. If my users select that choice, they will need to input their own selection. Is there anyway to do this?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  15. Sometimes the chart icon does not show up when I'm creating a view.

    Sometimes the chart icon is available and sometimes it isn't. Any ideas why?

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

    I noticed that single application administrators have access to the TrackVia API.

    I would like to see access to the API access raised up to the Account Authority only.

    The reason, is that the Account Authority is will have the knowledge for the TrackVia account, the pricing plan, and any limitations the pricing plan has with the API.

    An App Admin may not have this information on the subscription, plan, or invoicing, and may exceed the subscription limits. Only the Account Authority should be the approver for anything relating to account expenses.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  permissions  ·  Flag idea as inappropriate…  ·  Admin →
  17. How have you printed barcodes?

    I can only see barcodes when I'm on the mobile app. Is there a way to generate barcodes for inventory items and print though from TV?

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Day of the Year

    Is there a formula to calculate the day of the year?
    Example: Today, 3/18/2015 is the 77th day of 2015.

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  19. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
  20. How do I use the new "Lanes" view function?

    There was an announcement about it launching on Feb 20th, but I don't seem to see the option in any of my views.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base