Try making the second action on ST:SI-OnDblClickOpenEntranceVideo01 PERFORM-ACTION-OPEN-ATTACHMENT $900000010$
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Thursday, May 15, 2008 6:45 PM To: [email protected] Subject: Re: How to open an attachment in a child form record from a tablefield on the parent record? ** Thanks to all you guys! Haven't quite got it right yet. I already have an attachment pool on the Site form. Not sure what everyone means by 'display only' attachment field. I could not find a way to do that. Table drill down is disabled on the tablefield that display the child form entries and an AL successfully sets the right file in an attachment field I've designated on the Site form. I cannot get the attachment to open. I have a PERFORM-ACTION-OPEN-ATTACHMENT $DisplayOnly$ action in the 2nd active link. I've tried numerous run ifs. I even added a field so I could use a setfield action to trigger the AL. The attachment does open on the Site form if I double click on it. I've tried every combination of everything I can think of. What am I missing. I've pasted a log below. Thanks, Susan <WFLG> /* Thu May 15 2008 19:40:53 */ <WFLG> Workflow Trace Log -- ON <ACTL> /* Thu May 15 2008 19:40:58 */ <ACTL> Start active link processing -- Operation - On Return <ACTL> For Schema - ST:SiteInformation <ACTL> Linked to field - Entrance Videos (780000001) <ACTL> On screen type - SET <ACTL> Checking ST:SI-OnDblClickOpenEntranceVideo01 (1) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Fields <API > <TID: 0000001004> <RPC ID: 0112199417> <Queue: List > <Client-RPC: 390620 > <USER: aradmin > /* Thu May 15 2008 19:41:22.2880 */+GLE ARGetListEntry -- schema ST:EntranceVideos from Remedy User (protocol 12) at IP address 10.0.7.197 <API > <TID: 0000001128> <RPC ID: 0112199419> <Queue: Fast > <Client-RPC: 390620 > <USER: aradmin > /* Thu May 15 2008 19:41:22.3030 */+GE ARGetEntry -- schema ST:EntranceVideos entryId 000000000000001 from Remedy User (protocol 12) at IP address 10.0.7.197 <API > <TID: 0000002760> <RPC ID: 0112199422> <Queue: Fast > <Client-RPC: 390620 > <USER: aradmin > /* Thu May 15 2008 19:41:22.3190 */+GEB ARGetEntryBLOB -- schema ST:EntranceVideos entryId 000000000000001 fieldId 536880912 from Remedy User (protocol 12) at IP address 10.0.7.197 <ACTL> DisplayOnly (900000010) = C:\DOCUME~1\PalmerS\LOCALS~1\Temp\Farm market 010.jpg <ACTL> 1: Set Fields <ACTL> Video set on Site (536870923) = 0 <ACTL> 2: Commit Changes <ACTL> /* Thu May 15 2008 19:40:58 */ <ACTL> --1-- Start active link processing -- Operation - On Modify <ACTL> For Schema - ST:SiteInformation <ACTL> On screen type - SET <ACTL> Checking ST:SI-SetAssignedToGroupValuesModify (0) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Fields <API > <TID: 0000002756> <RPC ID: 0112199461> <Queue: List > <Client-RPC: 390620 > <USER: aradmin > /* Thu May 15 2008 19:41:22.8970 */+GLE ARGetListEntry -- schema User from Remedy User (protocol 12) at IP address 10.0.7.197 <API > <TID: 0000001128> <RPC ID: 0112199464> <Queue: Fast > <Client-RPC: 390620 > <USER: aradmin > /* Thu May 15 2008 19:41:22.9130 */+GE ARGetEntry -- schema User entryId 000000000000001 from Remedy User (protocol 12) at IP address 10.0.7.197 <ACTL> Assigned To Group (112) = 482; 481; 480; 1; 1503; 1504; 1500; 1513; 1502; 1508; 1501; 1550; 1551; 1130; 1505; 1506; 1601; <ACTL> Checking ST:SI-SetForecastingUpdatedBy (0) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-SetTotalNumberOfEntrances (0) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-SetUserIDUpdatedBy (0) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-ShowESPindicator (0) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-ShowPilotOnSiteChangeTaskHelpTicket (0) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-ShowSRTIIndexOnSiteChangeTaskHelpTicket (0) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-UpdateSRTISampleIsYesOnOpenChgTaskHT (0) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-UpdateSRTISampleIsNoOnOpenChgTaskHT (1) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-RequireDeleteReason03 (3) <ACTL> -> Failed qualification <ACTL> Checking ST:SI-RequireDeleteReason05 (5) <ACTL> -> Failed qualification <ACTL> /* Thu May 15 2008 19:40:59 */ <ACTL> --1-- Stop active link processing - On Modify <API > <TID: 0000002760> <RPC ID: 0112199475> <Queue: Fast > <Client-RPC: 390620 > <USER: aradmin > /* Thu May 15 2008 19:41:24.9130 */+SE ARSetEntry -- schema ST:SiteInformation entryId S00000283 from Remedy User (protocol 12) at IP address 10.0.7.197 <API > <TID: 0000002332> <RPC ID: 0112199598> <Queue: Fast > <Client-RPC: 390620 > <USER: aradmin > /* Thu May 15 2008 19:41:24.9440 */+GE ARGetEntry -- schema ST:SiteInformation entryId S00000283 from Remedy User (protocol 12) at IP address 10.0.7.197 <ACTL> Checking ST:SI-OnDblClickOpenEntranceVideo02 (2) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Run Process <ACTL> PERFORM-ACTION-OPEN-ATTACHMENT $900000010$ <ACTL> Checking ST:SI-OnDblClickOpenEntranceVideo03 (3) <ACTL> -> Passed qualification -- perform if actions <ACTL> 0: Set Fields <ACTL> Video set on Site (536870923) = 1 <ACTL> /* Thu May 15 2008 19:41:01 */ <ACTL> Stop active link processing - On Return On Thu, May 15, 2008 at 2:07 PM, LJ Longwing <[EMAIL PROTECTED]> wrote: ** Really quite simple once you think about it....you already have the attachment form with its attachment pool and field, you already have the table field on your main form showing you all of the records, that's 90% of the way. Now you need an attachment pool on your main form, and a display only attachment field. Disable table drill down on the table field, create an AL that fires on dbl click of the table row that does a setfield from the attachment form to your main form into the display only attachment field. Then have a second AL that fires on dbl click that opens the attachment from the main form. This will give them the ability to open the attachments stored in your attachment form. Let me know if you get stuck on anything I have said...I've implemented this a number of times with great success. _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Thursday, May 15, 2008 12:38 PM To: [email protected] Subject: How to open an attachment in a child form record from a tablefield on the parent record? ** Hi everyone, We have a need to store many .jpg files that we will periodically access. We want to access them from our Site form but to store them on this form would probably not be efficient. There will be approximately 10 .jpg files per Site so I thought a child form would be a better storage area. Initially my thought was to simply use a table field on the Site form displaying the necessary fields from the child form. On the child form there would be an attachment pool. There would be only one attachment per child record because other identifying information goes with each .jpg file. So in the table field we'd see the attachment file, description name, and view name for each child record associated with that Site. Ten child records, ten rows on the table field, ten .jpgs. Problem is, you cannot select the attachment field (filename) in the table field. Yes, we can double click on the row and access the .jpg file directly on the child record but of course that is not what they would prefer. They want to see the .jpg filenames, double click on them and whalaa they are open directly from the Site record. I thought it sounded reasonable until I'm playing around with the concept right now. I've looked through the documentation for some way to display this other than a table field and if it's there I'm missing it. Any suggestions on how I can accomplish this? ARS v7.0.1P3 (server, admin, user) Oracle 10g Windows 2003 I appreciate your help and ideas. Let me know what other information I could provide. Thanks, Susan Susan Palmer ShopperTrak 200 W Monroe St 11th Floor Chicago, IL 60606 312-529-5325 [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
