I am creating a web app that allows a person to input a lot of data about multiple software programs and then compare them in a or grid or in other ways. What would be the best way to do this? Can I do it with sheets or should I use airtable? I could gather data via forms but I would love the user to just double click in a field and change the info and that would reflect back to the database. Is there a way to do this with the native tools? Also how would I design it with the different users in mind. The head engineer who is evaluating the software can be the Super Admin. His colleagues beneath him would be allowed to add data as well but not have access to the super admin portions. Maybe the Super admin would want to send something to the vendors so they can update all of their information.
Any insight around any of this would be helpful.