Frequently Asked Questions (ASM3)
All lookup data (including locations) can be edited under System->Lookups.
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>
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 animalAnother 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