problem with conditional valuelist 
Author Message
 problem with conditional valuelist

One field (employee-status) has values: on duty, off duty, {*filter*},
company employe. Values are chosen by checkmarkboxes.

I want to display an entrylist (valuelist) with names of employees who
are both 'on duty' and '{*filter*}'
The valuelist comes from a field that sets the names of employees to
false or true. But how to define the condition "if (employeestatus ="on
duty" (((combined with)))) "{*filter*}";employee-name;"")

Purpose: in a timecard-solution only on-duty {*filter*}rs should log in.

I've tried the AND expression, the "return-character" but it didn't work.

Anyone any suggestion?

Dick van der Kolk



Thu, 26 Jun 2003 05:09:10 GMT
 problem with conditional valuelist

Don't quite follow the whole description, but I wonder if you are not
missing "&", which is the operator used for appending values to one another
(concatenation). If that isn't it, please reply with a bit more about how
"The valuelist comes from a field that sets the names of employees to false
or true..".

--
John Weinshel
datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634



Quote:
> One field (employee-status) has values: on duty, off duty, {*filter*},
> company employe. Values are chosen by checkmarkboxes.

> I want to display an entrylist (valuelist) with names of employees who
> are both 'on duty' and '{*filter*}'
> The valuelist comes from a field that sets the names of employees to
> false or true. But how to define the condition "if (employeestatus ="on
> duty" (((combined with)))) "{*filter*}";employee-name;"")

> Purpose: in a timecard-solution only on-duty {*filter*}rs should log in.

> I've tried the AND expression, the "return-character" but it didn't work.

> Anyone any suggestion?

>{*filter*} van der Kolk



Thu, 26 Jun 2003 06:44:52 GMT
 problem with conditional valuelist
Make the value list come from a calc field rather than the Employee Name field:

If (employee-status = "on duty" or employee-status = "{*filter*}",
EmployeeNameField, "")

In English:  If the employee is on duty or {*filter*}, show his name,
otherwise do nothing.

Now only the names of on duty or {*filter*} employees will appear in the
value list.

--
Bridget Eley

Quote:

> One field (employee-status) has values: on duty, off duty, {*filter*},
> company employe. Values are chosen by checkmarkboxes.

> I want to display an entrylist (valuelist) with names of employees who
> are both 'on duty' and '{*filter*}'
> The valuelist comes from a field that sets the names of employees to
> false or true. But how to define the condition "if (employeestatus ="on
> duty" (((combined with)))) "{*filter*}";employee-name;"")

> Purpose: in a timecard-solution only on-duty {*filter*}rs should log in.

> I've tried the AND expression, the "return-character" but it didn't work.

> Anyone any suggestion?

>{*filter*} van der Kolk



Thu, 26 Jun 2003 12:51:51 GMT
 problem with conditional valuelist
Hello Bridget,

Your hammering the nail on the head:

I need BOTH the arguments to be true: If (employee-status = "on duty"
AND employee-status = "{*filter*}",

Quote:
> EmployeeNameField, "")

Though the syntax seems correct, it-just-won't-work. The values "on
duty" and "{*filter*}" come from a checkboxed field.

In English: Show the names of the {*filter*}rs who are on duty.

Can you come up with another suggestion?

Dick van der Kolk

Quote:

> Make the value list come from a calc field rather than the Employee Name field:

> If (employee-status = "on duty" or employee-status = "{*filter*}",
> EmployeeNameField, "")

> In English:  If the employee is on duty or {*filter*}, show his name,
> otherwise do nothing.

> Now only the names of on duty or {*filter*} employees will appear in the
> value list.

> --
> Bridget Eley


> > One field (employee-status) has values: on duty, off duty, {*filter*},
> > company employe. Values are chosen by checkmarkboxes.

> > I want to display an entrylist (valuelist) with names of employees who
> > are both 'on duty' and '{*filter*}'
> > The valuelist comes from a field that sets the names of employees to
> > false or true. But how to define the condition "if (employeestatus ="on
> > duty" (((combined with)))) "{*filter*}";employee-name;"")

