CDML & conditional value lists

December 7, 200223 yr

Hey all,

Me again. I've been chugging along on this CDML stuff, which for the most part seems to suit my needs. But, I've run into a situation where conditional pop-up menus are necessary via web entry. I've learned this is not possible via cdml since the web form needs to post back to the db before it can alter the lists.

I was going to work around it by dividing the html form process into two separate pages (one which submits the initial data the the other which edits it using the conditional value lists). But, this will not work because my conditinal list is based on related values (another thing CDML does not deal with it seems).

So, I am wondering what kinds of work arounds y'all have implemented in oder to use related value lists on the web. Or, alterntively, what solutions have you come up with to have conditinal value lists? From what I've read in the forums, there's lot of JavaScript talk and/or workarounds involving calc fields. Could anyone elaborate?

many, many thanks as always

Nate

December 8, 200223 yr

We've used Javascript for one project with a three-way relationship. We loaded the data into Javascript arrays and combined with Dynamic HTML were able to replace the contents of other "Select" tags (ValueList Pop-ups) depending on the previous selections.

Hope this is of interest.

Garry

December 9, 200223 yr

Author

Hi Garry,

Yes, I'm definitely interested. Is the JavaScript complicated? I ask because, well, I don't know any. Would it be a pretty difficult "first project" for Java? None the less, I'd be interested in any more details (or even code if the site might be available).

thanks!

Nate

December 9, 200223 yr

The complexity depends on how many levels of conditions/ValueLists and how your data is organised.

What do the VlaueLists look like? And, how is the data organised in the database?

All the best.

Garry

December 9, 200223 yr

Author

Well, I hope it is something I can work through. It is only one level deep. The user will pick a "showName" and will then have to choose from a generated list of shots ("shotName"). I have this working in FilmeMaker itself using a master database and two related db's ("shows" and "shots"). But, as you explained to me last week, relational valuelists don't work too well with CDML and I'll pretty much learn whatever I have to get them to work via the web.

please let me know if I can provide any more details

thanks

Nate

December 10, 200223 yr

Do you use a Portal on a Layout in "shows" to display related "shots"? If so, you would loop through each record of "show" and each Portal row for each record. Create the arrays like this:

<head>

var shows = new Array();

[FMP-Record]

i = 0 ;

var show_shots = new Array() ;

[FMP-Portal:shots]

show_shots[i++] = "[FMP-Field: shotName]";

[/FMP-Portal]

shows("[FMP-Field:showName]") = show_shots ;

[/FMP-Record]

</script></head>

Now you will need to be able to populate the <select> tags.

All the best.

Garry

December 10, 200223 yr

Author

thanks garry! I got the array code above to be populated by the filemaker fields correctly. Now I am working on figuring out how to get them to work with my html form menus. The above code works quite well so far.

Nate

December 10, 200223 yr

Here is the next hint. This will populate the first pop-up:

Show:<select onChange="ShowShots();">

<option>Select a Show</option>

for (m=0; m < shows.length; m++) {

document.write("<option value='" + shows[m] + "'>" + shows[m] + "</option>");

} ; // end for

document.write('</select><br>');

</script>

As you can see whenever the a change is made to the selection a Javascript function named "ShowShots()" is called. this function will change the Select List contents for Shots.

All the best.

Garry

December 11, 200223 yr

Author

Hi Garry,

I was able to get the above code to work initially, but for some reason I cannot get it to work again.

<html>

<head>

</head><body bgcolor="#FFFFFF" text="#000000">

[FMP-InlineAction: -db=shows.fp5, -lay=Form_View, -FindAll]

var shows = new Array();

[FMP-Record]

i = 0 ;

var show_shots = new Array() ;

[FMP-Portal: showName]

show_shots[i++] = "[FMP-Field: showName::t_FX Name]";

[/FMP-Portal]

shows("[FMP-Field:t_showName]") = show_shots ;

[/FMP-Record]

</script>

[/FMP-InlineAction]

Show:<select onChange="ShowShots();">

<option>Select a Show</option>

</script>

</form>

</body>

</html>

As of now I cannot get the Javascript to write/populate the various options, though the javascript in the FMP InLine Action does generate the arrays it seems.

And, do have a particulare favorite JavaScript book or reference for this situation? I can work with example code I think, but am having trouble learning how to write it and work with it myself. And, well, I'd rather not bother you forever... :

in any case

thanks again for your help

Nate

December 11, 200223 yr

Nate,

This line:

</option>"); } ; // end fordocument.write('</select><br>');

Should be:

</option>"); } ; // end for

document.write('</select><br>');

I use O'Rielly's "Javascript - The Definitive Guide". It is quite good, however other books with more practical examples may exist.

