I want to have one table (readonly_table) with supporting non-geo data (e.g. project code, name, manager, etc.) and another table (write_table) with geo point, project code, perhaps a few other user entered properties e.g. start date.
And then I want to have these tables joined by project_code as key in a visualization so the info window displays both tables' fields on refresh (assuming readonly_table has a matching project_code).
Example: readonly_table has project codes 1, 2, 3, along with their other field values) The write_table is empty. User goes into the map, clicks "add feature" on the write_table layer. Adds a point. Clicks the "edit data" option. Types in a project code (2). Hits save and close.
Now when the user clicks on the same point on the map, he sees one info window with the merged results of write_table fields (project code, start date) and readonly_table fields (name, manager, etc.)
Is this doable within the CartoDB dashboard? If not, can you show a very basic example of an info window displaying from two tables based on a common field join (and geo data from one of the tables)?