Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Open
  • Priority: High
  • Security: Public
  • Views: 23
  • Last Modified:

Google Fusion Table - coding problem in dynamic Info Window in the map

I have a Google Sheet with responses from a questionnaire to several people. One question was Post Code, so I now have a Map in Google Fusion Tables showing where they're all located according to Post Code.  That's all working fine, but my question is about the Info Window.  I've customized that to a certain extent, so now it only shows the fields that I want. But what I want to do is...

a) For some fields (checkboxes), only show it and associated data if the data is non-empty.

b) For other fields (multiple choice grid where the left column of the grid is 'None'), only show it and associated data if the data is NOT EQUAL to 'None'.

I've searched a lot in forums about this, and I've found many answers that use 'if' statements, but I can't get anything to work. Every time I use the curly brackets {} it thinks I'm trying to specify a column name, so I get 'Unrecognized column' every time I try using {if ...} or {template .contents}, or anything apart from {a name of one of my columns}.

Also, I've seen a lot of references to $data.value.name - but nothing that explains how I modify this to include the actual name of my column.

First of all, since (b) should be simpler, could you help me with that one first?

Thanks.
0
meirionwyllt
Asked:
meirionwyllt
0 Comments

Join & Write a Comment

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now