Ray,
This can be done by Filter or Active link (Filter if the SQLFilter field is
on a different form than the one your user is saving)
You can use a simple Set Fields action (or Push Fields if sending to a
different form)
Under the Fields section of the If or Else tab, select SQLFilter from
Ray,
A filter on Submit (and/or Modify) is what your after.
Assuming you want to set the 'SQLFilter' field anytime 'Field1' or
'Field2' values are changed by the user then the Run If would need to
be something like
('DB.Field1' != 'Field1' OR 'DB.Field2' != 'Field2')
Next you would need
Ray et al.,
You mentioned that the user can fill in Field1 and/or Field2. If you
are going to leave it so that the values of either Field1 or Field2
could be left blank, then you'll need to make several Active Links to
test for the various conditions and set your SQLFilter string
accordingly.
Hi: I have three fields called Field1, Field2 and SQLFilter in a form.
User provides data for Field1and or Field2. When the user hits the save
button, I want to populate the SQLFilter field with the following string
Customer = 'Value of Field1' AND Severity = Value of Field2
I am thinking I
4 matches
Mail list logo