DropDown field adding values when populating from a SQL datasource

[XenophonD]

Hello,

Is it possible to add text options to a dropdown field on top of the values that are being populated from a SQL data source? We have been unable to get it to work and are looking for others who may have been successful.

Example: SQL populates data with specifics but we want to add a "ALL" or "NONE" option for future filtering in a gallery.

[Shanescows · Accepted solution]

The idea that comes to mind for me. Put the SQL data in a collection, then add the two records you want, then use that collection for your dropdown. 

[XenophonD]

That makes sense. I'll give that a try today. Thanks!