
Hi everyone,
I'm building hospital inspection app and using multiple Sharepoint lists for patching data. In the app, user could inspect multiple units in one inspection and there are multiple rooms which user could inspect for a one particular unit.
I'm just curious to know if there is a way I could create a unique Id for each unit so I could know which rooms belong to particular unit. I will be calculating average based on room data. Thus I need to group rooms based on unit.