The Clist is a list of fields that are needed to gather data from a table and plot the records on the map. The values in the clist are the field ID values of those fields. The clist is also in a specific order so we can identify which field is which.
You can specify just a field that has the full address, or list out each address field for the clist.
clist1=3.21.22.26.27.25.8.11.9.23.$20.D28.N16
OR:
clist1=3.21.22.26.27.A24.23.$20.D28.N16
These are examples of the clist parameter. If the value you are passing into the clist is a currency, date, or numeric field, you need to put a $, D, or N in front of the field ID.
The order for the clist is this when you have the address split up into different fields:
Order | The order for the clist is this when you have the address split up into different fields: | The order for the clist is this if you have the address in one field: |
|---|---|---|
1 | Key Field (typically the Record ID#) | Key Field (typically the Record ID#) |
2 | Latitude | Latitude |
3 | Longitude | Longitude |
4 | Name | Name |
5 | Marker | Marker |
6 | Address | (A)Address |
7 | City | URL |
8 | State | Custom Field1 |
9 | Zip | Custom Field2 |
10 | URL | Custom Field3 |
11 | Custom Field1 | |
12 | Custom Field2 | |
13 | Custom Field3 |
All thirteen or ten fields are required in the clist, and you will get an error if you are missing one.
The Latitude, Longitude, Marker, and URL fields are added to the table if you ran the cloud setup of QB Maps.
The custom fields are the three additional fields that are shown when you select a location.