Hi Debra, This is a good one. Thanks for putting this brainteaser on list. Here's my 2 cents for this. a) A display only form(kind of like homepage) that will have a table field (set the properties for this table as 'Select First and Then fire workflow' ). The table field property should be associated with your original form and it should show everything that is "Open" assuming a new request created on that form will have a default status of "Open". Also, create a temp field to hold 'Request ID' column of table. b) When display only form is opened first, refresh table field, set focus on table field and have workflow on menu/row selection(2 different Active Links) a) if temp field is NULL- set the temp field to Request ID(if temp field is NULL) of first "Open" record and next action would be to pop-up message with request ID. b) if 'z_temp_RequestID_Fied'!='col:Request ID' field and 'z_temp_RequestID_field'!=$NULL$ and next action would be to pop-up message with request ID. Alternatively, you can also use $COLCOUNT$ keyword for this logic.If COLCOUNTS for current and previous table refreshes dont match and if COLCOUNT of current refresh is greater than that of previous table refresh, then you can trigger pop-up message. c) Now, there should be some workflow firing on an interval, that would perform a table refresh and basically call above workflow. Although, this wont be showing requests instantaneously as they are submitted, however it tries to mimic 'Alert' tool. I can see one drawback to this is if multiple tickets are created and table hasnt been refreshed for a while then only the last submitted ticket will be shown in pop-up. You can overcome this by writing some advanced workflow to walk through tables and build dynamic URLs for requests. I believe you will also have to do some client side configuration(like when users login, the default homepage for those users should be set to this new display only form). Please share with us final solution as and when you develop it as problem seems very interesting. Thanks Chintan. --- On Mon, 6/28/10, Anderson Debra (PRN) <debra_ander...@prn.com> wrote:
|
_attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_