# Transaction Group - Timing of first record

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-timing-of-first-record/11235>\
**Category:** Ignition\
**Created:** [February 18, 2016, 8:26pm UTC](https://forum.inductiveautomation.com/t/transaction-group-timing-of-first-record/11235 "2016-02-18T20:26:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![matt.baker](https://avatars.discourse-cdn.com/v4/letter/m/77aa72/32.png) [@matt.baker](https://forum.inductiveautomation.com/u/matt.baker)\
**Post date:** [February 18, 2016, 8:26pm UTC](https://forum.inductiveautomation.com/t/transaction-group-timing-of-first-record/11235/1 "2016-02-18T20:26:57Z")

</div>

I have a Transaction group set up and it is logging data to SQL table when a Boolean value is true every 1 minute and stops logging when the tag goes false. Works fine. The problem is that I want the Boolean tag to be on for a minute before the data gets logged. As it is, regardless of when the tag goes true, the first record is logged at hh:mm:37 seconds and then every minute after that not necessarily 1 minute after the tag went true.

How do I configure the transaction group to log the data exactly (as exact as possible) one minute after the boolean tag goes true and then every minute after?

Thanks

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [February 18, 2016, 10:39pm UTC](https://forum.inductiveautomation.com/t/transaction-group-timing-of-first-record/11235/2 "2016-02-18T22:39:07Z")

</div>

Off the top of my head since I don’t have the designer in front of me, but can you create an always executing boolean expression tag as your trigger and do something like:

case(  
toInt(tag(‘YourBoolean’))+dateExtract(now(1000),‘sec’),  
1,1,0)

This will be 1 if your tag is true plus 0==1 it will return true.

---

<div class="post-metadata">

**Author:** ![matt.baker](https://avatars.discourse-cdn.com/v4/letter/m/77aa72/32.png) [@matt.baker](https://forum.inductiveautomation.com/u/matt.baker)\
**Post date:** [February 19, 2016, 6:40pm UTC](https://forum.inductiveautomation.com/t/transaction-group-timing-of-first-record/11235/3 "2016-02-19T18:40:24Z")

</div>

No, that does not do it, but thanks for replying.
