Hello,

I believe there should be a relationship between the objects to generate a combined report on them. There is no built in relationship between User and Document objects in Salesforce.

So we have to create a Look-up/Master-detail/Many-to-many relationship in either of the objects to the other. But there is no option to create a relationship with the Document object.

Is it possible to create look-up /Master-detail relationship with Document object on User object or on a Custom object?

Could anybody please share your idea on this issue?

Thanks in advance,

Revathy

Hello,

I believe there should be a relationship between the objects to generate a combined report on them. There is no built in relationship between User and Document objects in Salesforce.

So we have to create a Look-up/Master-detail/Many-to-many relationship in either of the objects to the other. But there is no option to create a relationship with the Document object.

Is it possible to create look-up /Master-detail relationship with Document object on User object or on a Custom object?

Could anybody please share your idea on this issue?

Thanks in advance,

Revathy

Hey Everyone,

I'm working on a pretty insane project right now that has a very cool requirement. Basically, we're building a very content rich customer portal. For every user of the portal, we need to track exactly what Salesforce content they downloaded, links clicked on etc.

I don't believe Salesforce content API exposes downloads outside of internal Salesforce users so I was considering building a click tracking module for my customer portal. If I'm going to do this, now I need a place to store all the data that we're capturing from customer portal sessions. A few options I'm considering:

A. Salesforce.com record for every click/download/etc - While this will be the easiest to write the reports the client wants, I'm hosed on data storage as the site has potentially thousands of users clicking everywhere.

B. Create one salesforce.com record per authenticated session and store all of the clicks in a comma separated text area long field.

C. Setup a MYSQL database over on AWS and capture this data here. I'll have to then write my consumption reports by looking at AWS and SFDC but the store capacity is far greater than what we have at Salesforce.

If anyone has ever built something like this before or has any suggestions on how to proceed, please do let me know.

Thanks!