In table view, why does my table automatically and slowly scroll to the left when I select a field?

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?

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?

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

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

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}))

With the Pro platform advising the end-user that their import is taking longer than expected, and allowing the import window to be closed, is it safe to start a second import on the new screen?

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!

Reading through the KB and Forums, I've been able to piece together how Record and Field level permissions work, and looking for confirmation.

To limit what a user sees, we need to:
1. Create a View which holds the Records and Fields the user is allowed to see.
2. Create a Role specific to that View
3. Add the User to that Role
4. Create a Form and pair with the View

This seems pretty cumbersome, so not sure if I'm understanding correctly (from: http://help.trackvia.com/forums/216889-how-to-questions/suggestions/5927293-limit-access-to-specific-fields-by-role)

User > Role > View/Form

Thanks !

I am trying to create a filter against a Date field to display all records prior to today, but I am only able to select a specific date from a pop-up calendar control.

How do I import data into a an existing table?

We have four of five different attributes we apply to our projects to group them by (e.g. IT/Digital/Engineering/Sustainment). I would like to create a pie chart that shows the percentage of projects per criteria. So we might have 30% "Engineering" projects vs. 40% "IT" projects. But I can only seem to create a pie chart based on fields with numbers. Is there any way to create a pie chart as I described?

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