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.
Regards,
Dilip
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
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).
2 Likes
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.
Regards,
Dilip
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?
Regards,
Dilip
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.
Regards,
Dilip
1 Like
