A student of mine was using a copy of an app I made and encountered an error:
I don’t fully understand the problem but I’m guessing that the SELECT() expression is construed by the AppSheet platform as a “List of ‘List’” expression. Indeed, [Tags to list] is a list.
However, in the app that the student copied, this doesn’t cause an error:
Here too, [Tags to list] is a list. So, what might be happening?
The student was using the app without any problems but I think that his editing of the spreadsheet directly in the Google Spreadsheet interface may have caused this issue to occur. He has shared the spreadsheet with me and I had to fix some misaligned data. Or, perhaps something he typed into the “tags” column triggered the problem – but the tags in his sheet seem normal.
I’ve found a workaround to get his app going again so there’s not short-term problem. I would, however, like to understand what caused this issue, if possible.
I suspect that I may need to contact AppSheet support about this but I thought I’d address the inquiry to the community first. Thanks in advance!