set default value of repeating section column to parent field value

[frankbicknell]

does anyone know how?

From the description in the default value I can only use literal value, argument, or session variable.

I hope I don't have to make a callback to set a session variable. Is there a better way?

[GGandhi]

Re: set default value of repeating section column to parent field value

I am assuming this is in a dialog/ux with repeating section (since you are in version 12, I do not know what other controls have repeating section in that version, I don't have version 12)
instead of default value if you define the value of the repeating section field as calculated field referring back to the parent field it will populate once the parent field is filled in. I am sure.

[Davidk]

Re: set default value of repeating section column to parent field value

You don't say where, when, etc. you want to do this... but... if you want to click the add row button for a repeating section and have a value from the "parent" section fill a control in that new row, you could do this.

In the Client-side event, afterRptSectionRowAdd

var cmpy = {dialog.Object}.getValue('COMPANY'); //parent control

{dialog.object}.setValue('SystemType:-1',cmpy);

SystemType is a control within a repeating section. -1 targets that new row.

[frankbicknell]

Re: set default value of repeating section column to parent field value

Thanks gandhi, that is one way of doing it. The issue for me is that I would like to be able to modify the value in each row if necessary.

David, Thanks for the tip. Sometimes I don't know what I am really looking for until I experiment with what I think I need.

So what I was actually trying to achieve is have a column in the repeating section set to a literal value. Very easy in the Initial Value property. I have a field in the parent section that holds the same initial value. When I change that value I needed the values in the repeating section column to reflect the change.
Ultimately I would like the value in the repeating section to reflect the parent value at the time the ux is built and as each new row is added so that I would not have to hard code those numbers. I could just change it in the parent table.

This is how I accomplished it.

In the parent fields onChange event:

I do a callback to this xbasic function: xbSetMarkup

This id the code in the function

	dim mu as n
	dim rc as n
	dim str as c
	mu = e.dataSubmitted.markup
	rc = e.repeatingSectionInfo[1].rowCount
	
	for r = 1 to rc
		str = 	"e._set.eliMarkup_a5instance"+alltrim(str(r))+".value"
		eval(str) = mu
	next

When I change the value in the default markup field in the parent section it loops through the rows in the repeating section updating the markup column for the line items.
It is a 'c a l l b a c k'. Ii seems like there should be a way to get it done client side but I can't see how.

[Davidk]

Re: set default value of repeating section column to parent field value

Ok... this is a very different question.

You want to set the default value of a repeating section control based on a parent control value... and... you want to be able to change that parent control value and reflect that change in a repeating section control - for all existing rows. You know now how to set the default value based on a parent value. Now, let's change those existing values.

If you have source data at the client level, then I don't think you ever need to go back to the server to get something done.

var currCmpy = {dialog.Object}.getValue('COMPANY');
var rptSect = {dialog.Object}._findRepeatingSection('SystemType');
var rptSectRows = eval("{dialog.Object}.repeatingSections." + rptSect + ".rows");
for(i=0;i<=rptSectRows;i++){
	{dialog.Object}.setValue('SystemType:'+i,currCmpy);
}

First, we grab the parent control value... in this case 'COMPANY'.
Then, using the control we want to change, let's find out which Repeating Section it's in.
We now know the Section, so let's go get the number of rows in that section.
Then, in a loop, .setValue() each row.

[frankbicknell]

Re: set default value of repeating section column to parent field value

David thank you for your help.

This line is giving me some trouble though
var rptSectRows = eval("{dialog.Object}.repeatingSections." + rptSect + ".rows");

In firebug I get this error:
WO_BR_UX_103753OSXQ_EST_BR_UX_UTFC_DlgObj.repeatingSections..rows

It looks like there are 2 dots between repeatingSections and rows.

I tried this
var rptSectRows = eval("{dialog.Object}.repeatingSections." + rptSect + "rows");

But I get nothing. I am not sure of what is wrong with this line.

var rptSectRows = 5 yields the desired result. I am very close.

[GGandhi]

Re: set default value of repeating section column to parent field value

http://screencast.com/t/ULhKezop

http://screencast.com/t/S7osiFEB

take a look at these screencasts.
I did this with three javascript events, I don't think you can do it in one.
this is my assumption after reading your reply in post #4.
1> you want to set the default value in a control in repeating section to the value from the head section.
2> you want to be able to change the value in the repeating section control on the fly.
3> when a new row in the repeating section is added the value from the head section is to be copied as default value.
4> and not the least, when you change the value in the head section all the rows in the repeating section should change to reflect the new value.
if these assumptions are correct, the above screencasts will show you how.
hope this helps.

[Davidk]

Re: set default value of repeating section column to parent field value

Frank, it looks like your UX is sitting inside something... or being opened by something. Try this instead...

var currCmpy = {dialog.Object}.getValue('COMPANY');
var rptSectRows = {dialog.Object}._getRepeatingSectionRowCount("REPEATINGSECTION_1");
for(i=0;i<=rptSectRows;i++){
	{dialog.Object}.setValue('SystemType:'+i,currCmpy);
}

Swapping out your own info for .getValue, the repeating section, and .setValue.

[frankbicknell]

Re: set default value of repeating section column to parent field value

Thank you gentlemen for your generous assistance.
I am using gandhi's method for the default value and I have used a combination of both David and gandhi's methods in the onChange event and it works perfectly.