Creating a Custom Attachment Table

[Erik Nelson]

Hello all,

I've been tasked with looking at the feasibility of creating a custom Attachments table for an App that is in the scoping phase. Essentially, because there isn't a ton of security on sys_attachments, the ask is that the new App has its own dedicated attachment table that we can put ACLs behind without impacting the rest of the system functionality.

Has anyone considered or done this before, and how big of a lift/customization are we looking at if we want to attempt it?

Thanks,

Erik

[Sandeep Rajput]

@Erik Nelson This approach may have its pros and cons. You may have a dedicated tables to store your attachments which will be governed by your own ACLs. However, you may end up loosing several OOTB attachment features which are offered by OOTB attachment functionality. Please consider the following points before designing a custom attachment table

1. You will need to implement a replica of OOTB sys_attachment, sys_attachment_doc tables

2. You would need to design your own Attachment upload macro which would allow users to upload attachments to your custom table

3. In flow/workflow you will need to design your activity/action related to any attachment level processing

4. OOTB Email composer may not support your custom attachment table.

[Sandeep Rajput]

@Erik Nelson Thanks for the upvote. Please consider marking the response accepted solution if it addressed your question.