John McGarvey

My feedback

  1. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  How-to questions » other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    John McGarvey commented  · 

    Adding to this request with a slight change.

    I have created own User table so I can add attributes that are not available in the system's User table, plus being able to have names displayed in the format I want, such as:

    Smith, John instead of John Smith<johnsmith@emailaddress.com>

    I am slowly moving all my tables to reference my custom User table when there is a need for a user field, so the drop-down:
    1) Displays alphabetically by last name
    2) Much cleaner look in the application
    3) Filtered lookup view with no displayed inactive accounts (my User table has a status flag)

    Each record in my User table has the system Application User field populated with the system user account so I can use it for filtering for "currently logged in user", etc. All I have to do is set the filter up to the parent table instead of the local table.

    What I would like to do is have an Apps Script populate my LTP field to my custom User table using the format of the name I have as the Record ID.

    Is it possible for a script to:
    1) Grab the currently logged in user's account
    2) Go to the parent table and look for the Application User field on the record (which is not the Record ID)
    3) Associated the system user account to the Record ID of my table
    4) Populate the child table with the format from my parent table's Record ID for the currently logged in user.

    I know the above if pretty wordy, but wanted to be clear on what i am looking for.

    Thanks,
    John

    John McGarvey shared this idea  · 
  2. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    John McGarvey commented  · 

    I like this idea, but it can be done today with a bit of work.

    1. Create a calculated field to check if the field to be hidden is populated or not. I use a calculated number field: If(isblank(FIeld To Hide), 1, 0).

    2. Create a new Field Section on your form and add the calculated field.

    3. Set a Show/Hide rule to hide this section. I use the auto number field, and only show this section if the the auto number is less than 0, which will never happen.

    4. Set the Show/Hide rule for the field you want to hide, using the calculated field in the new section as your measurement. If the calculated field = 1, Hide, else Show.

  3. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    John McGarvey commented  · 

    Discovered today that calculated fields on a View sent via Scheduled Reports have a top vertical alignment, while all other (user-entered) fields are center aligned vertically.

    An error occurred while saving the comment
    John McGarvey commented  · 

    Yes!
    I don't have any votes left, so just adding a comment on this post.

  4. 3 votes
    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 →
    An error occurred while saving the comment
    John McGarvey commented  · 

    I don't know if this would help or not (I haven't tried it), but there is a padding function that you can use to add whatever character you want to the left or right of the value in the field.

    If all your lot numbers will never exceed a certain number of characters, you can set a padding of 5 to preface the lot number with whatever you want.

    If using "0" to pad, Lot 100 becomes 00100. Lot H1 becomes 000H1.

    This looks to be the same thing you are doing with your If statement, so not sure if this helps or not.

    Formula:
    lpad({Field A}, N, "Character for padding")

  5. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    John McGarvey shared this idea  · 
  6. 0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  General Discussion  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    John McGarvey commented  · 

    Awesome - sounds pretty complex.

    An error occurred while saving the comment
    John McGarvey commented  · 

    HI Matt,
    This is just an idea of how I would approach this. I've never created a time card system, so I'm just taking a stab in the dark.

    From your timecard app/table, create a parent table of employees that would be filling out timecards. On the parent table, you can add a number field to be populated with the minutes a persons shift starts.

    Example:
    If they start at the hour, enter 00.
    If they start at the half hour, enter 30.

    From the (child) timecard table, you can add some type of calculated field to snip out the minutes of the date/time field (scheduled start time) and compare with the value entered in their parent profile record.

    If they are scheduled to start at the hour (00), and their timecard has :11, then you know they showed up late - of course a data/time fields is not system driven so any value could be entered.

    Also, on the parent table add an Application User field and populate with the employees TrackVia account. With this, you can add a filter "where user is currently logged in" so only the employee (and admins) can see it.

  7. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  How-to questions » filters  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    John McGarvey commented  · 

    When I have complicated conditions that the Filters cannot handle, I will create a calculated field on the table and write on the conditions in a large If/Then statement.

    A 1 or 0 works well to represent Yes/No, and also allows me to dual purpose the results in charts if I want to sum the values.

    Once the calculated field is in place, use that in your Filter.
    One filter criteris: Where calc-field = 1, etc.

  8. 0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    An error occurred while saving the comment
    John McGarvey commented  · 

    It would temporarily.
    Export all the values from the text field, and re-import into the paragraph field. Update any Views/Filters to use the paragraph field instead.
    Once everything is using the paragraph field, then delete the old text field.
    You will be left with the same number of fields, and a lot more space available.

    An error occurred while saving the comment
    John McGarvey commented  · 

    There is a paragraph field that can be used for larger amounts of text.
    I like the idea of html formatting.

  9. 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 →
    An error occurred while saving the comment
    John McGarvey commented  · 

    Hi Sam,

    There is a date function just for this.
    Hope this is what you are looking for.
    John
    ---

    weekdays()
    This function returns the number of weekdays spanned by date1 and date2, including both date1 and date2.

    weekdays({Date Field 1}, {Date Field 2})

    Note: If using this function alone, you would insert the function into a calculated text or calculated number field type. Because it returns a whole number, it will not be accepted into a date field type.

  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 » user management  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    John McGarvey commented  · 

    Alphabetically by last name, preferred.

  11. 19 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    6 comments  ·  I would like to see...  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    John McGarvey commented  · 

    I would like to add that cell padding is too much and should be reduced to remove the wasted spaced around all the fields and headers.

  12. 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 →
    An error occurred while saving the comment
    John McGarvey commented  · 

    This feature was recently implemented with a link on the Table Relationship page.

  13. 3 votes
    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... » add new feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 
  14. 4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  How-to questions » forms  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey supported this idea  · 
  15. 2 votes
    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... » add new feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 
  16. 0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  I would like to see... » add new feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 
  17. 3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  I would like to see... » add new feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 
  18. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  I would like to see...  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    John McGarvey commented  · 

    Password Policies were implemented a few weeks ago.
    This item can be marked as Completed.

  19. 0 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  I would like to see... » add new feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 
  20. 0 votes
    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... » add new feature  ·  Flag idea as inappropriate…  ·  Admin →
    John McGarvey shared this idea  · 

Feedback and Knowledge Base