I'm asking my clients to upload 3 media files. And they can change/modify it whenever they want. So its a form with 3 Image/Video input fields. And I want them to upload as many times as they want but the form will only display the latest set of images/videos.
Every time they update, image1, image2 and image3.... it gets updated as a new row in the database. Problem is, how do I display latest set of image1, image2 and image3? Especially when clients update only 1 or 2 images at a time and not the entire row.
On Day 1, client uploads image1, image 2 and image3. Form should display those 3 media files.
On Day2, client decides to update only image3. Database creates a new row where image1 and image2 are NULL/empty. Image3 has the new image. How can my form display image1 and image2 from Day1 and image3 from Day2?
I've tried using sort and filter in dataset element but that filters the entire row. And not for individual media files.