Repeating Section Row Count based on field data

[dfricke10]

I have a repeating section. I have a logical field (checkbox) in that repeating section called 'PromoFlag'. I want to count the number of rows where 'PromoFlag' = true. I have a button on each row that sets that true or false, so I would assume a Javascript function called from this button can do this? Then I want to display that number in a textbox called 'rowcount'.

Simple enough, huh? I can get the row count, but don't know how to do it based on a variable. Any help?

[alexc]

Re: Repeating Section Row Count based on field data

Try this in the Button event

var Repeatingsection = {Dialog.object}._harvestRepeatingSection('REPEATINGSECTION_1');
var total = 0;
for (i = 0; i < Repeatingsection.length; i++) {
    if (Repeatingsection[i].PROMOFLAG) {
        total++
    }
}
{Dialog.object}.setValue('rowcount', total)

[CharlesParker]

Re: Repeating Section Row Count based on field data

Looks good Alex! Thank you for posting that.

[dfricke10]

Re: Repeating Section Row Count based on field data

Yes, awesome! Thanks, Alex!

[dfricke10]

Re: Repeating Section Row Count based on field data

Now, let's say that each PROMOFLAG row has a price field 'price', and if the price is $2.99 and once there's 5 rows with the price of $2.99, change that price to $2.00. Then the 6th row would be 2.99 and so on until you hit the 10th row and then change the last 5 to $2.00.

This is a Point Of Sale application and what I have is a sale where clothing is $2.99 or 5 for $10. Trying to now figure out how to change the pricing on each row with the PROMOFLAG to $2.00 once the row count of PROMOFLAG hits 5.

So, the first 5 is $2.00, row 6-9 is $2.99, once we hit 10 rows, the last 5 with the PROMOFLAG change to $2.00.

Is that confusing enough? :) Is this possible?

[alexc]

Re: Repeating Section Row Count based on field data

Anything is possible :).

This is actually easily done with some simple math.

I will note though this example assumes all items within the repeating section are at the same discount amount / and within the same discount pool. I have attached an example UX, as posting the code alone may not help.

Code located on the Button onClick event

var promo = {dialog.object}.getValue('PROMOFLAG');
if(promo === false){
	{dialog.object}.setValue('PROMOFLAG', true);
}else{
	{dialog.object}.setValue('PROMOFLAG', false);
};

var Repeatingsection = {dialog.object}._harvestRepeatingSection('REPEATINGSECTION_1');
var total = 0;
for (i = 0; i < Repeatingsection.length; i++) {
    if (Repeatingsection[i].PROMOFLAG) {
        total++;
    }
};

{dialog.object}.setValue('rowcount', total);

var price = {dialog.object}.getValue('price');
var discountPrice = {dialog.object}.getValue('discountPrice');
var bulkQtyDiscount = {dialog.object}.getValue('discountBulkQty');
var qtyDiscountGroup = Math.floor(total / bulkQtyDiscount);
var remainer = total % bulkQtyDiscount;

var discountPriceSubTotal = discountPrice * qtyDiscountGroup * bulkQtyDiscount;
var nonDiscountPriceSubTotal = price * remainer; 
var PriceTotal = discountPriceSubTotal + nonDiscountPriceSubTotal;

{dialog.object}.setValue('totalPrice', PriceTotal);

[dfricke10]

Re: Repeating Section Row Count based on field data

Looks to be exactly what I'm looking for in a roundabout way. Now I have to implement in my process. Thank you so much!! Genius!

[dfricke10]

Re: Repeating Section Row Count based on field data

While playing with this I came up with this question.

Is it possible, instead of doing the math, to actually change the 'price' field in the repeating section based off of what is in the discountPrice and blukQtyDiscount fields if the PROMOFLAG is checked?

[alexc]

Re: Repeating Section Row Count based on field data

Not sure i follow your logic here. Each repeating section is not aware of its surrounding fields. therefore without a loop over the repeating section you could not apply the discount when you select x qty i.e. 5 of any particular group of products. I don't see how you would avoid the math. I would not go with changing the value of price, if anything it should be a new field if you like. I am guessing that their is a query from the database to serve up the repeating section and in my mind should include along the other required fields a groupDiscid, Price and discountPrice. Further to that you would want to also store a query in a either one of the following data series, data side cache, viewbox or listcontrol basically something that can store a list that contains all your groupDiscid and groupDiscQty. I cant help you exactly if i don't know your exact situation. Any chance you can provide a sample of your ux, happy help you further :).

[dfricke10]

Re: Repeating Section Row Count based on field data

This works.

function setPromoprice(){

	var d1 = {dialog.Object}.getValue('promoprice');
	var rc = {dialog.object}.getValue('rowcount');
	var rows = {dialog.Object}._getRepeatingSectionRowCount('CONTAINER_3');
		for (var i = 1; i < rows+1; i++) {
			{dialog.Object}.setRepeatingSectionActiveRow('CONTAINER_3',i);

	var d2 = {dialog.Object}.getValue('promo');
		if (d2 == true && rc % 5 === 0) {
			{dialog.Object}.setValue('Price',d1);
		}
	}

}

