F4M Problem with defining a conditional valuelist. 
Author Message
 F4M Problem with defining a 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.

Any suggestion?

Dick van der Kolk



Mon, 23 Jun 2003 01:53:18 GMT
 F4M Problem with defining a conditional valuelist.

If (PatternCount (employeestatus, "on duty") and PatternCount
(employeestatus, "{*filter*}"), employee-name, "")
--
Glenn Schwandt



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.

> Any suggestion?

>{*filter*} van der Kolk



Mon, 23 Jun 2003 03:51:40 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. F4M/S: valuelists get messed up spontanously

2. problem with conditional valuelist

3. Some good info on conditional Valuelists available?

4. Conditional valuelist depending on repeating field

5. F4M An entertaining problem.....

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

7. Problem finding data with checkboxed valuelist

8. Valuelist problem

9. Weird VB problem: User-defined type not defined!

10. Conditional ORDER BY with conditional ASC or DESC

11. Conditional AND, Conditional OR

12. F4M: FileMaker & SMS


 
Powered by phpBB® Forum Software