All the best.

Garry

December 12, 200223 yr

Author

Hi Garry,

It seems that in this section of code:

var shows = new Array();

[FMP-Record]

i = 0 ;

var show_shots = new Array() ;

[FMP-Portal: showName]

show_shots[i++] = "[FMP-Field: showName::t_FX Name]";

[/FMP-Portal]

shows("[FMP-Field:t_showName]") = show_shots ;

[/FMP-Record]

</script>

the "[i++]" sections are not populating with numbers. They should be number themselves starting with zero, correct? Maybe that's what the problem is. But, either way, I shall be purchasing my very own copy of the O'Reilly book (or another if it seems to suit my needs).

Nate

December 12, 200223 yr

You will not see the i++ values displayed. Only if you write it out to the browser.

The <select> may not be displaying because the main array may be attempting to display another array; as it is an "Associated" array containing an array.

I will have some more time to look at it later this week.

All the best.

Garry

December 13, 200223 yr

Author

Hi Garry,

I was finally able to get the whole thing to work using the code below. I pretty much attempted to combine it with another, similar example I found on another website. The code it probably not as "clean" or efficient as it could be because of that, but it works for now until I can better learn JavaScript. Anyways, thanks very much for helping me (I've also learned quite a bit from your posts in other threads). I can't tell you how much I appreciate it.

Nate

<HTML>

<HEAD>

[FMP-InlineAction: -db=shows.fp5, -lay=Form_View, -FindAll]

var i = 1;

var aLBValues = new Array() ;

[FMP-Record]

aLBValues[i++] = new Array([FMP-Portal: showName]"[FMP-Field: showName::t_FX Name]", [/FMP-Portal]"");

[/FMP-Record]

[/FMP-InlineAction]

function addLBElement(oLB, value, text)

{

var oNewOption = new Option(text) ;

oNewOption.value = value;

oLB.options[oLB.options.length] = oNewOption ;

}

function updateLB()

{

var oLBSource = document.the_form.choose_category ;

var oLBDest = document.the_form.the_examples ;

var nSelId = oLBSource[oLBSource.selectedIndex].value ;

oLBDest.length = 0 ; // Clear the LB

for(nLoop = 0; nLoop < aLBValues[nSelId].length; nLoop++)

{

addLBElement(oLBDest, nLoop, aLBValues[nSelId][nLoop]) ;

}

function onLoad()

{

updateLB() ;

}

</SCRIPT>

</HEAD>

[FMP-InlineAction: -db=shows.fp5, -lay=Form_View, -FindAll]

[FMP-Record]

<option value=[FMP-CurrentRecordNumber]>[FMP-Field:t_showName]</option>

[/FMP-Record]

[/FMP-InlineAction]

</select>

<option>DUMMY VALUES

</select>

</form>

</BODY>

</HTML>

December 14, 200223 yr

Nate,

Well done

All the best.

Garry

December 19, 200223 yr

Author

Ok, after a few days I'm back again with another question or two, because, well I'm just having a rocky time learning CDML and JavaScript for my first project I guess.

Anyways, my conditional value list items in the code above submit a number to the database fields from the array rather than the text itself. For example, in

aLBValues["Gabrielle"] = new Array("SIGN1", "THROW3", "");

when ""SIGN1" is slected it submits a "0" rather than the text and "THROW3" submits "1". Is there something I can change to tell it to submit the text instead of the index number?

Also, I need to submit the info to two portal fields. But, JavaScript doesn't like it when I name my select lists using colons. How have folks worked aroung this?

thanks again!

Nate

December 27, 200223 yr

Nate,

Try this for assigning values to the array:

var a = ["SIGN1", "THROW3", ""];

aLBValues["Gabrielle"] = a;

I have used square brackets for the initalisation of the Array.

I tried the code below and it printed "SIGN1" to the page:

<body>loading...<br>

var aLBValues = new Array();

var a = ["SIGN1", "THROW3", ""];

aLBValues["Gabrielle"] = a;

document.write(aLBValues["Gabrielle"][0]);

</script>

</body>

All the best.

Garry

January 2, 200323 yr

Author

Hi again,

I changed the code per your suggestions. The value lists work perfectly, and I can get it to write the correct text selection as you showed, but for some reason it still submits the array index for

the "web_shot1" form. At first I thought it might have something to do with the "selectedIndex" part of the line below, but I think this line pertains to the "web_show1 " form.

var nSelId = oLBSource[oLBSource.selectedIndex].text ;

Oh, well. I've pasted the entire script below. Please let me know if anything catches your eye or jumps out at you. But no need to spend too much time on my problem.

Nate

SCRIPT:

var i = 1 ;

var aLBValues = new Array() ;

[FMP-Record]

var a = [[FMP-Portal: showName]"[FMP-Field: showName::t_FX Name]", [/FMP-Portal]""];

aLBValues["[FMP-Field:t_showName]"] = a;

[/FMP-Record]

[/FMP-InlineAction]

function addLBElement(oLB, value, text)

{

var oNewOption = new Option(text) ;

oNewOption.value = value;

oLB.options[oLB.options.length] = oNewOption ;

}

function updateLB()

{

var oLBSource = document.the_form.web_show1 ;

var oLBDest = document.the_form.web_shot1 ;

var nSelId = oLBSource[oLBSource.selectedIndex].text ;

oLBDest.length = 0 ; // Clear the LB

for(nLoop = 0; nLoop < aLBValues[nSelId].length; nLoop++)

{

addLBElement(oLBDest, nLoop, aLBValues[nSelId][nLoop]) ;

}

function onLoad()

{

updateLB() ;

}

</SCRIPT>

January 2, 200323 yr

Author

Ugh! My apologies! I replied too soon. I was able to solve the issue. I changed this

var oNewOption = new Option(text) ;

oNewOption.value = value;

to this

var oNewOption = new Option(text) ;

oNewOption.value = text;

Now is submits correctly. Has anyone found any workaround for the portal/javascript conflict?

quote: "Also, I need to submit the info to two portal fields. But, JavaScript doesn't like it when I name my select lists using colons. How have folks worked aroung this?"

thanks for everything

Nate

January 2, 200323 yr

Re: Has anyone found any workaround for the portal/javascript conflict?

How does this go:

document.the_form.elements["showName::t_FX Name.n"].value = "some text";

* where ".n" is the row number.

All the best.

Garry

January 2, 200323 yr

Author

Oh, sorry. I should have been more specific. The portal conflict I get is when I name my selects/drop downs. CDML wants me to name them using colons:

<option value="">DUMMY VALUES

</select>

but Javascript doesn't like it when I write this in the script, I assume because of the colons and periods.

var oLBDest = document.the_form.timeCardID::t_shotName.1 ;

Is there something I can do about this?

January 3, 200323 yr

Author

Ok, I'm an idiot. I misread your previous post Gary. Sorry about that. As soon as my brain actually started working, I was able to successfully use the code you wrote. Sorry about that. Problem sovled!

I can't thank you enough for all your time and help

Nate

January 3, 200323 yr

Happy New Year

Garry

January 22, 200322 yr

Garry and Nate,

I've been reading with fascination your discussion of Javascript and CDML to make related value lists on the same screen. I was able to replicate your example...but, what I REALLY need is the ability to create the same process two levels deep instead of one (i.e. - a show is chosen in the first field, a category in the second, and then the item in the third). If you aren't too burnt out on this topic, could you please post the information on how this might be accomplished. Thanks in advance for any help.

Jeff

January 22, 200322 yr

Hey Garry,

After further thought, I realized that I may be coming at this the wrong way. Let me give you a brief background. In FM I have created a scheduling program with conditional popup lists for "Department", "Position", and "Employee". This is all done with value lists and works great in FM. But, using CDML, this takes the usual three screens to submit the info back to FM to create the next conditional value list. I was hoping to find a way (possibly using Javascript) to combine this into one step for the user. The problem with using portals instead of value lists is that value lists automatically omit duplicates and portals do not (i.e. - if there are 5 Employees that all have the same Position, the Position will show up 5 times in the popup. Nate's example above does this exact thing). I would be interested in your input into a possible solution and an example if possible. As usual, thank you for your time. You are truly an impressive force on this forum. I look forward to hearing from you.

Jeff

January 22, 200322 yr

Jeff,

This is where you begin to use Javascript Arrays of Arrays of Arrays. You will also have to set-up the relationships between items.

How are your Valuelists set-up now; are Position and Employee two related files? Unfortunately, related ValueLists do not work through WebCompanion, hence some other way needs to be devised to establish the relationships.

I will be travelling for the next couple of days. I will have a better chance to look at it on the weekend.

All the best.

Garry

January 25, 200322 yr

Hey Garry,

Thanks for replying so quickly. I hope you had a fun trip and it's wasn't all work. Well, here's more information on my setup of files and some background information on what I'd like to do. Employees (Teachers) are entered in the first database "Employee List". Each teacher can belong to multiple departments and teach multiple classes (i.e. a one-to-many relationship of departments and positions) this is related to the file "Employee Department Position" which contains the "Employee Name", "Department" and "Position" fields. Let's say we want to schedule a student taking classes. Once the student information is entered we want to assign classes. On a single screen (right now it takes three screens), we want to select a Department (English), a Position (Literature or Composition - these would only be related values to department), and finally the Employees (teachers) that are teaching that class (Mrs. White or Ms. Green). Right now, I use a combination of value lists and portals for this to work. But, it is time confusing for the people utilizing my site because they have so many steps through different screens. It would be much simpler if they could select all of the conditional popup information on one screen. I utilized value lists instead of portals because it builds lists without repeating values (i.e. - if there are five teachers teaching "Literature", "Literature" won't be in the second menu five times...as it would with portals). So, even though I successfully tried the solution you gave Nate, it wouldn't exactly work in my situation because I would end up with duplicate values in the second popup. What I need explained is: how do I send all of the related permutations for the three popups while eliminating duplicate values? I know that what I'm attempting is very agressive for a first Javascript project, but it would completely change the way I'm approaching this site if this is indeed possible. Once again thanks for all your help on this forum and around this site. I can't relay how much information I have gleened from your participation in the various forums. If you're ever in Las Vegas, make sure and drop me a line. I owe you dinner and a show!

Talk to you soon,

Jeff

January 25, 200322 yr

Jeff,

I'm still in Sydney; however looking forward to heading home (Sunshine Coast) on Tuesday :-)

Here is a start for getting all of the values into Javascript Arrays:

	<meta name="generator" content="BBEdit 7.0.1">

	<script>

		// Declare Variables

		var aDept = new Array();

		var aPosn = new Array();

		var aEmp = new Array();

		var i = 0;

		var j = 0;

		var k = 0;

		// Select all values

		[FMP-InlineAction: -db=empdeptposn.fp5, -lay=web, -sortfield=department, -sortfield=position, -sortfield=employee, -max=all, -findall]

		// Assign to Arrays

		[FMP-Record]

		aDept[i++] = "[FMP-Field: department]";

		aPosn[j++] = "[FMP-Field: position]";

		aEmp[k++] = "[FMP-Field: employee]";

		[/FMP-Record]

		// Constuct an Array of the Unique Department names by using a ValueList	

		aMain = new Array();

		[FMP-ValueList:department]

		aMain["[FMP-ValueListitem"] = null;

		[/FMP-ValueList]

		[/FMP-InlineAction]

	</script>

</head>

This code uses an InLineAction to return all of the data. It is then assigned to Javascript arrays. A ValueList is also used to start the setup of the Main array. This ValueList should be created on the Department field and applied on the Layout.

Hope this gets you started.

Garry

January 26, 200322 yr

Hey Garry,

Okay! I got the arrays populated with the information from FileMaker (I didn't quite understand the reason for assigning a "null" value to the Department ValueListItem...maybe you could explain a little more in depth). Anyway, it seems to be functioning correctly. Now, if I understand correctly, I need to attach the arrays together, then populate the popups. At what point do we eliminate the duplicates in the "Department" and "Position" popups? Hope you're having a great time. Talk to you soon.

-Jeff

January 26, 200322 yr

Jeff,

The nulls are just place-holders; we will be inserting Position and Employee arrays into each of the Department cells. How we do that I am not exactly sure yet. We will have to do some tuning along the way.

I will have a chance to look at it some more later today.

All the best.

Garry

January 26, 200322 yr

Garry,

Thanks again for all your help on this. I always find it so exciting to find new and better ways to do things with FileMaker. I've been reading the JavaScript book you suggested to Nate for about a week now and have been very challenged by it. Thank you, as well, for that information. Have a safe trip back.

Talk to you soon,

Jeff

January 29, 200322 yr

Jeff,

Here is a little bit more. I am currently working on the allocation to the aMain associative array.

function selPosition()

   {

   alert (document.myform.department.value);

   };

</script>

</head>

<body>....



<form method="post" action="#" name="myform">

<select name="department" onchange="Javascript:selPosition();">

<option value="">Please Select a Department</option>

	[FMP-ValueList:department]

	<option value="[FMP-ValueListItem]">[FMP-ValueListItem]</option>

	[/FMP-ValueList]

</select><br>

<select name="position" onchange="Javascript:selEmployee();">

<option value="">Please Select a Position</option>

</select><br>

<select name="emp_name">

<option value="">Please Select an Employee</option>

</select></form>

This will give you an idea how the Select statements are set-up.

All the best.

Garry

January 29, 200322 yr

Hey Garry,

As you well know, that worked like a charm. But I have one question, is the purpose of the "alert" in: "alert (document.myform.department.value)" for the "selPosition" function to reset the Position field if the user has already selected a Position and then went back and changed the Department (error correction)? Or am I way off base.

The next step is the "doozy!" I am anxiously waiting to see how you do it because I have no clue!

How was your trip?

Still crazy here in Vegas,

Jeff

January 29, 200322 yr

Jeff,

The "alert" is just for testing that the "onchange" is working. Here are those functions with some code to change the contents of the Select lists.

	function selPosition()

			{

			with (document.myform)

                          {

			var nIndex = department.selectedIndex ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Position and Employee

				for (i = position.options.length; i > 0; i--) {

					position.options[i] = null ; } ;

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				position.options[1] = new Option("Positions Appear Here") ;

				};

                           };

			};

		function selEmployee()

			{

			with (document.myform)

                          {

			var nIndex = position.selectedIndex ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Employee

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				emp_name.options[1] = new Option("Employees Appear Here") ;

				};

                           };

			};

	</script>

</head>

The hard part is the assigning of the Position and Employee values to the aMain associative array. Still working on an elegant solution for that

All the best.

Garry

January 29, 200322 yr

I'm settling back into the slow life here in the hills with the hippies. Camomile tea and Rainbow cake in the afternoons

I've been to Las Vegas four times. NAB conference! I like the place

All the best.

Garry

January 30, 200322 yr

Hey Garry,

I love Vegas too! Except for all the tourists! (heh heh)

Anyway, I plugged in the next code that you sent. I must admit it lost me a little. So I'm cracking open the book and going to break it down line by line to figure it out.

Are you coming to NAB this year? If so, let me know. I'll hook you up with tickets to shows and such. Thanks again for all your help on this. I can't relay how much I've learned over the last few months reading your hundreds of posts. You really scare me sometimes (but in a good way ).

I figured the tying together of the arrays would be challenging. I can't wait to see how you do it!

Talk to you soon,

Jeff

February 2, 200322 yr

Jeff,

Here is the next installment

<head>

	<title>Array Test</title>

	<meta name="generator" content="BBEdit 7.0.1">

	<script>

		// Declare Variables

		var aDept = new Array();

		var aPosn = new Array();

		var aEmp = new Array();

		var i = 0;

		var j = 0;

		var k = 0;

		// Select all values

		[FMP-InlineAction: -db=employees.fp5, -lay=web, -sortfield=department, -sortfield=position, -sortfield=emp_name, -max=all, -findall]

		// Assign to Arrays

		[FMP-Record]

		aDept[i++] = "[FMP-Field: department]";

		aPosn[j++] = "[FMP-Field: position]";

		aEmp[k++] = "[FMP-Field: emp_name]";

		[/FMP-Record]

		// Constuct an Array of the Unique Department names by using a ValueList	

		aMain = new Array();

		[FMP-ValueList:department]

		aMain["[FMP-ValueListitem]"] = "empty";

		[/FMP-ValueList]

		[/FMP-InlineAction]

		

		// Load the Main Array		

		var x = 0 ;

		var aTempPosn = new Array() ;

		var aTempEmp = new Array() ;

		for ( z = 0; z < aDept.length; z++)

			{

			sDept = aDept[z] ;

			sPosn = aPosn[z] ;

			sEmp = aEmp[z] ;

			// Add Emp while Posn is the same!!!

			if ((z == 0) || (sPosn == aPosn[(z-1)]))

				{

				aTempEmp[x] = sEmp;

				x = x++ ;

				}

			else

				{

				aTempPosn[aPosn[(z-1)]] = aTempEmp;

				aMain[aDept[(z-1)]] = aTempPosn;

				aTempPosn[aPosn[(z-1)]] = aTempEmp;				

				var aTempEmp = new Array() ;

				x = 0 ;

				aTempEmp[x] = sEmp;

				};

			};

		aTempPosn[sPosn] = aTempEmp;

		aMain[sDept] = aTempPosn;

			

		// Update Position ValueList when Department is changed.

		function selPosition()

			{

			with (document.myform)

			{

			var nIndex = department.selectedIndex ;

			var sIndex = department.value ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Position and Employee

				for (i = position.options.length; i > 0; i--) {

					position.options[i] = null ; } ;

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				for (a=1; a < 2;a++)

					{

					position.options[a] = new Option(aMain[sIndex]) ;

					position.options[a].value = aMain[sIndex] ;

					};

				}

			else

				{

				for (i = position.options.length; i > 0; i--) {

					position.options[i] = null ; } ;

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				};

			};

			};



		// Update Employee ValueList when Position is changed.

		function selEmployee()

			{

			with (document.myform)

			{

			var nIndex = position.selectedIndex ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Employee

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				emp_name.options[1] = new Option("Employees Appear Here") ;

				}

			else

				{

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;				

				};

			};

			};

	</script>