> > Purpose: in a timecard-solution only on-duty {*filter*}rs should log in.

> > I've tried the AND expression, the "return-character" but it didn't work.

> > Anyone any suggestion?

> >{*filter*} van der Kolk



Fri, 27 Jun 2003 00:13:29 GMT
 problem with conditional valuelist
Whoops!  Those darn 'and' and 'ors' keep tripping me up tonight.

Try this:

If (Pattern Count (employee-status, "on duty") = 1 and Pattern Count
(employee-status, "{*filter*}") = 1, EmployeeNameField, "")

Bridget

Quote:

> Hello Bridget,

> Your hammering the nail on the head:

> I need BOTH the arguments to be true: If (employee-status = "on duty"
> AND employee-status = "{*filter*}",
> > EmployeeNameField, "")

> Though the syntax seems correct, it-just-won't-work. The values "on
> duty" and "{*filter*}" come from a checkboxed field.

> In English: Show the names of the {*filter*}rs who are on duty.

> Can you come up with another suggestion?

>{*filter*} van der Kolk


> > Make the value list come from a calc field rather than the Employee
Name field:

> > If (employee-status = "on duty" or employee-status = "{*filter*}",
> > EmployeeNameField, "")

> > In English:  If the employee is on duty or {*filter*}, show his name,
> > otherwise do nothing.

> > Now only the names of on duty or {*filter*} employees will appear in the
> > value list.

> > --
> > Bridget Eley



> > > One field (employee-status) has values: on duty, off duty, {*filter*},
> > > company employe. Values are chosen by checkmarkboxes.

> > > I want to display an entrylist (valuelist) with names of employees who
> > > are both 'on duty' and '{*filter*}'
> > > The valuelist comes from a field that sets the names of employees to
> > > false or true. But how to define the condition "if (employeestatus ="on
> > > duty" (((combined with)))) "{*filter*}";employee-name;"")

> > > Purpose: in a timecard-solution only on-duty {*filter*}rs should log in.

> > > I've tried the AND expression, the "return-character" but it didn't work.

> > > Anyone any suggestion?

> > >{*filter*} van der Kolk



Fri, 27 Jun 2003 00:29:45 GMT
 problem with conditional valuelist
Hello Bridget,

Sorry for keeping you up last night.

Finally, I found (an/the) answer: I should use the Case-function.
This one does the trick:

Case(employeestatus="{*filter*}"&"?"&"on duty";employee-name;"")    
(((added with additional conditions)))

Notice the "carriagereturn". It turns out to be important also to
mention the sequence of the values:

"{*filter*}" & "on duty" selected in that order differs from "on duty" & "{*filter*}"
This matters when selecting values by checkboxes: when checked you will
never know the selecting sequence.

SO: All the possible combinations of values must be mentioned in the Case-condition.

Thank you for sparring.

Dick van der Kolk
Delta Events
The Netherlands

________________________________________________________________________

Quote:

> Whoops!  Those darn 'and' and 'ors' keep tripping me up tonight.

> Try this:

> If (Pattern Count (employee-status, "on duty") = 1 and Pattern Count
> (employee-status, "{*filter*}") = 1, EmployeeNameField, "")

> Bridget


> > Hello Bridget,

> > Your hammering the nail on the head:

> > I need BOTH the arguments to be true: If (employee-status = "on duty"
> > AND employee-status = "{*filter*}",
> > > EmployeeNameField, "")

> > Though the syntax seems correct, it-just-won't-work. The values "on
> > duty" and "{*filter*}" come from a checkboxed field.

> > In English: Show the names of the {*filter*}rs who are on duty.

> > Can you come up with another suggestion?

> >{*filter*} van der Kolk


> > > Make the value list come from a calc field rather than the Employee
> Name field:

> > > If (employee-status = "on duty" or employee-status = "{*filter*}",
> > > EmployeeNameField, "")

> > > In English:  If the employee is on duty or {*filter*}, show his name,
> > > otherwise do nothing.

> > > Now only the names of on duty or {*filter*} employees will appear in the
> > > value list.

> > > --
> > > Bridget Eley



