Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Dynamic Dropdown values for Update page

Dynamic Dropdown values for Update page

Thread began 7/21/2014 9:43 am by iainmacdonald331081 | Last modified 7/23/2014 11:55 am by Jason Byrnes | 4908 views | 18 replies |

7/21/2014 9:43 am | #1 iainmacdonald331081

Dynamic Dropdown values for Update page

This is the last thing I haven't quite got with the dynamic drop downs. Basically to get them to work and how the current values for a record on the update page.

I've attached the file, and added some details below.

7/21/2014 9:56 am | #2 iainmacdonald331081

More info

Attached Files

index_new.zip

7/21/2014 10:22 am | #3 Jason ByrnesWebAssist

you need to use the Set Selected In List behavior to set the parent using list using the corresponding column from the WADAlodges recordset on the body tags on load event

also add the Populate list from array behavior to the onload event to populate the child list and another instance of the set selected behavior to set the child list.

7/21/2014 11:32 am | #4 iainmacdonald331081

Thanks Jason - I have added the Set Selected In List behaviour, but only to the Continent field from the WADAlodges recordset. How do I apply / make use of any On Load event on the body tag?

See screenshot.

Attached Files

wapng.zip

7/21/2014 12:34 pm | #5 Jason ByrnesWebAssist

select the body tag in the tag selector when you add the set selected behavior and select the onload event.

7/21/2014 5:02 pm | #6 iainmacdonald331081

Sorry Jason - I'm not getting this.

I tried that, and have the line:

<body onLoad="WA_setSelectionsInChildList(MM_findObj('Parent'),<?php echo $row_WADAlodges['Continent']; ?>)">

But still not showing the current value.

7/22/2014 6:44 am | #7 Jason ByrnesWebAssist

I'll need to troubleshoot directly, see the private message section.

7/22/2014 7:04 am | #8 iainmacdonald331081

Thanks Jason.

Details below.

7/22/2014 7:19 am | #9 Jason ByrnesWebAssist

in the onload event, you are using a column named Category:
onload="WA_setSelectionsInChildList(MM_findObj('Parent'),<?php echo $row_WADAnominations['Category']; ?>)"

using var_dump to write the contents of the WADAnominations recordset, i do not see a column being returned named Category. I see a column named CategoriesFullID, is that the one that should be used?

looks like it, if i change it to:
onload="WA_setSelectionsInChildList(MM_findObj('Parent'),<?php echo $row_WADAnominations['CategoriesFullID']; ?>)"

on load selects the Best Walking Safari form the category

7/22/2014 8:44 am | #10 iainmacdonald331081

Thanks Jason - sorry I missed that - I've been changing the data structure quite a bit with all this, breaking them out into continents and countries, and having them separate, when they used to be part of the category.

All looks like its working, and also with the short name, so thanks you for spotting that.

I did notice one other odd thing - if you search the site for 'Zarafa Camp' which has a lot of nominations over a few years, the year drop down in the update page isn't always showing the correct year.

It looks like its OK for 2015 and 2014, but all the others are showing 2008.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.