Christine,
I love a good puzzle, although "many, many, hundreds of checkboxes" scares
me. Anyway, how about this:
Create a New Form to hold information about the checkbox fields:
Field ID
Field Label
Field Name
Create a Table on your Request form that references the new form above, with
the following columns:
col_fieldid
col_fieldlabel
col_fieldname
Create some display only fields on your Request form:
char - ztmp_currentfieldid
char - ztmp_currentfieldvalue (for this example, we'll say this
field has a fieldid of 536870002)
char - ztmp_currentfieldlabel
Create the filters and the guide to hold them:
Filter guide
Filter 1`!: (note the phasing override)
Action 1: (sets temp fields from your table of fields)
Set ztmp_currentfieldid = col_fieldid
Set ztmp_currentfieldlabel = col_fieldlabel
Action 2: Run Process:
Application-Copy-Field-Value
536870002 $ztmp_currentfieldid$ (note: this takes the value from the field
that has the fieldid that is stored in $ztmp_currentfieldid$, and copies it
to the ztmp_currentfieldvalue)
Filter 2`!: (note the phasing override)
Run if: $ztmp_currentfieldvalue$ != $NULL$
Action 1: set summary = summary + "|" +
$ztmp_currentfieldlabel$ + ": " + $ztmp_currentfieldvalue$
Create a filter to call the guide:
Run If: $record summary$ = $NULL$
Action 1: Call guide, with Table Loop checked, and the new table
above selected.
And then a final filter to do an LTRIM or substring to remove the intial
carriage return that will be there
This has the benefit of little code to maintain, and makes the list of
checkboxes data-driven. When you add a new checkbox, you don't need to
update any code, just add a record to that first form.
Hopefully that gives you some other options to think about.
Thad Esser
Remedy Developer
On Wed, Nov 3, 2010 at 11:33 AM, Christine <christineperryi...@yahoo.com>wrote:
> I have a form with many, many checkboxes. When a person submits the
> form I want to walk just this record, evaluate each field for a value,
> if that value is != $NULL$ then I want to write the field title and
> the field value to a single, summary field I’m calling Record
> Summary.
>
> Imagine a form with 4 checkboxes for color choices
>
> Field names = Red, Blue, Green Black
> Field titles = “Color Red”, “Color Blue”, “Color Green” and “Color
> Black”
> The field attributes are correspondingly “Bright Red”, “Dark Blue”,
> “Faded Green” and “ReallyBlack”. This is the value that is written to
> the table when the checkbox is checked.
>
> If the person submitting the record checks only the “Color Red” and
> “Color Black” boxes I want to write this to the summary field:
> Color Red: Bright Red
> Color Black: Really Black
>
> I have a real kluge of this based on a filter working in dev. However,
> it is does not evaluate each field for a non-null value. I check to
> see if the Record Summary field is empty, if it is then I use this Set
> Field action on the Record Summary field: “$Red$ + "; " +”|” + $Blue
> $) + "; " +”|” + $Green$ + "; " +”|” $Black$ + "; " which
> results in:
>
> Bright Red,
> ,
> ,
> Really Black
>
> My form has hundreds of checkboxes for people to request AD Accounts,
> hardware, general software and Oracle Apps Responsibilities (this is
> the reason for the length of the form). As you can see using my kluge
> will result in an ugly text field for the help desk person to review.
> Many lines would just have the commas in them where the users didn’t
> make any choices. That is so even when I combine several checkbox
> field values on one line.
>
> Plus, the processing just isn’t that elegant.
>
> Can someone direct me to the correct process to use for this? Is there
> an example of this in a ACTL, Filter or Guide for me to review that
> might already be doing something like this? I keep reading the
> workflow manual about guides and looping and this just isn't clicking
> with me. (We have ARS 7.1.00, Change and Incident 7.0.03, and SRM 2.2)
>
> Thanks,
> Christine
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