</head>

<body>Hello World....<br>

<form method="post" action="#" name="myform">

<select name="department" onchange="Javascript:selPosition();">

<option value="">Please Select a Department</option>

		[FMP-ValueList:department]

		<option value="[FMP-ValueListItem]">[FMP-ValueListItem]</option>

		[/FMP-ValueList]

</select><br>

<select name="position" onchange="Javascript:selEmployee();">

<option value="">Please Select a Position</option>

</select><br>

<select name="emp_name">

<option value="">Please Select an Employee</option>

</select></form><br>

This script sets-up the aMain array. The next part which needs to be completed is the allocation of the appropriate array elements to the ValueLists.

I don't think that I will be in Las Vegas this year Unless I win the lotto, or I complete some of my software for Film & Television post-production. Maybe next year

All the best.

Garry

February 3, 200322 yr

Hey Garry,

Well, I plugged it into the web page and booted it all up and it seems to be working (of course, with no values in the second and third popups except for the test field, it was hard to see if its working). Of course, I know that it IS working because you never do anything wrong! I can't wait for the next step. (yes, drool is actually coming out of my mouth). I'm going to chomp on this section for the rest of the night to try to understand it all. Sorry to hear that you won't be able to make NAB this year. But, you definitely have a raincheck for a show in Vegas next time you come over. Best of luck with your production software. I'm sure it's amazing and I'd like to hear more about it. Talk to you soon,

