Need urgent help

Hi Guys,

I have a unique requirement. Where I will create number of deliverables for a campaign in deliverables table. It can be one or many. Each campaigns will have different deliverables.

Users apply to campaign, when they apply to campaign, I adding a new row in CampaignData table. where I am recording campaign name and user id of creator

I have a table called Campaign content where I am storing campaign contents like url name etc.

I have created a relation between my deliverable table and campaign data table such that it shows the list of deliverables for the campaign for the user.

I am not able to understand how to click on the deliverable name listed and upload content for that deliverable, that creator and that campaign.

Thank you in advance for help.

Basically for every creator based on the number of deliverables there for the campaign they should be able to upload content for each deliverable. N number of contents.


So your sample data looks like this:

Campaigns Table

CampaignID CampaignName CampaignDescription
C001 Campaign A Description of Campaign A

Deliverables Table

DeliverableID CampaignID DeliverableName
D001 C001 Deliverable 1
D002 C001 Deliverable 2

CampaignData Table

CampaignDataID CampaignID UserID ApplyDate
CD001 C001 U001 2024-06-29 10:00:00

CampaignContent Table

ContentID DeliverableID UserID ContentURL ContentName UploadDate
CT001 D001 U001 Content 1 2024-06-29 12:00:00
CT002 D002 U001 Content 2 2024-06-29 12:30:00

Now, you want to know how one can upload content to a deliverable of a campaign. I believe if you construct your data as above, you already have all the pieces in place. A form in the deliverables details view would help you get the deliverable ID in place, the user ID is from the signed-in user’s profile, and the campaign ID can be taken from the deliverables relation (you don’t need to write this to a basic column).


Hi @ThinhDinh I played around with your solution. I am successfully able to create relation between Campaign and Deliverable ID and I am able to list All deliverables for the user.

Meaning My relation column in CampaignDate table Lists the multiple deliverables

Now I am not able to think or understand how can I make a relationship such that when I upload a content it should upload to particular user → particular campaign → particular deliverable

I am stuck thinking on this relationship.

Please forgive me if it sounds basic. Thank you in advance for your help.


Hi @ThinhDinh just tried creating a relationship. Now it’s uploading content from particular user to the deliverable from the campaign.

But I am seeing a “?” symbol in my relation.

I know its some error from my end. Could you kindly help me how do I solve it?


Hi @ThinhDinh

Thank you for your help I found the solution to have a perfect relationship to get my work done.

I even got it to work on my Admin view as well.


1 Like