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. 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 →
  2. Calculate Remaining Balance

    I have a view where I can see a client's Total Cost, Deposit they paid and their Remaining Balance (I have Balance set with the formula Total Cost - Deposit.) When a client wants to make a partial payment, how can I do that and have the Remaining Balance calculate that?

    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 →
  3. 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. 1 vote
    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 →
  5. Is there a maximum number of IF statements I can nest?

    I ask this because when I go to save the calculated field a dialog box appears stating: "We've had a minor problem. We can't tell if your request completed. Please click OK below to refresh your browser." Prior to this dialog box appearing, however, a string of text appears (stating: "Large tables usually save in under a minute. Feel free to leave this page, we'll let you know when this is saved") atop the whited out page as the calculated field is saved - see attachment "Problem with IF Statement."

    Also, once I paste the copied IF statement formula into…

    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. Is it possible to add comments when writing a long formula?

    In most languages you can add comments that does not affect the code or formula. Out of habit I tried to use ' but that didn't seem to work. Does trackvia allow for this kind of thing and if so what is the symbol or text?

    E.g.

    If({Field} = 1, A + B, A + C)

    'comments about above statement

    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 →
  7. 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 →
  8. How do I calculate the sum of a column so that I can then use that to determine the percentage of the total for a given value?

    For example I want to show the percentage of total sales by store, salesperson etc.
    Everything I have tried so far just returns 100% as it is only doing the calculation on a row by row basis rather than using the column total.

    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 →
  9. I need to copy an auto-generated numeric ID to a text field if a condition is met

    I have a checkbox in a table to deliniate a category: checked or not checked. If not checked, the record is an asset without a serial number. When not checked, I need TrackVia to copy the auto-generated numeric field (unique ID) for that record to a text field as a substitute for the serial number.

    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 →
  10. 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 →
  11. 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 →
2 Next →
  • Don't see your idea?

Feedback and Knowledge Base