Hi All,
I have a Casetable which contains columns like CaseNum, CaseActivityStatusDate, CaseActivity.
When they import a excel sheet with data for eg for one case in Model driven app
First time.
CaseNum | CaseActivityStatusDate | CaseActivity
0001 | 1-10-2024 | sent to customer
Next time when they update excel and uploads the column values gets updated based on caseNum
Second time
CaseNum | CaseActivityStatusDate | CaseActivity
0001 | 1-11-2024 | Customer Accepted
Next time when they update excel and uploads the column values gets updated based on caseNum
Third time.
CaseNum | CaseActivityStatusDate | CaseActivity
0001 | 1-12-2024 | Case Closed
Next time when they update excel and uploads the column values gets updated based on caseNum
So here if anybody comes to the table and see they will see only the latest activity for the casenum 0001.
But what if they want to see the history of that particular case 0001? It means to track in different Activities even after case closed.
Here they upload data in excel only to update information.
Please help