Auto-attaching attachment to a record

[lightblu]

Hi,

I would like an attachment (word document) to be attached to each new record (in my request table) by default, as soon as the record gets created. How would I do this?

Right now I have to drag-and-drop the attachment onto each record.

Thanks!

[lightblu]

Hi Ahbinay,

I ran your script, but there seems to be a scoping issue (I'm using Geneva):

Create operation against 'sys_attachment' from scope 'x_prgm_red_team_te' has been refused due to the table's cross-scope access policy

What are my options for fixing this? It seems like all attachments in sys_attachment have global scope.

[Abhinay Erra]

You will have to change Application access controls for the table. Go to sys_attachment table and right click on the list go to configure -> Table. In the application access check box the create and make sure it is accessible form all applications as shown in the below screenshot

[lightblu]

Hi Abhinay, I just found out that this attaches an empty Word document to the record when it is inserted. I'm not sure why it's empty because the original document in the sys_attachments table is not. Thanks for the help.

[Cameron Boote]

Looks like you may also need to insert a record into the Attachment Documents table (sys_attachment_doc).   I tried the above script and also got an empty word document.   I just started working on this so I'll report back once I get it working.  

[ruzbehv]

Hi Cameron,

Were you able to get the attachment to populate with data?

Regards,

RV.