Question

Actually two questions...

I'm using a similar application as the FeatureRequest tool in the Web Codev (if you can't find it, check "Create New Topic" in left navigation bar), but mine is adding software applications. After filling out the form, data will get transfered to a template via "SCRIPTURLPATH". That's working great so far. But I also wanna transfer one data field (the topic name, which is the first field in my form) to the topic WebPreferences, where I've set a new variable, and add an entry the comma separated list.

On other forms I want to load that variable for another multiple choice field in alphabetical order, where the user can select one or multiple categories. Loading the list is also working, but how can i get the items in alphabetical order?

Environment

-- ThomasEsau - 21 Nov 2006

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

I just found it... "$LISTSORT()" of SpreadSheetPlugin is the answer on my second questions.

-- ThomasEsau - 21 Nov 2006

I do not understand why you need to update WebPreferences with each new topic you create. To me it looks like you get the functionality with a dynamic report, e.g. do a SEARCH that returns the list of all topics of this type, identified for example with the name of the form. Example that returns a comma separated list of topics: %SEARCH{ "META:FORM.*MyForm" type="regex" excludetopic="MyFormTemplate" nonoise="on" format="$topic" separator=", " }

-- PeterThoeny - 22 Nov 2006

Good idea! Thanks!

-- ThomasEsau - 22 Nov 2006