So here's my conundrum. I'm trying to design a lost-and-found form that allows a user to enter data about a lost item, which then writes over to a list in SharePoint Online. When the lost item is disposed of (returned to its owner, thrown away, etc.), the SPO list item needs to be updated with the new information about when and how the lost item was taken care of.
That seems simple enough. Seems like a form > Create item in SPO > Assign a task > Update item in SPO. But the problem is that there is no one specific to whom the task should be assigned. Any employee in the given location can potentially be the one to update the information, just as any employee can be the one to enter the original information. And we have approximately 30 locations for which this is the case. I don't want to assign the task to multiple parties because, of course, that type of task requires specific users to be named - an administrative nightmare in this case. (And you can assign only up to 10 parties, which wouldn't be enough in most cases here.)
So what I need is a way for a user in a location to access the form and enter and submit the information, which then writes over to SPO. Then, at a later date (could be the same day, could be up to 60 days later), anyone else in the location needs a way to enter information that will update the same line item in SPO. Presumably they need a way to see the original information so that they know they are updating the correct item.
The previous forms software we used did this easily, because it allowed users to return to literally the same form and update information. But the closest thing in NWC is to assign a task and create a new form that contains the original information.
Any ideas on how I might accomplish this?
Best answer by DavidAD
View original