-Jeff

February 8, 200322 yr

Jeff,

Here it is

<html>

<head>

	<title>Array Test</title>

	<meta name="generator" content="BBEdit 7.0.1">

	<script>

		// Declare Variables

		var aDept = new Array();

		var aPosn = new Array();

		var aEmp = new Array();

		var i = 0;

		var j = 0;

		var k = 0;

		// Select all values

		[FMP-InlineAction: -db=employees.fp5, -lay=web, -sortfield=department, -sortfield=position, -sortfield=emp_name, -max=all, -findall]

		// Assign to Arrays

		[FMP-Record]

		aDept[i++] = "[FMP-Field: department]";

		aPosn[j++] = "[FMP-Field: position]";

		aEmp[k++] = "[FMP-Field: emp_name]";

		[/FMP-Record]

		// Constuct an Array of the Unique Department names by using a ValueList	

		aMainDept = new Array();

		[FMP-ValueList:department]

		aMainDept["[FMP-ValueListitem]"] = new Array();

		[/FMP-ValueList]

		[/FMP-InlineAction]

		

		// Load the Main Arrays		

		var aTempEmp = new Array();

		var aMainPosn = new Array();

		sDept = aDept[0];

		sDeptPrev = aDept[0];

		sPosn = aPosn[0];

		sPosnPrev = aPosn[0];

		sEmp = aEmp[0];

		aTempEmp[0] = sEmp;

		var q = 0;

		var p = 0;

		for ( z = 1; z < aDept.length; z++)

			{

			sDept = aDept[z];

			sPosn = aPosn[z];

			sEmp = aEmp[z];

			// Add Emp while Posn is the same!!!

			if (sPosnPrev == sPosn)

				{

				q = q + 1;

				aTempEmp[q] = sEmp;

				}

			else

				{

				if (sDeptPrev == sDept)

					{

					aMainDept[sDept][p] = sPosnPrev;

					p = p + 1;

					}

				else

					{

					aMainDept[sDeptPrev][p] = sPosnPrev;

					sDeptPrev = sDept;

					p = 0;

					};				

				aMainPosn[sPosnPrev] = aTempEmp;

				var aTempEmp = new Array();

				aTempEmp[0] = sEmp;

				q = 0 ;

				sPosnPrev = sPosn;

				};

			};

		aMainDept[sDept][p] = sPosn;

		aMainPosn[sPosn] = aTempEmp;

			

		// Update Position ValueList when Department is changed.

		function selPosition()

			{

			with (document.myform)

			{

			var nIndex = department.selectedIndex ;

			var sIndex = department.value ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Position and Employee

				for (i = position.options.length; i > 0; i--) {

					position.options[i] = null ; } ;

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				for (a=0; a < aMainDept[sIndex].length; a++)

					{

					position.options[a+1] = new Option(aMainDept[sIndex][a]) ;

					position.options[a+1].value = aMainDept[sIndex][a] ;

					};

				}

			else

				{

				for (i = position.options.length; i > 0; i--) {

					position.options[i] = null ; } ;

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				};

			};

			};



		// Update Employee ValueList when Position is changed.

		function selEmployee()

			{

			with (document.myform)

			{

			var nIndex = position.selectedIndex ;

			var sIndex = position.value ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Employee

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;

				for (a=0; a < aMainPosn[sIndex].length; a++)

					{

					emp_name.options[a+1] = new Option(aMainPosn[sIndex][a]) ;

					emp_name.options[a+1].value = aMainPosn[sIndex][a] ;

					};

				}

			else

				{

				for (i = emp_name.options.length; i > 0; i--) {

					emp_name.options[i] = null ; } ;				

				};

			};

			};

	</script>

