carto - url completion in cartoDB info windows

By far the most of my data is taken up a column of long strings pointing to the source of the data for each point. I need to keep that. However, it would be neat if CartoDB could use this information (i.e. build the URL) without me providing the full URL, only the relevant ending (and save on the size of the table by not repeating the common part as a long string). Is this doable in their info window?

Answer

You can use the custom HTML editor of the infowindows to build something like:

 


  
 Go to {{adm0_a3}}  

So if you have the endings of the URL stored in some column, you can avoid repeating the fixed part along all the table.