Is it possible to code a GI to consolidate GI filter results by checking a check box?
We sell flower bulbs in different pack sizes. I made a GI that we can filter by variety name, but it needs to show all individual pack sizes (3 separate stock items). But once I get my sales order range I then need to consolidate those results based on inventory ID.
Is it possible to consolidate GI results on the fly like that?
Best answer by MichaelShirk
On the “Grouping” tab of the GI design you can use a formula to define the grouping logic, and that formula can use the parameter.
The trick here may be to use an “IF” statement in the grouping formula to check if the “Group Results” value is checked (true). If true, group by InventoryID, if false, then I believe you need to use some other value to group by. I don’t think you can leave it empty. Is there a value that will be unique when you don’t have the box checked?
+5
On the “Grouping” tab of the GI design you can use a formula to define the grouping logic, and that formula can use the parameter.
The trick here may be to use an “IF” statement in the grouping formula to check if the “Group Results” value is checked (true). If true, group by InventoryID, if false, then I believe you need to use some other value to group by. I don’t think you can leave it empty. Is there a value that will be unique when you don’t have the box checked?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