> > > > One field (employee-status) has values: on duty, off duty, {*filter*},
> > > > company employe. Values are chosen by checkmarkboxes.

> > > > I want to display an entrylist (valuelist) with names of employees who
> > > > are both 'on duty' and '{*filter*}'
> > > > The valuelist comes from a field that sets the names of employees to
> > > > false or true. But how to define the condition "if (employeestatus ="on
> > > > duty" (((combined with)))) "{*filter*}";employee-name;"")

> > > > Purpose: in a timecard-solution only on-duty {*filter*}rs should log in.

> > > > I've tried the AND expression, the "return-character" but it didn't work.

> > > > Anyone any suggestion?

> > > >{*filter*} van der Kolk



Sat, 28 Jun 2003 06:22:10 GMT
 problem with conditional valuelist
I still think the Pattern Count function might be better - not so much in
this particular case (only two variables) but as you have discovered, the
order the check boxes are checked determines the order they appear in the
field so you have to be able to account for each permutation.  If there
were 3 variables, you would need 9 permutations, 4 variables, 16
permutations, 5 variables, 25 permutations and so on.  I don't need to
tell you how quickly you would find yourself working with astronomical
figures at that rate!

Bridget

Quote:

> Hello Bridget,

> Sorry for keeping you up last night.

> Finally, I found (an/the) answer: I should use the Case-function.
> This one does the trick:

> Case(employeestatus="{*filter*}"&"?"&"on duty";employee-name;"")    
> (((added with additional conditions)))

> Notice the "carriagereturn". It turns out to be important also to
> mention the sequence of the values:

> "{*filter*}" & "on duty" selected in that order differs from "on duty" &
"{*filter*}"
> This matters when selecting values by checkboxes: when checked you will
> never know the selecting sequence.

> SO: All the possible combinations of values must be mentioned in the
Case-condition.

> Thank you for sparring.

>{*filter*} van der Kolk
> Delta Events
> The Netherlands

> ________________________________________________________________________


> > Whoops!  Those darn 'and' and 'ors' keep tripping me up tonight.

> > Try this:

> > If (Pattern Count (employee-status, "on duty") = 1 and Pattern Count
> > (employee-status, "{*filter*}") = 1, EmployeeNameField, "")

> > Bridget



> > > Hello Bridget,

> > > Your hammering the nail on the head:

> > > I need BOTH the arguments to be true: If (employee-status = "on duty"
> > > AND employee-status = "{*filter*}",
> > > > EmployeeNameField, "")

> > > Though the syntax seems correct, it-just-won't-work. The values "on
> > > duty" and "{*filter*}" come from a checkboxed field.

> > > In English: Show the names of the {*filter*}rs who are on duty.

> > > Can you come up with another suggestion?

> > >{*filter*} van der Kolk


> > > > Make the value list come from a calc field rather than the Employee
> > Name field:

> > > > If (employee-status = "on duty" or employee-status = "{*filter*}",
> > > > EmployeeNameField, "")

> > > > In English:  If the employee is on duty or {*filter*}, show his name,
> > > > otherwise do nothing.

> > > > Now only the names of on duty or {*filter*} employees will appear in the
> > > > value list.

> > > > --
> > > > Bridget Eley



> > > > > One field (employee-status) has values: on duty, off duty, {*filter*},
> > > > > company employe. Values are chosen by checkmarkboxes.

> > > > > I want to display an entrylist (valuelist) with names of employees who
> > > > > are both 'on duty' and '{*filter*}'
> > > > > The valuelist comes from a field that sets the names of employees to
> > > > > false or true. But how to define the condition "if

