John McGarvey

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  ·  How-to questions » formulas  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey commented  · 

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

  2. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  How-to questions » other  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  How-to questions » views & charts  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  I would like to see...  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey commented  · 

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

  5. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  How-to questions » formulas  ·  Flag idea as inappropriate…  ·  Admin →
    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. 13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    started  ·  1 comment  ·  I would like to see...  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  I would like to see...  ·  Flag idea as inappropriate…  ·  Admin →
    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.

    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. 5 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  How-to questions  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey supported this idea  · 
  9. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  How-to questions » table relationships  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 
  11. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  TrackVia API & App Scripts » App Script  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  I would like to see... » improve existing feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 
  13. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  TrackVia API & App Scripts » App Script  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  How-to questions  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey commented  · 

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

    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  How-to questions  ·  Flag idea as inappropriate…  ·  Admin →
    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.

    2. Are they receiving a username/password error?
    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. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  TrackVia API & App Scripts » App Script  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  How-to questions » user management  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  How-to questions » formulas  ·  Flag idea as inappropriate…  ·  Admin →
    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. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  How-to questions  ·  Flag idea as inappropriate…  ·  Admin →
    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.

  20. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    planned  ·  3 comments  ·  I would like to see... » improve existing feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey commented  · 

    Yes to this request, but also the shortcuts need to stay in their positions regardless of screensize.
    I expand my browser and all the buttons move around. Lock them in place.

← Previous 1 3 4 5

Feedback and Knowledge Base