I am assuming that you wish to get data from user and write it in your database/ table along with seeing the same on the dashboard- there are a few ways to achieve this, although none of the methods are straightforward. Refer the following links they might be helpful.
We had a similar requirement few months back but we never went ahead with any of the above mentioned approaches. I think the easiest approach would to use Google Sheets or Excel Online or SharePoint Lists that can be updated by multiple users and be refreshed to achieve what you desire.
Thank you for responding. I agree that using Google Sheets or Excel Online would be the more effective options. Unfortunately we are not provided with SharePoint as a resource.