In the previous posts (Part 1, Part 2 and Part 3) we took an Excel Spreadsheet and create a modern web-based application that our business users could do. Whilst it created a very powerful application, it did require us to know a little bit of SQL and was complex in parts. An alternative to a full-fledged application is to use the Websheets feature in Apex to create an editable web page that users can use to edit and manage their data. This can be a more appropriate option for converting spreadsheets as it is easier to use and doesn’t require any knowledge of SQL. However, because of this simplicity, it’s not as powerful a tool and may not be an option for more complex data interactions.
In this post we will take the spreadsheet we used in the previous posts and create a Websheet so we can compare the two methods. After that you’ll hopefully be able to choose the right option in future.