Hi,
I have set up a few datasets, all using or manipulating the same data in different ways. I want to automatically create new entries into all of the datasets when one new item is added to the main dataset, connected by the reference field. I can’t figure out how!
I have one main dynamic dataset, “Video Library”, which is updated when specific site members with permission upload videos through a custom form. The “primary field” is the video title. Each video is displayed on its own unique dynamic item page.
I have also created these datasets, to manipulate that data in different ways:
- Video Views: A simple dataset, which “anyone” can add to or update, which just counts and displays the number of visits to that video’s dynamic item page.
- Questions: A dataset that only site members can edit and update, which collects questions that members ask about each individual lecture.
Both the Video Views and the Questions datasets have a reference field connecting them to the Video Library.
I am able to filter the “Video Views” dataset by the Lecture Title on the video pages to create and display the video view counter, and can do something similar for the questions dataset.
Here is my problem: When a site member uploads a new video, I want a corresponding new item to automatically get added to the Video Views and Questions datasets, with the reference field connecting to the Video Library dataset.
So, for example, if I were to submit a form uploading a video called, “Corvid Help”, currently, it will get added to the “Video Library” dataset. I know I can manually go in and add an item with “Corvid Help” as the reference field to “Video Views” and “Questions”, but I want “Corvid Help” to automatically show up in the “Video Library” dataset and the “Questions” dataset.
Can anyone help me figure out how?!
Thank you!