Plot locations from multiple tables

Prev Next

To show pins from multiple locations, you need some extra parameters in the Formula URL button that runs it.
When this field is set up for one table, you see the parameters QB_DBID1, query1, and clist1. You should copy these and change the 1 to a 2 for the second table. Then change the values of those parameters to work with the new table.

Do this for each table you want to show pins from.

You need to add the parameter numoftables to the formula that specifies the number of tables you are trying to get the data from.
If you are using a central location pin with the QB_DBIDR, queryR, and clistR, this does not count towards the value of numoftables.
The following shows how the Formula URL for the button used to trigger the extension looks while querying, for example:

Example Formula URL showing parameters for querying multiple tables, including QB_DBID1, QB_DBID2, and numoftables.

For more information on how to set up the Formula URL to configure the extension for each of these scenarios, see Formula URL fields explained.