Are there any opensource tools for managing data entry (that can be programmatically customized and communicate with other programs)?
We are currently using google sheets to allow certain users (with certain domain knowledge, but no programming knowledge) to add and edit table records. These tables are then used to update a directory page in a web app written in ruby. The problem is that using google sheets for data entry, does not allow for custom programming such as input validation logic or using a list of prime keys to exclude these table rows being uploaded to the web app.
Suggestions or work-arounds would be appreciated. Thanks.