Search code examples
google-fusion-tables

fusion-tables auto populate fields in new record


I'm using fusion tables to store a client database. I have ~300 records of clients and their installations, but I need to add records for repairs. I need an easy way of creating a "repair" ticket, where most of the information from the specific client record is visible without having to copy the info manually for each additional repair. Help!


Solution

  • For your use case I would create another table containing the repairs, which contains some kind of key column to identify the client. This could be the name of the client or simply a number (id).

    When you have your new repair table and the existing client table, you can simply create a so called merge table. This new table contains the information of repairs and client. If you add or change data in one of the tables, the merge table automatically contains this data.

    Technically, a merge table is a left outer join (SQL).