2 ms·

Spreadsheet-Driven Customization is a great way to enable non-technical users to customize and configure software. I used that technique for a one-off Java app

Spreadsheet-Driven Customization is a great way to enable non-technical users to customize and configure software. I used that technique for a one-off Java application back in 2011. The Java application did not do any live synchronization with the spreadsheet like Wildcard does. It just read the spreadsheet at application start-up to get configuration data needed to drive the application logic. Spreadsheet-driven customization allowed the application's users to edit the spreadsheet to grow and maintain the dataset that drove the application logic. I would not be surprised if others have done something similar before me.

capableweb 7y ago
Yup, doing the same for a frontend we're currently building. Basically some of the core features exposes warnings (on purpose) to the user once they do an action that they might want to do in a different way. These errors just have error codes assigned to them on the backend side and the frontend loads the real messages from AirTable on boot, which then is used to show the user-friendly title and description. We're doing the same thing for a couple of things and it has really cut down and development time as product team can now change the frontend themselves by just editing cells in AirTable instead of creating tasks for the development team.