Method Community

 

Current Date Time in Insert Record

Last post 04-29-2015 1:00 PM by Matt. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 04-01-2015 4:29 PM

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Current Date Time in Insert Record

    It appears that the Current Date / Time can only be used once in an insert record into table action.

    I am trying to insert a record into the time tracking table with the txndate and timetrackingstarttime fields both getting their value from the current date/time. In this case on the txn date field get populated. If I assign the current date/time to an action result and use that for the txndate, then it will work and both fields get populated. Intersetingly if I try to use the action result to populate the timetrackingstarttime, it does not work.


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 04-02-2015 9:06 AM In reply to

    Re: Current Date Time in Insert Record

    Hi Matt,

    I was able to assign the current session date / time to 2 fields in an Insert Record Into Table action fine.

     

    I tried assigning the current session date / time to an action result and use that action result twice in an Insert Record Into Table action, but received an error and was unable to save this. Removing and re-creating the Insert Record Into Table action resolved this however.

     

    Is there anything that you think I might be missing? If you email me the company account name and app details I’m happy to take a peek.

    -Audisho

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 04-02-2015 3:57 PM In reply to

    Re: Current Date Time in Insert Record

    Hi Matt,

    I’m unable to reproduce this in any fashion on my account, but can definitely confirm that it is occurring on your account. I can’t see anything wrong with your Insert Record Into Table action and no error is thrown when the action is processed. From what I can see, there is no obvious reason that this is happening.

    I have created a ticket for the development team to investigate further. I will post any updated that I receive here. Sorry for the inconvenience.

    -Audisho

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 04-29-2015 11:46 AM In reply to

    Re: Current Date Time in Insert Record

    Answer

    Hi Matt,

    Our development team had a look at this and here’s what they found:

    When inserting a time tracking record into QBO, a TimeTrackingStartTime and TimeTrackingEndTime must both exist. If a value for both fields does not exist, both values are set to null.

    In M:C, the record would not be posted to QBO until a save or send to desktop action was used. In M:N, the record is being posted immediately upon insertion, causing QBO to clear both values, as you of course do not yet have an end time.

    You could try inserting a temporary value into the TimeTrackingEndTime field and overwrite this value once the stop button is selected with the actual end time. I’m not sure what effect this will have on your accounting however.

    Another option would be to create a custom field to temporarily store the start time until the entry has been completed. You can then enter both the start and end times when the stop button is pressed.

    Please post back and let me know whether this works for you.

    -Audisho

    Edit: This is only a requirement for QBO. Updated my post to reflect this.

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 04-29-2015 12:05 PM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Re: Current Date Time in Insert Record

    Answer

    Thanks Audisho,

    If sending the entry to QBO is what clears the Start Time, can I set the IsWaitngForSync approval to true and then set is waiting for sync approval to false when the End Time gets entered?


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


  • 04-29-2015 12:14 PM In reply to

    Re: Current Date Time in Insert Record

    Hi Matt,

    Yes, that should work too and is a much simpler solution. I completely overlooked the fact that the TimeTracking table has this option. 

    -Audisho

    Audisho Sada
    Product Manager
    Method:CRM
    a.sada@method.me
    Toll Free: 1.888.925.6238
    Local & Overseas: 416.847.0400
    Fax: 416.640.6027
  • 04-29-2015 1:00 PM In reply to

    • Matt
    • Top 10 Contributor
    • Joined on 11-04-2008
    • Posts 877

    Re: Current Date Time in Insert Record

    Great, thanks.


    Matt Raiser

    Founder,



    www.techinthefield.com

    matt@techinthefield.com

    219-221-9500



    ~ Method user / partner since 2008

    ~ Over 15 years field service experience

    ~ 2013 Method Partner of the Year

    ~ Degree in Computer Science





    Creator of:


        


Page 1 of 1 (7 items)