# Transaction Block Groups **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [October 17, 2022, 1:48pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278 "2022-10-17T13:48:50Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![CMuecke](https://avatars.discourse-cdn.com/v4/letter/c/df705f/32.png) [@CMuecke](https://forum.inductiveautomation.com/u/CMuecke)\ **Post date:** [October 17, 2022, 1:48pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278/1 "2022-10-17T13:48:50Z")
I need some help with the Transaction Block Group. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/e/7e0c9ed0357215205bb99fd45f46545340d72c70.png) Shown above, I have a Standard Group transaction set up and have it working without any issues. Now, rather than having a Standard group for each Bin, it makes sense for me to have a Transaction Block Group. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/6/d67eb4fe04fe99fece0f302fd3074eb3b6df5a70.png) I drag and drop the Tags into the Group Transaction, but when I run the group, I only get true false values. My guess is the Update/Select does not have anything in it so it is just returning true/false. Is it possible for the Transaction Group to do this? If so, can someone point me in a direction to achieve this? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [October 17, 2022, 2:44pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278/2 "2022-10-17T14:44:12Z")
When you set this up, each Item will represent a column in the table. Let say you were wanting to record multiple bins at once, presumably under the `ENABLED` item you would add a reference to each bins `ENABLED` tag. This would continue for each value that you are collecting for the bins. In this case you have configured the ENABLED item as string, but in reality it should be a boolean item. The assumption is that each tag in a Block item will be of the same type, which is why they are all showing true. You still need multiple items. Find info for and an example of a Block Group in the manual. [https://docs.inductiveautomation.com/display/DOC81/Types+of+Groups](https://docs.inductiveautomation.com/display/DOC81/Types+of+Groups) ---
**Author:** ![CMuecke](https://avatars.discourse-cdn.com/v4/letter/c/df705f/32.png) [@CMuecke](https://forum.inductiveautomation.com/u/CMuecke)\ **Post date:** [October 17, 2022, 3:01pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278/3 "2022-10-17T15:01:38Z")
So these will grab the Columns but not the Rows? Which is fine, just will need to plan accordingly. ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [October 17, 2022, 3:03pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278/4 "2022-10-17T15:03:52Z")
Each Item becomes a column in the table, each tag under the item becomes a row in that column. ---
**Author:** ![CMuecke](https://avatars.discourse-cdn.com/v4/letter/c/df705f/32.png) [@CMuecke](https://forum.inductiveautomation.com/u/CMuecke)\ **Post date:** [October 17, 2022, 3:14pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278/5 "2022-10-17T15:14:47Z")
Just so I am interpreting this correctly. It goes Column first, then Rows of that Column. Meaning if I have multiple columns, I would need to have each Block setup for every column in the DB table? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [October 17, 2022, 7:55pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278/6 "2022-10-17T19:55:54Z")
That is correct, for a Block Group, each **Block Item** represents a Column in the table, and each **Tag** added to that item represents a row. So for instance you would need an individual item for `Eanbled, Item_Desc, Item_ID, Lot_ID, Pri, Sec, Source_Desc, Source_ID, Wgt`. Under each of those Items, you would add the Bin Unique tag for that Item. So if you have 3 Bins, then You would have `Bin_1.Enabled, Bin_2.Enabled, Bin_3.Enabled` as tags in the Enabled Item. ---
**Author:** ![CMuecke](https://avatars.discourse-cdn.com/v4/letter/c/df705f/32.png) [@CMuecke](https://forum.inductiveautomation.com/u/CMuecke)\ **Post date:** [October 18, 2022, 12:04pm UTC](https://forum.inductiveautomation.com/t/transaction-block-groups/65278/7 "2022-10-18T12:04:30Z")
Thank you for the help!