</head>

<body>Hello World....<br>

<form method="post" action="#" name="myform">

<select name="department" onchange="Javascript:selPosition();">

<option value="">Please Select a Department</option>

		[FMP-ValueList:department]

		<option value="[FMP-ValueListItem]">[FMP-ValueListItem]</option>

		[/FMP-ValueList]

</select><br>

<select name="position" onchange="Javascript:selEmployee();">

<option value="">Please Select a Position</option>

</select><br>

<select name="emp_name">

<option value="">Please Select an Employee</option>

</select></form>

</body>

</html>

It has not been optimized. It has had some testing under certain assumptions about the data structure. It works fine; so far!

All the best.

Garry

February 9, 200322 yr

Jeff,

Here is a version with some space and loop optimization:

<html>

<head>

	<title>Array Test</title>

	<meta name="generator" content="BBEdit 7.0.1">

	<script>

		// Declare Variables

		var aDept = new Array();

		var aPosn = new Array();

		var aEmp = new Array();

		var i = 0;

		var j = 0;

		var k = 0;

		// Select all values

		[FMP-InlineAction: -db=employees.fp5, -lay=web, -sortfield=department, -sortfield=position, -sortfield=emp_name, -max=all, -findall]

		// Assign to Arrays

		[FMP-Record]aDept[i++]="[FMP-Field: department]";aPosn[j++]="[FMP-Field: position]";aEmp[k++]="[FMP-Field: emp_name]";[/FMP-Record]

		// Constuct an Array of the Unique Department names by using a ValueList	

		aMainDept = new Array();

		[FMP-ValueList:department]aMainDept["[FMP-ValueListitem]"]=new Array();[/FMP-ValueList]

		[/FMP-InlineAction]

		// Load the Main Arrays		

		var aTempEmp = new Array();

		var aMainPosn = new Array();

		sDept = aDept[0];

		sDeptPrev = aDept[0];

		sPosn = aPosn[0];

		sPosnPrev = aPosn[0];

		sEmp = aEmp[0];

		aTempEmp[0] = sEmp;

		var q = 0;

		var p = 0;

		nDepLen = aDept.length;

		for ( z = 1; z < nDepLen; z++)

			{

			sDept = aDept[z];

			sPosn = aPosn[z];

			sEmp = aEmp[z];

			// Add Emp while Posn is the same!!!

			if (sPosnPrev == sPosn)

				{

				q = q + 1;

				aTempEmp[q] = sEmp;

				}

			else

				{

				if (sDeptPrev == sDept)

					{

					aMainDept[sDept][p] = sPosnPrev;

					p = p + 1;

					}

				else

					{

					aMainDept[sDeptPrev][p] = sPosnPrev;

					sDeptPrev = sDept;

					p = 0;

					};				

				aMainPosn[sPosnPrev] = aTempEmp;

				var aTempEmp = new Array();

				aTempEmp[0] = sEmp;

				q = 0 ;

				sPosnPrev = sPosn;

				};

			};

		aMainDept[sDept][p] = sPosn;

		aMainPosn[sPosn] = aTempEmp;

			

		// Update Position ValueList when Department is changed.

		function selPosition()

			{

			with (document.myform)

			{

			var nIndex = department.selectedIndex ;

			var sIndex = department.value ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Position and Employee

				nPosnLen = position.options.length;

				for (i = nPosnLen; i > 0; i--) { position.options[i] = null ; } ;

				nEmpLen = emp_name.options.length

				for (i = nEmpLen; i > 0; i--) { emp_name.options[i] = null ; } ;

				nDepLen = aMainDept[sIndex].length;

				for (a=0; a < nDepLen; a++)

					{

					position.options[a+1] = new Option(aMainDept[sIndex][a]) ;

					position.options[a+1].value = aMainDept[sIndex][a] ;

					};

				}

			else

				{

				nPosnLen = position.options.length;

				for (i = nPosnLen; i > 0; i--) { position.options[i] = null ; } ;

				nEmpLen = emp_name.options.length;

				for (i = nEmpLen; i > 0; i--) { emp_name.options[i] = null ; } ;

				};

			};

			};

		// Update Employee ValueList when Position is changed.

		function selEmployee()

			{

			with (document.myform)

			{

			var nIndex = position.selectedIndex ;

			var sIndex = position.value ;

			if (nIndex > 0)

				{

				// Clear the existing Options of Employee

				nEmpLen = emp_name.options.length;

				for (i = nEmpLen; i > 0; i--) { emp_name.options[i] = null ; } ;

				nPosnLen = aMainPosn[sIndex].length;

				for (a=0; a < nPosnLen; a++)

					{

					emp_name.options[a+1] = new Option(aMainPosn[sIndex][a]) ;

					emp_name.options[a+1].value = aMainPosn[sIndex][a] ;

					};

				}

			else

				{

				nEmpLen = emp_name.options.length;

				for (i = nEmpLen; i > 0; i--) { emp_name.options[i] = null ; } ;				

				};

			};

			};

	</script>

