UX - Repaeting section Field Calculation

[RickyRelouw]

Hello

I have a UX that has a date field and a person's Weight in KG (Numeric)

E.g.

Date 01/01/2013, Weight 84 KG

I was wondering if there is a way to add a new field to calculate the Weight difference from one Repeating Row to the next in UX Repeating section?
E.g.
Repeating Section
Date 01/01/2013, Weight 84 Difference = Nil - 0kg
Date 01/02/2013, Weight 82 Difference = Loss - 2kg
Date 01/03/2013, Weight 83 Difference = Gain - 1kg
Etc:

Any suggestions?

Regards

Ricky

[Davidk]

Re: UX - Repaeting section Field Calculation

When I first read this I thought... interesting... then I thought... hold on a sec... then I thought... I remember writing something like this... that will be handy... so I did a search here (took less than one minute) and found this...

http://msgboard.alphasoftware.com/al...ghlight=weight

EDIT: Then I read again... and you need this for a UX... I should learn to read better.

I think this could be easily adapted... I'll have a look.

[Davidk]

Re: UX - Repaeting section Field Calculation

With a few minor "dialog" specific changes... essentially it's the same code and process. There is a difference between physical rows and logical rows in a dialog. Physical rows include deleted rows... so watch out for that.
Have a look at the documentation for {dialog.Object}.getRepeatingSectionActiveRow for more info on physical and logical and decide if you need to include the logical flag in the method.

I put this code into the onChange event of the Weight field.

var currRow = {dialog.Object}.getRepeatingSectionActiveRow('CONTAINER_1');
var diffW = 0;
var prevRow = 0;
var wChg = '';
prevRow = currRow-1;
   
if (prevRow > 0)
{

   var prevW = {dialog.object}.getValue('WEIGHT:'+prevRow);
   var currW = {dialog.object}.getValue('WEIGHT:'+currRow);
   diffW = currW - prevW;
   diffW = diffW.toFixed(2);
   if (currW < prevW)
   	  {
      wChg = 'Loss';
      }
   if (currW === prevW)
      {
      wChg = 'No Change';
      }
   if (currW > prevW)
      {
      wChg = 'Gain';
      }

	{dialog.object}.setValue('WEIGHTDIFF:'+currRow,diffW);
	{dialog.object}.setValue('WEIGHTCHG:'+currRow,wChg);
	
}

[GGandhi]

Re: UX - Repaeting section Field Calculation

hello

take a look at this
http://screencast.com/t/3d8AebUY

not difficult.
here is the code that fires onchange event of the weight

function calculateWeight as c (e as p)
	
	'debug(1)
	dim current_row as n
	dim last_row as n
	dim current_wt as n
	dim last_wt as n
	dim differenceWt as n
	current_row = e._repeatingSections.CONTAINER_1.activeRow
	if current_row = 1
		last_row = current_row
		else
		last_row = current_row - 1
		end if
	current_wt = e.dataSubmitted.weight[current_row]
	last_wt = e.dataSubmitted.weight[last_row]
	differenceWt = current_wt - last_wt
	e._set.difference.value = differenceWt

[GGandhi]

Re: UX - Repaeting section Field Calculation

I have added the description you specified in the post #1

http://screencast.com/t/vjZb8MtGV

here is the modified code.

function calculateWeight as c (e as p)
	
	'debug(1)
	dim current_row as n
	dim last_row as n
	dim current_wt as n
	dim last_wt as n
	dim differenceWt as n
	dim difference as c
	current_row = e._repeatingSections.CONTAINER_1.activeRow
	if current_row = 1
		last_row = current_row
		else
		last_row = current_row - 1
		end if
	current_wt = e.dataSubmitted.weight[current_row]
	last_wt = e.dataSubmitted.weight[last_row]
	differenceWt = current_wt - last_wt
	
	select
		case (differenceWt = 0)
			if current_row = 1
		 	difference = "Base Start Weight"+" "+current_wt
		 	else
		 	difference = "No change from last visit"
		 	end if
		case (differenceWt < 1)
			difference = "Lost"+" "+abs(differenceWt)+" "+"pounds from last visit"
		case (differenceWt > 1)
			difference = "Gained"+" "+abs(differenceWt)+" "+"pounds from last visit"
	end select

[RickyRelouw]

Re: UX - Repaeting section Field Calculation

Thanks for the reply guys,

Thanks Govindan for the suggestions, will give it a try in the next few week, once holidays are over...

Thanks David, I guessed the code would be different, in the UX than in a grid. That's why I re-post the initial request.

Cheers.

[RickyRelouw]

Re: UX - Repaeting section Field Calculation

Hello Gandhi,

I have tried to use your code as shown above, but I must be doing something wrong as I cant seem to get it to work.

I placed the code in the onchange event for Weight field. (But little unsure - if the code goes into the "text" section or the "server side xbasic" section?

Also What fields in the repeating section must be added I have the following - eg: Weight, differenceWt, difference.

Hope this make sense?

any ideas?

[Davidk]

Re: UX - Repaeting section Field Calculation

I think Gandhi's solution is excellent. I would like to point out something. Each time you call an xbasic routine you're making a round trip to the server. If you need to go get something you haven't got then that's all ok. But... if you've already got everything you need at the client end, then there's no reason to go anywhere. I think this is important generally... and even more so when we're all looking at mobile (possibly disconnected) applications.
Just something to keep in mind.

[GGandhi]

Re: UX - Repaeting section Field Calculation

create an ajax callback on onchange event, call that function calculateWeight
and add the code below the function declaration.

function calculateWeight as c (e as p)
	
	'debug(1)
	dim current_row as n
	dim last_row as n
	dim current_wt as n
	dim last_wt as n
	dim differenceWt as n
	dim difference as c
	current_row = e._repeatingSections.CONTAINER_1.activeRow
	if current_row = 1
		last_row = current_row
		else
		last_row = current_row - 1
		end if
	current_wt = e.dataSubmitted.weight[current_row]
	last_wt = e.dataSubmitted.weight[last_row]
	differenceWt = current_wt - last_wt
	
	select
		case (differenceWt = 0)
			if current_row = 1
		 	difference = "Base Start Weight"+" "+current_wt
		 	else
		 	difference = "No change from last visit"
		 	end if
		case (differenceWt < 1)
			difference = "Lost"+" "+abs(differenceWt)+" "+"pounds from last visit"
		case (differenceWt > 1)
			difference = "Gained"+" "+abs(differenceWt)+" "+"pounds from last visit"
	end select

  e._set.differenceWt.value = differenceWt
  e._set.difference.value = difference

you don't need to show differenceWt you can hide it if you want or eliminate it altogether.

http://screencast.com/t/DWS0BV9YiS

[GGandhi]

Re: UX - Repaeting section Field Calculation

I think Gandhi's solution is excellent.

thank you very much for your kind words, david. it is real honor.
thank you once again.

[peteconway]

Re: UX - Repaeting section Field Calculation

Me as well.