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. 'unlock' a calculated field?

    I have a date calculate field that needs to be manually changed every now and then, maybe 1 in 10 records don't follow the pattern and need a custom date.

    I used the term 'unlock' because there is a small padlock in the top right corner of the box (image attached if you don't know what I'm talking about) so I am hoping there is a way to 'unlock' the field so that I can manually change the date.

    If you need anymore information let me know.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  3. print a dashboard

    I am new to TrakVia and have enjoyed using it for our application, but I have a superb dashboard, which I would like to send to all executives every 15 days, but seems there is currenly no way to print dashboard. I have to print each view individually, which is time consuming. Wish we can print from Dashboard and further if I can automate it to send it out to people with email address (non track via users) every 15 days, that would be fantastic!!

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  dashboards  ·  Flag idea as inappropriate…  ·  Admin →
  4. Make a field required based on another field on the same form

    Say I have one drop down field with A, B and C. Depending on which the user chooses, I want to make different fields required on the same form.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  5. autogenerate a record in a parent table using the latest value introduced on the child table?

    I have different prices per product and I want that on the product table the final price would be the lastest price introduce in the price table )child to product)

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  6. Share all pages in a view

    I have views that contain more that one page. When I try to share or print, only the first page is displayed. I need to be able to include all data in a view when sharing and printing.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  8. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
  10. Export a view with grouped data as it shows in TV instead of exporting as each individual record?

    When creating views that group store records by region, they show at the region level in TV, but export as individual records under highlighted rows for each region but aren't summed so I then have to go into excel and re-sum each section. Is there a way to get a View to export at just the grouped level? I really don't want to create a new table just to make this happen.

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  11. How do I create a field mask for phone numbers?

    How do I create a field mask for phone numbers? i.e. (xxx) xxx-xxxx

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  14. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  15. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
  17. Can i create a custom form that adds multiple records to a table?

    I am look at building an inventory app which has a custom form which has a single field for "To", "From" and "when" but adds multiple records for each part type that is recieved.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  18. can i trace mobile number

    I would like to trace mobile number and to know if annoying person is using any apps

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  mobile  ·  Flag idea as inappropriate…  ·  Admin →
  19. Can I limit the available options in a form field based on a user/user with criteria?

    Can I create a user database containing country assignments for each user, then have a form field for another table have its dropdown options be dependent on the user filling the form in? Pretty much is a there a way to do a calculated field/calculated dropdown based on the user filling the form in?

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  20. How do I set up an email alert in the future?

    Can I set an email reminder for 1 week from today? Or, an email reminder on the designated date of a future task (record)?
    Thanks.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base