Document Type query

Eoin Maguire asked on March 21, 2014 07:20

I need to build a list of 'services' that my client provides. These services will have a bunch of detail associated with them including map LAT / LONG coordinates. They'll also have two levels of categorisation, service area and service type.

So on the front end of the site I'll have a good map with two drop downs beside it, one that allows the user to choose a service area and the other will allow the user to select a service type. The map updates according to the choices.

I'm creating a new document type but am unsure as to how to add the ability to assign areas / types. Are these categories ('Add new category' within the document type creator) or are they attributes with something like 'Multiple Categories selector' chosen in the field appearance area.

Also, how do I add the various categories that these services can be assigned? Thanks.

document types

Correct Answer

Brenden Kehren answered on March 21, 2014 08:53

You could store your categories or lookup values in a custom table. Then in your doc type have a dropdown that allows multiple select and draws the value out of the custom table by a query.

1 votesVote for this answer Unmark Correct answer

Recent Answers

Eoin Maguire answered on March 21, 2014 07:21

Can't seem to edit my question, I've written 'good map' above, I meant to type 'google map'

0 votesVote for this answer Mark as a Correct answer

Eoin Maguire answered on March 21, 2014 09:06

Thanks, that sounds ideal, are there tutorials online that cover getting the values from the custom tables into those doc type dropdowns? Is this done in the definition of the doc type or elsewhere?

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on March 21, 2014 13:33

When you add a new field to a doc type, choose text and dropdown for the control, then in the Options section, enter a select statement to get the values out of your custom table. This would be a simple statement SELECT NameField, ValueField FROM CustomTable_Name ORDER BY NameField

0 votesVote for this answer Mark as a Correct answer