Discussions

Expand all | Collapse all

Is it possible to log edits within a date field?

QuickBaseCoach Dev./Training05-31-2017 17:06

  • 1.  Is it possible to log edits within a date field?

    Posted 04-05-2016 02:22

    We have notifications set up when dates are changed, and have implemented a change request system whilst restricting access to change the date, however would like an easy view on the main table page of the dates changed, similar to our commentary which is a text field with log edits.



  • 2.  RE: Is it possible to log edits within a date field?

    Posted 04-05-2016 03:45
    Well one thing that you could try to set up a field called date log  which is a another text field set to log changes. And then using form rules set up a rule that says when the record is saved and the date field has changed change the date lock to the value in the field Date.

     But because this is based on form rules, that means it will not work in grid edit.


  • 3.  RE: Is it possible to log edits within a date field?

    Posted 04-05-2016 04:12
    We are moving more to custom forms, so that should not be too much of an issues.
    Sounds promising.
    Would the text log field, update with a user and date per normal?
    Having an additional field would allow filter in certain reports to just see the current, so that is also beneficial.
    Can you please advise what the fom rule would look like?


  • 4.  RE: Is it possible to log edits within a date field?

    Posted 04-05-2016 11:49
    The form rule would look like

    When the record is SAVED
    and the [Date field] has changed

    Action

    Chage the value of the field [[my text field set to log chnages] to the value in the field [Date field]

    And yes, a field set to log chnages, does always record who did the update and the date and optionally the time of day.


  • 5.  RE: Is it possible to log edits within a date field?

    Silver
    Contributor
    Posted 03-07-2017 00:16
    Mark, does this mean that logging is inly available on text fields? 


  • 6.  RE: Is it possible to log edits within a date field?

    Posted 03-07-2017 13:37
    You can log any field I suppose. It will get logged using a form rule into a text field, but you can write a number or date field into a text field.


  • 7.  RE: Is it possible to log edits within a date field?

    Top
    Contributor
    Posted 03-07-2017 04:06
    A more sure fire way to log data changes is through a Data Change table.  Then you just have a button to change the date.

    You also wont have to maintain a bunch of different forms with their form rules.

    By creating a date change record, you automatically keep track of who, and when.  You can add a bonus feature really easy as to the why.

    Long term this is the most efficient and cleanest way to track your date changes.

    I can explain in more detail how to set this up properly if needed.


  • 8.  RE: Is it possible to log edits within a date field?

    Posted 05-30-2017 21:23
    Hi Matthew, 
    I would like to learn in more detail how to set it up. 
    thanks for your help.
    Christina 


  • 9.  RE: Is it possible to log edits within a date field?

    Silver
    Contributor
    Posted 03-07-2017 04:16
    Thanks.  I am already using QB Actions.  Is this what you are referring to? 


  • 10.  RE: Is it possible to log edits within a date field?

    Top
    Contributor
    Posted 03-07-2017 04:36
    No,  I'm saying you can make a table called "Date Changes".  And use that to keep track of your changes, and who (and why if wanted)
    >
    Just one Field;
    "Date"

    A second field would be needed if you had a "Why"
    >
    Each 'Project' can have many date changes.
    >
    Summarize Max Record ID
    >
    Pass new max RID as lookup
    >
    Summarize Date where max RID = Record ID#

    Now you have your log of date changes with time stamps and record owner.

    Much cleaner and more scalable if you have multiple dates that need to change.  Also gives you much better reporting outputs.  (ie. How many times this date has changes, most frequent cause of Date changes, who makes the most changes, etc.)


  • 11.  RE: Is it possible to log edits within a date field?

    Silver
    Contributor
    Posted 03-07-2017 04:53
    Got it.   Thanks.  Yes I am using the same approach for summering some info.  So Understand the concept.  Thanks. 
     


  • 12.  RE: Is it possible to log edits within a date field?

    Posted 05-30-2017 21:15
    Hello Matthew,
     
    out of what you wrote above I am not able to reapply it. Could you please send me a more detailed description of how to set this up please.
    Just one Field;
    "Date"
    A second field would be needed if you had a "Why"
    >
    Each 'Project' can have many date changes.
    >
    Summarize Max Record ID
    >
    Pass new max RID as lookup
    >
    Summarize Date where max RID = Record ID#
    Now you have your log of date changes with time stamps and record owner.
    Thanks a lot,
    Christina


  • 13.  RE: Is it possible to log edits within a date field?

    Posted 05-30-2017 21:23
    Christine,

    Matthew is suggesting that you create a child table of dates and make your date updates there.  Then you will have a very clean audit trail of the date changes.

    Post back if you need help with that.


  • 14.  RE: Is it possible to log edits within a date field?

    Posted 05-31-2017 16:12
    Thanks to QuickBase webhooks it's now pretty easy to create history tables where you can log old record values.  Let's say you have a helpdesk Ticket table, you can create a TicketHistory table and use webhooks to create a new record whenever a Ticket is modified


  • 15.  RE: Is it possible to log edits within a date field?

    Posted 05-31-2017 17:00
    Good point,  it now that we have ACTIONS we can set up a log table that way, and not need to struggle though the Webhooks Syntax.  So using that method, you just update the date normally and the ACTION will do the logging.


  • 16.  RE: Is it possible to log edits within a date field?

    Posted 01-16-2019 21:10
    I am currently looking at a similar application where I want to track/log changes to a date field. I understand the approach of using an action to update a child table, however, I have 25 different date fields that I want to track. So, that means 25 different child tables, right? Would that be more efficient, or would it be more efficient to create a separate log field for each date field, each with it's own form rule? Also, is there any way to not show the user ID and date of entry in the log field, i.e. just display the list of sequential entries?


  • 17.  RE: Is it possible to log edits within a date field?

    Posted 01-16-2019 21:20
    You would not need to have 25 child tables as you could have an identifier in the log table to identify the field.

    But maybe in your case, yes set up 25 log fields and 25 form rules to populate the log fields.

    The there is a formula I can help with to count the # of updates.  So you will need 25  formuals.  Then you will need 25 more formulas to to parse out the most recent date update.

    I think if I had to that somewhat ugly project I would use a child table.  you can have I think 20 Automations per table to trap 20 date field changes and 10 Actions to trap the remaining 5.

    Otherwise you need to use a webhook to log all 25 when any of them changes and then using an automation delete out the date changes that did not change.

    This is just an overview - due to the large # of fields to be tracked its not a trivial project.


  • 18.  RE: Is it possible to log edits within a date field?

    Posted 05-31-2017 17:03
    That's true.  Does actions handle bulk ops better than webhooks (like save on a grid edit)


  • 19.  RE: Is it possible to log edits within a date field?

    Posted 05-31-2017 17:03
    That's true.  Does actions handle bulk ops better than webhooks (like save on a grid edit)


  • 20.  RE: Is it possible to log edits within a date field?

    Posted 05-31-2017 17:06
    Yes they do handle Grid Edit.


  • 21.  RE: Is it possible to log edits within a date field?

    Posted 05-31-2017 17:10
    Will check it out.  The way Web Hooks / Email Notifications handles bulk edits isn't ideal, would be pretty impressed if the action handles it differently.