Unable to Use a SQL View on a SmartFill Object

Issue

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

Resolution

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.