Method Community

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.

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

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

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.

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?

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

Great, thanks.