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. Make the text "BOLD"? I have a "Notes" field I would like to bold some or all of the text.

    I am building a Contact Management System. I have a comments and Notes field. I would like to bold certain text. How do I do that? Thanks, Lisa

    1 vote
    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 →
  2. Is there a similar feature in Trackvia Express as the document merge function in Trackvia Classic?

    I currently use the document merge function in Trackvia Classic for exporting to MS Word templates and am looking for similar functionality in Express.

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  3. Returning Value based on date being between two dates

    I am trying to produce a formula to calculating carbon emissions factors.

    When inputting a new meter record I need the date to return a value if it is between two dates.

    I then need that value to be multiplied by the new meter value.
    For this to work I presume I am going to need to set up another table with all of the dates and values I want to be returned. But how do I lay the table out?
    Do I do a start date and end date? Month on Month?

    Really need some help on the formula…

    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 →
  4. why are my app dashboard barcharts different to my actual dashboard barcharts?

    I've created various status barchart views for one of my apps on my computer and added to a dashboard. On the computer they look great. When I view them on my ipad most of the funtionality has been removed and they don;t match what I see on my computer.

    Is tehr a reason for this?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  dashboards  ·  Flag idea as inappropriate…  ·  Admin →
  5. Max Function and Dates

    I have a max function that returns the "highest", or most recent, date. However, what gets returned is the max date minus 1 day.

    For example, the highest date is 4/20/2014. But 4/19/2014 is returned.

    Is this a bug? Or how can I fix it?

    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 →
  6. create a template for exporting a record as a PDF / word document?

    I'd like to create quote / order documents for a CRM application

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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 →
  8. 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 →
  9. Your videos are for experienced programers. I CANNOT see what they are clicking from or to so as a newbie the videos are useless!

    Your videos are for experienced programers. I CANNOT see what they are clicking from or to so as a newbie the videos are useless

    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 →
  10. 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 →
  11. get rid of an unwanted comma before calculated text

    We have two tables - one for assets and another a check out log
    To get the current location with we have two formulas for calculated text

    Check out log
    if(isblank({Checked In Date}), {LOCATION}, "")

    Assets
    if(sum({Checkout Log}.{Asset (Checkout)}.{Currently Checked Out})>"0",childconcatenate({Checkout Log}.{Asset (Checkout)}.{CURRENT LOCATION} , ","),{HOME LOCATION})

    They work fine except a comma is appearing the box before the location. How do we get rid?

    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 →
  12. 4 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 →
  13. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. Set starting number for auto counter?

    I have an existing auto incremented ID in my data, how do I set the starting point for an auto incremented field?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  15. Retrieve Value from Grand-Parent Table?

    Is it possible to retrieve the value from a field in a grand-parent table?

    I've tried modifying the format of retrieving from a parent field by adding additional "connectors", but not getting it to work.

    Sample:
    {Table Name}.{Relationship Name}.{Relationship Name}.{Field Name}, or
    {Table Name}.{Relationship Name}.{Table Name}.{Relationship Name}.{Field Name}

    I could "step" the values down one level at a time, but thought it would be easier to go straight to the source.

    Thanks

    10 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  table relationships  ·  Flag idea as inappropriate…  ·  Admin →
  16. Integrate my trackvia data into my website !

    I have thousand users in my site,if they want access this information without have credentials of trackvia and also they have download this data is it possible using trackvia ?

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  3 comments  ·  permissions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Changing the Font Color for Field Values

    Is there a way of changing the font color for field values?

    We can change the form background and label colors, but not the color of the field values which remain black.

    This makes is difficult to read on darker background colors.

    http://help.trackvia.com/knowledgebase/articles/243463-how-to-create-a-form

    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 →
  18. Text editing questions

    Hi, I was working on editing tables.
    1. How can I realize text wrap( turn to next line) functionality in concatenate functionality?
    2. Other than the logic formula"if", do we have a "ifnot" together with it?

    Thanks!

    1 vote
    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 →
  19. How to Return a 2-Digit Value for Date Formula "Month(date)" and "Day(date)"

    Using the month() and day() formula result in a single digit number returning. eg: January = 1.

    Is there a way to have a 2 digit value return for all?
    eg: January=01

    I'm trying to get a result of: 2014-01-15

    concatenate(year({Month Ending}),"-",month({Month Ending}),"-",day({Month Ending}))

    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 →
  20. Super Admin vs. Admin ?

    Hi,

    I'm looking for confimation in my understanding of Admin user permissions.

    There are two (2) Admin permissions in the system: Super-Admin and Admin.

    My understanding is:


    • Super Admin is the See Everything/Do Everything account level permissions that over-ride any application level permissions granted. This is set on the users account.


    • Application Admin gives all access (read/write/delete etc) for everything within in the specific application ONLY (not outside of this application). This permission is set within the Role the user is assigned to. Question: If the Super-Admin specifies the View for a table which does not show all records/fields, will…

    0 votes
    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 →
  • Don't see your idea?

Feedback and Knowledge Base