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. 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 →
  2. 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 →
  3. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  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. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 1 vote
    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 →
  16. 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 →
  17. Change colors in charts?

    Is there a way to change color of bars in charts?

    8 votes
    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 →
  18. Calculated Link field to allow custom action on each row

    It seems that in TrackVia we can not add custom actions on each row like in Zoho creator.
    For example, jump to LinkedIn profile of a contact, based on its name and forname stored in TrackVia table.

    An easy way to achieve this could be to create a new type of calculated field: Calculated Link

    By this way, we could extend the action functionalities of TrackVia on each row,

    image: trying to calculate a link base on forname and Calculated Text Field (without success :-)

    5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  19. 4 votes
    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 →
  20. Use Regular Expression in Contains() or Snip()

    It would be really great to be able to match a pattern of text with regular expression in contains() and snip()

    For example, If I have a URL http://www.google.com/account/gmail/532905jfkdsa and http://www.google.com/account/maps/5723utiregmailfjdk

    If you use IF(contains("gmail",{url}),"Gmail","other")

    It will return gmail for both because both contain gmail even though I am only looking for /account/gmail.

    If I wanted to just find the account number (in this example) I could use something like /(\d+\w+)/g

    1 vote
    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 →
1 2 6 8 10 13 14
  • Don't see your idea?

Feedback and Knowledge Base