Fred ... you're the man ! Such a small thing makes all the difference. Thanks again to LJ and everyone else that contributed also.
Great appreciation .... Susan On Fri, May 16, 2008 at 8:27 AM, Grooms, Frederick W < [EMAIL PROTECTED]> wrote: > ** Drop the dolar "$" signs. The Attachment commands are looking for the > Field ID numbers not a reference to the actual fields > > The command should be PERFORM-ACTION-OPEN-ATTACHMENT 900000010 > Fred > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Susan Palmer > *Sent:* Thursday, May 15, 2008 9:37 PM > > *To:* [email protected] > *Subject:* Re: How to open an attachment in a child form record from a > tablefield on the parent record? > > ** I had tried that, but just did it again just to make sure. Made no > difference. And when you reopen the AL it replaced the field ID with the > field name. > > I'm on a different PC right now and it reacts the same as my office PC. I > cleared the cache on my office PC serveral times today also. Trying to > think of everything possible that might affect an AL. > > On Thu, May 15, 2008 at 8:40 PM, LJ Longwing <[EMAIL PROTECTED]> > wrote: > >> ** 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 ARSlist: "Where the Answers Are" >>> html___ >>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>> html___ >>> >> >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> > > __Platinum Sponsor: 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"