(employeestatus ="on

- Show quoted text -

Quote:
> > > > > duty" (((combined with)))) "{*filter*}";employee-name;"")

> > > > > Purpose: in a timecard-solution only on-duty {*filter*}rs should
log in.

> > > > > I've tried the AND expression, the "return-character" but it
didn't work.

> > > > > Anyone any suggestion?

> > > > >{*filter*} van der Kolk



Sat, 28 Jun 2003 07:31:19 GMT
 problem with conditional valuelist
Well, I'll give it a thought for sure. At least I have a working
solutions now. The rest is to discover.

Dick van der Kolk

Quote:

> I still think the Pattern Count function might be better - not so much in
> this particular case (only two variables) but as you have discovered, the
> order the check boxes are checked determines the order they appear in the
> field so you have to be able to account for each permutation.  If there
> were 3 variables, you would need 9 permutations, 4 variables, 16
> permutations, 5 variables, 25 permutations and so on.  I don't need to
> tell you how quickly you would find yourself working with astronomical
> figures at that rate!

> Bridget


> > Hello Bridget,

> > Sorry for keeping you up last night.

> > Finally, I found (an/the) answer: I should use the Case-function.
> > This one does the trick:

> > Case(employeestatus="{*filter*}"&"?"&"on duty";employee-name;"")
> > (((added with additional conditions)))

> > Notice the "carriagereturn". It turns out to be important also to
> > mention the sequence of the values:

> > "{*filter*}" & "on duty" selected in that order differs from "on duty" &
> "{*filter*}"
> > This matters when selecting values by checkboxes: when checked you will
> > never know the selecting sequence.

> > SO: All the possible combinations of values must be mentioned in the
> Case-condition.

> > Thank you for sparring.

> >{*filter*} van der Kolk
> > Delta Events
> > The Netherlands

> > ________________________________________________________________________


> > > Whoops!  Those darn 'and' and 'ors' keep tripping me up tonight.

> > > Try this:

> > > If (Pattern Count (employee-status, "on duty") = 1 and Pattern Count
> > > (employee-status, "{*filter*}") = 1, EmployeeNameField, "")

> > > Bridget



> > > > Hello Bridget,

> > > > Your hammering the nail on the head:

> > > > I need BOTH the arguments to be true: If (employee-status = "on duty"
> > > > AND employee-status = "{*filter*}",
> > > > > EmployeeNameField, "")

> > > > Though the syntax seems correct, it-just-won't-work. The values "on
> > > > duty" and "{*filter*}" come from a checkboxed field.

> > > > In English: Show the names of the {*filter*}rs who are on duty.

> > > > Can you come up with another suggestion?

> > > >{*filter*} van der Kolk


> > > > > Make the value list come from a calc field rather than the Employee
> > > Name field:

> > > > > If (employee-status = "on duty" or employee-status = "{*filter*}",
> > > > > EmployeeNameField, "")

> > > > > In English:  If the employee is on duty or {*filter*}, show his name,
> > > > > otherwise do nothing.

> > > > > Now only the names of on duty or {*filter*} employees will appear in the
> > > > > value list.

> > > > > --
> > > > > Bridget Eley



> > > > > > One field (employee-status) has values: on duty, off duty, {*filter*},
> > > > > > company employe. Values are chosen by checkmarkboxes.

> > > > > > I want to display an entrylist (valuelist) with names of employees who
> > > > > > are both 'on duty' and '{*filter*}'
> > > > > > The valuelist comes from a field that sets the names of employees to
> > > > > > false or true. But how to define the condition "if
> (employeestatus ="on
> > > > > > duty" (((combined with)))) "{*filter*}";employee-name;"")

> > > > > > Purpose: in a timecard-solution only on-duty {*filter*}rs should
> log in.

> > > > > > I've tried the AND expression, the "return-character" but it
> didn't work.

> > > > > > Anyone any suggestion?

> > > > > >{*filter*} van der Kolk



Sat, 28 Jun 2003 22:57:57 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. F4M Problem with defining a conditional valuelist.

2. Some good info on conditional Valuelists available?

3. Conditional valuelist depending on repeating field

4. CDML Problem: fmp-if tag within FMP-valuelist tags

5. Problem finding data with checkboxed valuelist

6. Valuelist problem

7. Conditional ORDER BY with conditional ASC or DESC

8. Conditional AND, Conditional OR

9. Conditional DROP a problem when compiling

10. Conditional column problems...

11. conditional problem

12. Conditional performance problem


 
Powered by phpBB® Forum Software