# John McGarvey

## My feedback

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

Comments are not possible in calculated fields, but if you ever use Apps Scripts, a comment can be added with //.

2. ## Use TrackVia for contract management

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

Hi Lynn,

I created a database to track contract staffing (Statements Of Work) with all the elements you listed, plus tie-in's with Purchase Orders, Contractor's Profile record.

If there is something specific you are looking for, I'd be happy to help out.

John

3. ## How do I filter views based on business days?

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

This is possible by using the DAYOFWEEK function. There may be other ways of doing it, but this is how I just tested with.

This function returns the number of the week (1-7) for a given date. The weeks starts with Sunday as "1".

"Test Date" is the name of your date field.
I used a calculated number field incase you need/want to count the number of records due on a given date - you can sum the 1's together.

if(dayofweek({Test Date})=1, 0,
if(dayofweek({Test Date})=2, 1,
if(dayofweek({Test Date})=3, 1,
if(dayofweek({Test Date})=4, 1,
if(dayofweek({Test Date})=5, 1,
if(dayofweek({Test Date})=6, 1,
if(dayofweek({Test Date})=7, 0,
0)))))))

HERE IS THE DESCRIPTION FROM THE DATE FUNCTION IN THE KNOWLEDGEBASE:
Returns the number (1-7) that corresponds to the day of the week for a date field. Sunday is assigned the value of 1.
Use in a Calculated Text or Calculated Number field.

When {Date} is June 15, 2017, dayofweek({Date}) returns 5 (Thursday).
Gives the same result as weekday().

4. ## Allow Applicaton Scripts to run when Select All / Edit All used to update multiple records.

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

I've see the same with importing data - scripts don't run.

5. ## API and Calculated text field

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

I am not familiar with how the TrackVia API's work, but calculated fields should be calculating when data is added/updated.

I do know that Apps Scripts do not run during import and/or bulk updates, so perhaps this is the same scenario. For this, I've had to update each record separately to get the script to run.

You may want to load a default view (all records). The system is supposed to run any calculations each time a view is loaded, unless you are using Triggered Fields, in which case you are back to updating each record separately.

I'll be watching for replies on this as I am interested in this also.

6. ## Manage users like any other table

Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

I agree. I don't have any votes left to add to this post, but can say I ended up creating my own User table with all the functions listed. The user record on my new User table then links to the system user table via user field to maintain filters, etc.

7. ## Allow data entry offline

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

I don't think this is avaiable for laptops unless you have a Chromebook that supports Android apps.
The Release Notes indicates this feature is only available on the Android mobile app.

An error occurred while saving the comment
John McGarvey commented  ·

The off-line setting can be found in the user Role setup.
Here are the December Release Notes that discuss this:
http://help.trackvia.com/knowledgebase/articles/1830688-december-2017-release-notes-offline-editing-on-an

8. ## Share all pages in a view

Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
John McGarvey supported this idea  ·
9. ## Timeline improvements

Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

On my account, the Timeline does not work at all. The screen shows "No Records" even when records display on the Calendar.

A support ticket is already being worked for my issues. Must be something strange to work for some customers but not others.

10. ## Invisible Characters in Link-To-Parent Fields??

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
John McGarvey shared this idea  ·
11. ## Date Calculations in Apps Scripts

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

Hi Andrew,

This helped - it got me on the right path and is now working.
Thanks so much !

John McGarvey shared this idea  ·
12. ## Ability to Sort Charts (Bar) by Both X-Axis and Legend

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
John McGarvey shared this idea  ·
13. ## App Script Padding For Child Records Numbers

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

Thanks Alex - I'm just getting some time to look at this again.
I tested, but not seeing padded numbers - no errors, just nothing happening.

John McGarvey shared this idea  ·
14. ## My dashboards have a certain order on the top nav bar. How do I reorder them on the nav bar?

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

You are not able to drag the dashboards into a new position (up or down) within the Role setup page?

An error occurred while saving the comment
John McGarvey commented  ·

If you are an end-user, you won't be able to change the dashboards as they are set by the system administrator.

If you are a sys admin, you can edit the user Role(s) by dragging the dashboard to the order you want. After saving the Role, all members of this Role will see their dashboards in the order you set.

15. ## How do I troubleshoot users not being able to login using Chrome or Firefox?

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

I have found with my users that "not being able to log in" needs some clarification:

1. Can they reach the TrackVia login screen?
If no, this is not a TrackVia issue (especially if other users do reach the login page). I have a group of users in one of our facilities where the firewall is blocking access. It could be a internal IT network issue.

If so, if they are willing to share their password with you, you can try logging in as them. Or, you can try changing their account to one of your own email addresses, send the password reset email so you receive it, log in with their credentials. If you can log in, you know it is not an account issue. Change everything back to their own email.

2. Are they able to get past the login screen, but then receive a blank white page with a missing Application dropdown?
I have found this happens when the user set one of the applications as a favorite by setting the Star, then that application is deleted from the system, or their Role permissions have changed so they no longer have access to that application. The system is not "releasing" the favorite star when the application is deleted or permissions have changed and it is still trying to load the favorite app. The workaround is to use the Go To menu to search for anything. Click one of the results. Once the selected Go To item is shown, the Application menu will reappear and a new favorite can be selected.

4. Are they able to login, but then receive a "You Don't Have Permissions" error?
This is typically a default page trying to load with elements they do not have permissions for. Check all Views on the page and make sure those Views are in the user's Role.

Hope this helps.
John

16. ## Can Apps Scripts Populate Link-To-Parent Fields?

Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

Hi Alex,
Some clarification.

I am trying to populate a LTP field (not single line) via App Script at the same time the script is creating a child record. The child record is being created fine. The LTP is to a second parent table than the one that ran the script to create the child (this would already be auto-joined).

I tried following the format of other "drop-down" type fields (drop-downs, User fields, and User Groups) thinking the format would be the same, but I am not able to get the LTP field in the child record to populate.

There isn't any IF condition to evaluate as the will identify the actual value to enter into the field for each child record being created.

John McGarvey shared this idea  ·
17. ## Save my customization of Views & Dashboards?

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

Hi Mark,

If you are using the system default View, it will revert back every time.
If you are using a custom form, you need to open the View full screen and make the modifications. This will not work while embedded on a Form or Dashboard.

You will need to be a systems admin to perform the changes and to save them permanently.
If you are the admin, you should be good to go as long as you make the changes while in the full-screen View, otherwise contact your company's admin to make these changes.

John

18. ## Is there a childconcatenate formula with if? I want to add quantities in the child table only if they fit a criteria in another field

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

I don't believe there is an If condition from the parent because the childconcatenate looks at all child records as one group, and not individually,

But, you can add your If condition on the child table for each record, then use that new child conditional field to concatenate up to the parent.

Example child table:
If(Field 1) = condition, True Value, False Value)

Then, child concatenate the results of the new field.

19. ## Change a record field from "required" to "not required" without losing data

1 vote
Vote
(thinking…)
Signed in as (Sign out)
You have left! (?) (thinking…)
An error occurred while saving the comment
John McGarvey commented  ·

Removing the requirement on a field in the table setup will not remove the existing data.
But, you can always export the field along with the Record ID, and reimport just incase something goes wrong, but I've never lost my data by add/removing the requirement on a field.

Vote