Leading US-based Hospital and healthcare center adopts Custom SharePoint application to manage inventory and Post Covid situation

There are several exciting features of the application like:

• Tooltips can be added easily with every question by the admin from the admin panel itself to facilitate an easy explanation of each question.
• The order or numbering of any question can be controlled while creating them.
• Some of the fields were filled in manually, while some fields in the form were automatically filled up by the auto running scheduler from some excel sheets located outside the app environment.
• Power Automate is used to run the scheduler and also send the notification to the submitter and approval for new data entry.
• The questions were equipped with some relational algorithm/ compare logics amongst each other. This helped them to set up a condition like: Figure in answer A cannot exceed the figure on answer B.
• The forms are built to restrict the entry of future date data before completing the old date data. That means, the submitter cannot add data on the current date without completing the entry on all the past dates.
• Email notification is sent to the approver that information is not filled by the concerned responsible submitter.

Results

With the implementation of the Covid information submission form, the client got the following benefits

• They may keep track of the required stats and refer to them from anywhere on the network.
• With this workflow, the manual process of data collecting and analysis was automated.
• The performance of hospital employees was also monitored, as when they failed to enter the correct information, an email message was sent to the approver, who could then take appropriate action.
• The manager can identify who has been consistent in filling out entries and double check the accuracy.
• The customer was given a single dashboard to see when and where the situation at the time of Covid was dire so that prompt action could be taken.
• The performance of critical gadgets was maximized, and action was taken at the central facility to monitor if they were out of commission for an extended period of time.