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.
clist1=3.21.22.26.27.25.8.11.9.23.$20.D28.N16
OR:
clist1=3.21.22.26.27.A25.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:
- Key Field (typically the Record ID#)
- Latitude
- Longitude
- Name
- Marker
- Address
- City
- State
- Zip
- URL
- Custom Field1
- Custom Field2
- Custom Field3
OR if you have the address in one field:
- Key Field (typically the Record ID#)
- Latitude
- Longitude
- Name
- Marker
- (A)Address
- URL
- Custom Field1
- Custom Field2
- Custom Field3
All thirteen or ten fields are required in the clist, and you 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.