Google表：向查询单元格中添加图像
因此，我要做的是添加显示在某些单元格旁边显示的图像，同时保持下拉列表的能力，从而通过各种列进行排序。我想添加视觉效果，因为这是为了说话的社区，我希望它是一张可访问的纸张。
I've made an example of what I'm trying to do on this表在“数据”表上带有一些占位符图像。这些图像未携带到“排序数据”表中。我知道无法单独使用查询功能来从另一个表中带入图像，因此我想知道如何在维护图像时获得这种设置。此表是可编辑的。
在寻找答案时，我找到了以下方从查询结果出现的图像
这是我见过的最接近的图像。但是，我很挣扎在如何将其转换为在整理数据方面要做的事情。我还看到人们说某些功能与很多图像不起作用，只能加载一些功能。我不确定这可能是多么真实，但以防万一相关，这张纸上可能会有很多图像。
我完全对可能错过的任何东西，可以做出的任何更改，任何其他功能以及脚本（如有必要）开放。
So what I'm trying to do is add images that show up next to certain cells while maintaining the ability to have a drop down that will sort through various columns. I want to add visuals because the community this is for speaks many different languages, and I want it to be an accessible sheet.
I've made an example of what I'm trying to do on this sheet with some placeholder images on the "Data" sheet. These images aren't carried over to the "Sorted Data" sheet. I know the query function on its own can't be used to bring images in from another sheet, so I want to know how I could get this kind of setup while maintaining images. This sheet is editable.
While looking for answers, I found this: Google Sheets Query Image to show up from Query result
It's the closest I've seen. I'm struggling, however, on how I might translate this to what I'm trying to do here in terms of sorting the data. I've also seen people say some functions don't work with a lot of images, only loading a few. I'm not sure how true that might be, but just in case it's relevant, there likely will be a lot of images on this sheet.
I'm completely open to anything I may have missed, any changes I could make, any other functions, and script if necessary.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
查询不适合这项工作。使用：
query is not suitable for this job. use: