Unable to Use a SQL View on a SmartFill Object


After creating a SQL View, you are unable to add it to a SmartFill Object.


Unfortunately, SmartFill does not recognize Views in SQL. Therefore, it cannot use them.

We recommend creating a SmartFill Custom SQL Object and using the spSmartFill.sql template that comes with the SmartFill download. You can refer to the SmartFill manual (also included in the SmartFill download) to set up a SmartFill Custom SQL Object and modify the spSmartFill.sql template.