Brian,
Is the 'Sign In Date' field a date/time field or a date field? If it is
date/time (even if it is only set to display as date-only), then your
qualification would only prevent multiple requests from being created for
the current user for given second of the day, *not* for the given day.
If this is the cause, you should be able to correct this without converting
to the date field type by using this modified qualification:
( 'Submitter' = $USER$) AND ( 'Sign In Date' >= $DATE$)
HTH,
--Thomas
----- Original Message -----
From: "Sokol, Brian" <[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
Sent: Monday, October 30, 2006 11:11
Subject: Push Field Problem
I am trying to create some simple time auditing based upon when forms
are opened. I am running an AL with a push fields action to a form. I
set the Push Field If to:
( 'Submitter' = $USER$) AND ( 'Sign In Date' = $DATE$)
And set If No Requests match to Create a New Request
And
If Any Request Match to Take No Action.
Every time I open the form that triggers this AL it creates a new record
even though there are multiple records with my account in the Submitter
field and today's date in the Sign In Date field.
What am I doing wrong?
Brian Sokol
Manager, Desktop Services
Scholastic Inc.
212-343-6494
[EMAIL PROTECTED]
<http://www.scholastic.com>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"