1. What is the issue? Please be detailed.
Ideally, I'm wanting to be able to give AI enough context to help quickly develop forms in Google Sheets. I've only seen this with regards to others looking for better workflows for developing XLSforms and the brief summary is that @Brenton_Peterson is looking for:
- Plain text format
- Ability to edit simultaneously (and Version Control)
- Identifying Errors Proactively (Form Validation)
- Clean and Efficient Commenting
I've moved to Google Sheets exclusively from Excel because of many of these issues. In addition, Google Apps Scripts allow you to do a lot of things like custom functions which could help with autocomplete. I've also used it to more quickly iterate/upload form definitions and media to my self-hosted ODK Central server and ONA servers.
However, given changes in AI in the last few years, I'm wondering if someone has started using AI when addressing a complex issue. I've found that its difficult to give AI context in a normal chat prompt. So my question is for people who are developers or who are familiar with AI tools that are using CLI in IDEs like VS Code. In these setups, users can use their local files as context for the AI, and I'm wondering if anyone has been able to do this well using Google Sheets or an XLSX file to be able efficiently identify problems, fix things, etc., ideally where you could address specific cells/rows and AI would give suggestions. My attempts with Gemini in the side window of Google Sheets has resulted in really poor quality responses, whereas chat prompts with Kappa AI (on the ODK Docs page), Gemini, and ChatGPT have been better quality.
Has anyone ever seen an interface for Excel or Google Sheets for AI suggesting changes similar to code diff views like this?
