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. On my pie chart (or other graph), you can hover over a slice to see the qua

    On a pie chart (or other graph), you can hover over a slice to see the quantity and percentage for the "slice", but I would also like to see the TOTAL of all slices (maybe on cursor over or in the legend?).

    Currently, I create the graph view and a second view that counts the records to produce this information...it would be nice to have it all in one view.

    Thanks!!

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  2. Distinguish text from number

    We track houses being built and need to enter lot number to generate lot IDs. sometimes these lot number have letters in them like lot 3A & lot 3B for a duplex. the field is currently a string and not number for this reason.

    the issues come to sorting. since it is a string field the houses show up with lot 1, lot 10, lot 100 before lot 2 because of how numbers are treated alphabetically.

    i fixed this with the code below:
    if({Lot Number}<10,concatenate("000",{Lot Number}),if({Lot Number}<100,concatenate("00",{Lot Number}),if({Lot Number}<1000,concatenate("0",{Lot Number}),{Lot Number})))))

    it makes lot 1 lot 0001 so that we…

    3 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 →
  3. Add working days to a date

    We need the ability to add working days to a date, at the moment the only unit available is 'd' which includes weekends.
    Please note - i dont need to work out the number of working days between 2 dates, rather add working days to a start date, in order to determine the end one. Any ideas?

    3 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 →
  4. Add tool tips to views/fields

    Add tooltips to views/fields/flows.

    The text widget is kind of klunky. Tooltips would be a more elegant solution for fields, but would also be useful to explain the purpose of a view or flow before someone jumps into one.

    3 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 →
  5. 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 →
  6. know which users have viewed my record

    I have a table, which is for FAQ/Knowledge Base. I would like to know how many times a particular question has been viewed and maybe by who,? Is that possible in TrackVia currently?

    3 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 →
  7. Scan multiple barcodes within mobile app

    Is there a way to scan multiple barcodes either on record creation or searching for the record and then edit/save those records all together? Also, are there any other options for bulk editing records on the mobile application?

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  mobile  ·  Flag idea as inappropriate…  ·  Admin →
  8. Make fields smaller in record entry form

    Hi I'm a new user, building my first App. I want to create a specific layout for new record entry and existing record edits. Some text lines contain only a few characters so they should be small (to state the obvious). When I drag the field from the arrow on the bottom right, the field will not "shrink." I can make fields bigger, but not smaller. The layout I'm stuck with is not optimal for space and will make it hard for users to enter information since my database has many required fields.

    3 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 →
  9. Export (and import) forms configuration

    In our compagny, we are certified ISO 9001 so we have to handle change management.
    We already have a functionnal systems to manage changes. If we were able to export the configurations of the forms in trackvia, we woud complie with the norm.

    So any format for the export would be nice as long as we can :
    * import it on an existing form or a new one
    * export it from an existing form

    The best would be to have it in a human readable format like XML or JSON

    3 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 →
  10. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  11. Needs an array field that accepts any concatenated data

    Needs an array field that accepts any concatenated data, for use with zapier to export child records

    3 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 →
  12. regain access to dashboards and views

    My colleague and I recently lost access to viewing the various dashboards and views in our test trial app and an "error" keeps popping up whenever we try to access a page

    3 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 →
  13. Adding Multiple field in the form on option to add more

    I have a form to add multiple items with their price and some other common input for the items.In the current process I need to fill up all the information in the form for more than one item. Is there any way where I can open the field to add multiple item along the price at the same time with other common input? the item field need to be the text field so I cant add the check box here. The multiple item can be stored in separate line in the table but from user side it would be faster…

    3 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 →
  14. 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 →
  15. Scripting: If currentValues[] is a Map, why does .values() give me an error?

    If currentValues["Total"] is a Map of name/value pairs why does assigning it to m1 and then calling m1.values() not return the value?

    e.g.
    def m1 = currentValues["Testing"]
    m1.values()

    How else can I reference the value in currentValues["Testing'] ?

    3 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 →
  16. Import an address into "Location" field?

    I have received errors on my attempt to import locations: "Invalid POINT value". I have old data with addresses that I would like to tie to the location field....how do I do this?

    3 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 →
  17. Timestamped record changes

    Can I set up Trackvia to record changes in records (timestamp) and run reports to compare current data with the same data at different periods.

    e.g. Property was empty last week, now occupied. Want to run a report as at last week and as at today. The report would show data held in trackvia at an historic point in time.

    Occupancy Field might show NO at Dec 2016, YES at Jan 2016

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  18. Font sizes in Forms

    The knowledge base says "Next, if you wish to further customize your form, click the pencil icon in the upper right corner of any field or section. From here, you can edit the title, and the font and background colors. " But far as I can tell, there are not font style or size controls. Does this mean that I cannot change the size of the fonts in form fields? Seems like a really basic feature.

    2 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 →
  19. Create public views? In classic TV I could create a view that was public to anyone with the link. Is that possible in new TV?

    Can I create public views? In classic TV I could create a view that was public to anyone with the link. Is that possible in new TV?

    2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  permissions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Create a dashboard with pull down menu

    I have 4 tables (Clients, Projects, Notes, Tasks). I want to create one Dashboard that, from a pulldown menu, I select a client, and have the projects, notes, and tasks associated with it show up below it.

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

Feedback and Knowledge Base