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?