How do I add new locations or species?
All lookup data (including locations) can be edited under System→Lookups.
How do I put my adoptable animal list on our Facebook page?
ASM's "Share" button is great for highlighting an animal so that all your followers see it in their timeline, but you can also add your complete adoptable animal list as a tab to your Facebook page too!
Follow this guide to add a new iframe tab to your page. Use a service call to your ASM-generated web pages. If you're using sheltermanager.com, it's as easy as using this snippet of iframe markup (substitute YOURACCOUNT for your sheltermanager.com account number):
<iframe src="https://service.sheltermanager.com/asmservice?method=animal_view_adoptable_html&account=YOURACCOUNT" width="100%" height="600px"></iframe>
How do I use an additional field in a custom report?
An inner SELECT example for an additional string field:
SELECT
AnimalName,
(SELECT af.Value FROM additional af INNER JOIN additionalfield aff ON aff.ID = af.AdditionalFieldID WHERE af.LinkID = animal.ID AND aff.FieldName = 'YourField') AS YourField
FROM animal
Another example for an additional checkbox field:
SELECT
AnimalName,
(SELECT CASE WHEN af.Value = '1' THEN 'Yes' ELSE 'No' END FROM additional af INNER JOIN additionalfield aff ON aff.ID = af.AdditionalFieldID WHERE af.LinkID = animal.ID AND aff.FieldName = 'YourField') AS YourField
FROM animal