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. Set Today's date

    I know there is a function now() to put todays date but that will put the same date in the whole column.There is a date field in my table, what I want to do is to make the date in the form automatic so the user don't need to input the date every time whenever they make a new record.
    Is there any option to do that?
    Thanks

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. Is there a way to scan the data for duplicate entries?

    I have to import some new contact lists where some of the customers may already be in the system and dont want to double up.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 comments  ·  other  ·  Flag idea as inappropriate…  ·  Admin →
  3. 0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Flag idea as inappropriate…  ·  Admin →
  4. Date & Time Field - Only 30 Minute Increments

    The Date & Time field only allows values in 30 minute increments.
    There is no other field to track the time of the day.

    How do you enter a time different than the 30 min increments, like 12:05pm?

    0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
  5. upload and download images?

    I would like to upload files/images to tables from an android app? I am new to Trackvia, so can you tell me is it possible? If so can you direct me to the proper documentation.

    Greatly appreciate any help.

    Many thanks in advance.

    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 →
  6. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  7. Is there a way to modify existing values of a drop-down list?

    It looks that the only way to modify is to delete the old one and create a new value option.

    0 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. Avoid time while Concatenate multiple fields with Date field in it

    I'm trying to concatenate three fields, where one is Date field. but when I concatenate the date field,it is adding time with it.why is it happening?I just want to add date only. the Field is also Date not Date and Time.

    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 →
  9. Restrict data input by using a validation rule

    Hello, can be used in TrackVia data input restriction rules, e.g to be not able to set in some Date/Time field, Date/Time value which for instance is in the past.

    Thanks

    1 vote
    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 →
  10. Copy/share a list of dropdowns in a table?

    In my database application, one table, I have 3 columns which are calling for states, because there is a project state, there is an address of the engineer and there is an address for the owner. Currently, I have to go in and manually enter the dropdown for each columns as 50 states in US plus all Canadian province. If there was a feature to copy or share the list choices in the table, or among different tables, it would be greatly useful. Also for standard fields like US states, if it was a pre created dropdown, I could use,…

    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 →
  11. display Notification to another user

    I want to show notification after adding a new entry in the view..I know how to do that if the user whom I want to notify is already added in the Trackvia...how about he is not been added?how to give the notification in that case?

    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. IS IT POSSIBLE TO COMBINE A NUMERIC FIELD AND A TEXT FIELD INTO A SINGLE CALCULATED FIELD

    HAVE AN AUTOMATED NUMBER FIELD WITH A UNIQUE NUMBER FOR EACH RECORD, AND ANOTHER TEXT FIELD FOR LAST NAME. COMBINE THE TWO INTO ONE RECORD ID FIELD THAT CONTAINS THE NUMBER AND THE LAST NAME FOR EASIER IDENTIFICATION. I AM NEW TO THIS AND DID NOT SEE ANYTHING EXPLAINING WHETHER THIS COULD BE DONE IN THE KNOWLEDGEBASE

    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 →
  13. Show all tabs at the top of the App?

    When I am in an App, I can only see four (4) tabs that each show me a view. But we have nine (9) views and I have to click the "More" tab to select the others. Is there a way to show all tabs?

    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 →
  14. 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 →
  15. How To Convert A Chart Back to Table?

    I have a Chart that I need to return back to Table view so the Format tab returns back to the sort order of the fields (to modify the order of fields in the Notification Rule).

    I cannot find the option to do this once the Chart has been saved.

    2 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 →
  16. delete bulk items

    You are no longer able to delete entries in the views or dashboard. It comes up with an error.

    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 →
  17. 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 →
  18. remove duplicate data after import excel file

    when I try to import a field in single line it import all the data from Excel which include duplicate data as well.How can I remove those duplicate that from table?

    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 →
  19. change the table Field Format but keeping old record data

    I have a table importing from an Excel file. Now I want to change the format for it,for example before the input format was single line now I change it into dropdown and change the choice in dropdown that was before to remove unwanted data ,if I do so it eventually remove all old data but I wanna keep the old data at the same time add the new data from the updated dropdown choice in the same field. Can I do that?

    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 →
  20. How do I cancel my subscription?

    I want to cancel my account, but the website doesn't offer that capability and no one is answering the phone.

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

Feedback and Knowledge Base