</head>

<body>Hello World....<br>

<form method="post" action="#" name="myform">

<select name="department" onchange="Javascript:selPosition();">

<option value="">Please Select a Department</option>

		[FMP-ValueList:department]

		<option value="[FMP-ValueListItem]">[FMP-ValueListItem]</option>

		[/FMP-ValueList]

</select><br>

<select name="position" onchange="Javascript:selEmployee();">

<option value="">Please Select a Position</option>

</select><br>

<select name="emp_name">

<option value="">Please Select an Employee</option>

</select></form>

</body>

</html>

All the best.

Garry

February 9, 200322 yr

Garry,

OH (dramatic pause) MY (dramatic pause) GAWD (dramatic pause)!

How amazing is that! It worked first time out. You are awesome (just picture me bowing down before you)!

Okay, just two little follow up questions.

First, since these fields will be accessed quite a bit, is it possible to load the arrays into say a fixed frame (like a banner) so that it can be accessed multiple times within a single session (this would cut down on the load wait time and bandwidth.

Second, when I go to the page that the popups are on, can I have some sort of java "alert" that will tell the user that the employee information is loading.

I owe you a big rainbow cake (if I only knew what rainbow cake was). Once again, thanks for all your help. I'm in awe of your amazing technological skill. I look forward to meeting you one day in Vegas.

Talk to you soon,

Jeff

February 9, 200322 yr

Yahoo! it worked

Yes, you can have the arrays and functions in one Frame and have them accessed by another Frame. I have a similar application for people building quotes. One Frame has the product categories, another Frame has the Products, and the thrid Frame has the quote. Each product has a button which allows it to be added to the quote.

You could use some sort of "pre-page" with "Loading..." as the text. Or, you may be able to use DHTML Layers (or Frames) to do this.

Looking forward to Las Vegas

All the best.

Garry

February 10, 200322 yr

Garry,

Once again into the fray! See I gave you a whole day off! Okay. I got the arrays to load into my static left frame called "navigation" and the "myform" that I am creating is in a sub frame on the right bottom called "body". I'm just not sure which item points to which to get them to talk to each other. Do I add "top.navigation.Javascript:selPosition();" to the popup lists to get them to see the data in the body frame? or do I add "(top.body.document.myform)" to the navigation frame to send the data to the form? or am I just flailing my arms around in the air like a crazy person trying to look like I know what I'm doing...you decide.

Thanks for any input.

-Jeff

February 10, 200322 yr

To "talk" to the DOM in another Frame you use paths like this:

top.body.document.myform

or

top.navigation.selPosition()

(You can usually drop the "top.")

Hope this helps.

Garry

February 11, 200322 yr

Garry,

So after wasting a WHOLE night to find out that I had some hellish script that was screwing up my data, I got the "new" entry form to work just fine! And no, I really don't enjoy sleeping that much. Which leads me into my next question...while working on my "edit" form, I found out two things. First, that if I insert the pre-existing data into the popup field, the arrays treat it like a separate piece of data (i.e. if you have already chosen "Rainbow Cake" it appears at the top of the list AND in the list where it normally would be). The bad part is that because it doesn't recognize the existing data, the conditional arrays don't connect. Is there some secret to fixing this? Or am I just up a creek?

Second, when I return multiple records to the same "edit" page, the conditional arrays don't work. And I can't figure out why. I'm assuming it's because they can't all pull the same array name at the same time on the same page. Is this true? Am I asking too much?

Oh fount of great knowledge. Any guidance would be appreciated like water in the desert. (Yeah, that's where I live...in the desert!)

Talk to you soon,

-Jeff

February 11, 200322 yr

Jeff,

A number of ways exist to have the "drop-downs" display the value of a record.

Do you have a listing page and the three drop-downs adjacent to each of the listed records? If so, the <selects> will need to have different names, or no names and referenced by number; e.g. document.myform.elements[23] (This number can be passed to the functions as a parameter.)

All the best.

Garry