Hi Again,

On Mar 30, 2008, at 7:35 PM, Jane Reeder wrote:

If there is more than one value it be

Set Field [ Activities Billing::Activity; "Value1¶Value2¶Value3" ]


I think I tried that, but I'll take another look at it.

What I wound up with, last night, was a loop function where I took each line in the list and added it to the SetField individually, concat'ing the elements from the list of values, one at a time. Kludge, but it works.

On 3/30/08 6:16 PM, "Chuck Pelto" <[EMAIL PROTECTED]> wrote:

Hi Jane,

On Mar 30, 2008, at 7:04 PM, Jane Reeder wrote:
If you had a value list of yes and no and wanted a check by yes you would do a set field with a value of yes and then an X would appear next to yes.


I tried something like that...

SetField ( myField ; $selectedValues ) // Where $selectedValues was a list of values I wanted set

Didn't work.

I'll go back and review this. Do some more testing. I THOUGHT I was on the right track, but when it didn't work, I was somewhat flummoxed.

Thanks,

Chuck

On 3/30/08 5:45 PM, "Chuck Pelto" <[EMAIL PROTECTED]> wrote:


To put it another way....

....what call will work to put an "X" in a checkbox of a ValueList populated field from a ScriptMaker script?

 Regards,

 Chuck



 On Mar 30, 2008, at 4:22 PM, Chuck Pelto wrote:


 On Mar 30, 2008, at 4:07 PM, Richard S. Russell wrote:

When you say "I have a list of terms", where is the list? Is it already in the database? Does it exist outside the database and you're looking to import it?


The list of items is derived by collecting the data form a table that holds the information that goes into the ValueList.

When you say "BASED ON items in the value list", does that mean they're not exactly the same as the items in the value list? (For example, if the value list contained values like "Ford", "Chrysler", and "General Motors", would your list of terms have things like "Mercury", "Dodge", and "Chevrolet"?)


 ValueList (Models):
 MercuryDodgeChevroletFord

 Someone owns two cars:
 MercuryFord
 The List of Items consists of:
 MercuryFord

So, the field, CarList has the information from the ValueList (Models)
 ☐ Mercury☐ Dodge☐ Chevrolet☐ Ford
I want to have the checkboxes for Mercury and Ford checked. So that the ValueList (Models) in the checkbox field of CarList looks like THIS:
  ☒Mercury☐ Dodge☐ Chevrolet☒Ford
 >From using a ScriptMaker script.
 Hope that helps....
 Regards,
 Chuck


Examples would make it easier to understand the question.



On 2008 Mar 30, at 16:52, Chuck Pelto wrote:



Here's a situation....

....I have a ValueList of items. It is in a field that is set to use CheckBoxes.

I have a list of terms based on items in the ValueList. The items in the list of terms are separated by carriage returns.

 Here is a question....

How do I get the items in the list of terms to get a check-mark to appear in the check-box field for the appropriate item in the ValueList associated with that field?













Reply via email to