Each row has the price, qty, then total. Total is price*qty of course.

This goes and gets the 'promoprice' which would be the sale price if you buy 5, or a multiple of 5. i.e. 5 for $10.
Gets the 'rowcount'
Gets the repeating section they're in.
Gets the value of 'promo' which is a logical field saying that this item is part of the sale.
Looks to see if d2 is 'true' and the rowcount is a muliple of 5.
Set the price to the 'promoprice' of all that have the 'promocount' to true.

Maybe I was overexplaining it to you or over thinking. Any tips on this one?

Here's the 3 functions that do everything. processProductData queries the database, checks if it's on sale, modifies price if it is, and fills in the repeating section row.
promoCount counts the rows that are on sale. (uses this to calculate 5 for $10)
Then setPromoprice sets the sale price if they have a muliple of 5.

function processProductData(prodData){

	var prodObj = JSON.parse(prodData);
	var catPromo = prodObj.P_Active;
	var PStatus = {dialog.object}.getValue('PromotionStatus');
	var price = prodObj.price;
	
	if (catPromo == 1 && price >= 2.99){
		{dialog.Object}.setValue('Price',"2.99");
		}
		else
		{
		{dialog.Object}.setValue('Price',prodObj.price);
		}
		
	
	{dialog.Object}.setValue('Item_ID',prodObj.item_id);
	{dialog.Object}.setValue('SKU',prodObj.SKU);
	{dialog.Object}.setValue('TaxRateProd',prodObj.tax1);
	{dialog.Object}.setValue('CurrentStock',prodObj.quantity);
	{dialog.Object}.setValue('IsActive',prodObj.Active);
	{dialog.Object}.setValue('TaxExemptProd',prodObj.TaxExempt);
	{dialog.Object}.setValue('ItemName',prodObj.Item);
	{dialog.Object}.setValue('Size',prodObj.Size_1);
	{dialog.Object}.setValue('Category',prodObj.Category_1);
	{dialog.Object}.setValue('ItemNameNum',prodObj.item_name);
	{dialog.Object}.setValue('SizeNum',prodObj.Size);
	{dialog.Object}.setValue('CategoryNum',prodObj.category);
	{dialog.Object}.setValue('Promo',prodObj.P_Active);

	{dialog.Object}.setValue('SKULookup',"");
	{dialog.object}.setValue('SKUTemp',"")
	
	{dialog.Object}.addRepeatingSectionRow('CONTAINER_3');
	this.value='';

	var count = {dialog.Object}._getRepeatingSectionRowCount('CONTAINER_3');
	{dialog.Object}.setRepeatingSectionActiveRow('CONTAINER_3',count);
	

}

function promoCount(){

	var Repeatingsection = {Dialog.object}._harvestRepeatingSection('CONTAINER_3');
		var total = 0;
			for (i = 0; i < Repeatingsection.length; i++) {
  			  if (Repeatingsection[i].PROMO) {
    		    total++
  		}
	}
	{Dialog.object}.setValue('rowcount', total)

}

function setPromoprice(){

	var d1 = {dialog.Object}.getValue('promoprice');
	var rc = {dialog.object}.getValue('rowcount');
	var rows = {dialog.Object}._getRepeatingSectionRowCount('CONTAINER_3');
		for (var i = 1; i < rows+1; i++) {
			{dialog.Object}.setRepeatingSectionActiveRow('CONTAINER_3',i);

	var d2 = {dialog.Object}.getValue('promo');
		if (d2 == true && rc % 5 === 0) {
			{dialog.Object}.setValue('Price',d1);
		}
	}

}

What yours wasn't doing is accounting for the non-sale items in the sale total. I'm sure that would have been easy to implement.

Let me know what you think. Thank you for your help!!!

[alexc]

Re: Repeating Section Row Count based on field data

Any chance you could you do a quick video demo / screenshot of this component so i visually seen whats happening and a screenshot of the ux controls in the designer,.that would make my life easier in interrupting and understanding.

Looking at your code is every item 2.99 and all items discounted to 2 when you buy multiplies of 5. do you not have a need to make these variables as they are hard coded or is this just sample code to illustrate the scenario.

[dfricke10]

Re: Repeating Section Row Count based on field data

All items have different prices. Some $2.99, and some $3.99 and up. The sale puts them all at $2.99 and then 5 for $10.

I will make a video.

[dfricke10]

Re: Repeating Section Row Count based on field data

Here's the link to what I'm doing.

https://www.screencast.com/t/o591GMZQcG

[alexc]

Re: Repeating Section Row Count based on field data

Nice, application looks good :) Thanks for the explanation. The {Dialog.object}._harvestRepeatingSection() function is a nice undocumented function