Frequently Asked Questions (ASM3)

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!

To do that, first make sure that you have HTML publishing enabled in ASM under Publishing>Set Publishing Options.

Then, follow this guide to add a new iframe tab to your page. Use a link 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://public.sheltermanager.com/animals/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