You’re offline. This is a read only version of the page.
Hi everyone, I am looking for some consultation.
So I have a stock table like below on dataverse. The data will be update regularly like quantity or stock date.
| ID | Item | Quantity | Latest Stock Date |
| 1 | Item A | 10 | 2023/05/30 |
| 2 | Item B | 5 | 2023/06/30 |
| 3 | Item C | 20 | 2023/06/28 |
Our managers want to have a date filter and after selecting date, they can see the data from that date.
We are planning to have a separate table to record the history of the items to get the old data from, but we are considering how will we save the history (by every time someone made changes, by hours, by days or by months, etc.)
So, I would like to hear some suggestions from this forum. Maybe some idea about the architectures or is Dataverse/SharePoint a good option for this, etc.
frankly, I don't have that great of advice, but use whatever is most comfortable to you. Then just create whatever columns you want, and patch whatever data you want to it. Since you are already using dataverse, I would suggest to put the history table in dataverse to keep things simple.
Share
Report
All responses (
Answers (
392
