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

What solutions can TrackVia provide for managing multiple government contracts (with multiple modifications and expiration dates each)? Goal = listing basic contract data and alerts when contracts are about to expire.

Users set "First Day" creating a new record.
I have it in my script: def fday = currentValues["First Day"]
Than I want to add for example 30 days and save this new date in a date field. (using script)

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.

We use TrackVia as a check register, and need a warning message that says "Are you sure you want to allow Sum of Balance value to change?"

We have a view that is shared with our contractor showing jobs completed today as well as jobs due tomorrow. We do not work on Saturday so Friday's view doesn't have anything due tomorrow. I set up and shared another view to show the jobs with a due date 3 days from now to help account for this issue on Fridays. Is there a way to combine both views by showing only the next "business" day?

I know that the search function is not case-sensitive, but uploading records to the database seems to be. We use email address as a unique identifier when uploading new info and will always end up with duplicate records when someone enters their email address differently than previous. For example, Ta305@gmail.com versus ta305@gmail.com would create a dupe.

Is there a toggle somewhere to tell the DB to ignore upper case?

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?

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.

Many of the users paste data in from Excel & other sources, frequently we get spaces, tabs, line feeds & other non-printables in the data fields. Can we simply disallow those characters without disturbing the users' process? Even if we end up impacting the users, is there any method to prevent this - or to "scrub" at export time?

Since signing into Trackvia 2.0 I have been receiving a notification each time someone else submits a request. How do I filter out the irrelevant notifications and choose which ones I want in my inbox?

- Regular user (not an admin or power user)

Hi we have a table that has calcualated fields, we are importing data into the table via API but the calculated fields are not calculating? Does anyone have an easy fix

It will remind me to think

We have a calendar view where record are always no more than 90 minutes long, and they all start after 8 AM and end before 9 PM. On the calendar, when I select "Day" or "Week", all the records are bunched together in the middle, which does not make for easy reading. Would it be possible to set a timeframe so that the Day and Week views would start at 8 AM and end at 9 PM, for example?

When creating a record in my table, I use the location field (from google maps). I am not able to use Location as table ID. A possible work around would be to create a separate address field and populate it with the address from the location field. However, I am having trouble doing this.

Is there any invisible characters in an unpopulated Link-To-Parent field?

I am attempting to use Show/Hide Rules to only display this field is it is blank (or populated), but it appears there is something in a blank field that the application is recognizing so not considering the field blank/null.

Example: if(isblank({LTP Field}, 1, 0) is returning 0.

Is there another formula to find visibly blank fields? I even tried if({LTP Field} = null, and the same results.

How do you set a view to open expanded?