
Hi! I am in the process of making a rental app for loaning out equipment at work.
I have one Sharepoint list with ItemNo, LoanStatus, among other information.
It is simple to create an app which tells us if the item is available or not.
But we need history. Who borrowed this item when?
My thought is to have another Sharepoint list for this and creata a new row every time an items is loaned out. The list will have columnns like:
ItemNo, DateBorrowed, PlannedReturn, DateActualReturn,BorrowedBy, among others.
In my scenario we will have one row in this list per rental per item.
My question:
Hi,
I know that one part of making a log of all equipment going out could be to patch it to a log,
Patch(
sharepointlist,
{
ItemNo: textbox.value,
DateBorrowed: textbox.value,
PlannedReturn: textbox.value,
DateActualReturn: textbox.value,
BorrowedBy: textbox.value,
}
);
The textbox.value would be whatever your input would be. You could use an if statement to lookup the ItemNo and check whether a new column called LoanedOut is a yes or no. I'm not sure how would you do that but hopefully put you on the right track.