Hey there
Yes, you can do this, but you'll need to make some changes to the Get Options From Database setting in order to exclude the hidden ones.
Use the Get Options from MySQL Query (Advanced). Look at the following default query:
SELECT fieldname1, fieldname2
FROM `<?php echo $TABLE_PREFIX ?>tableName`
Fieldname1 = the field you had selected for option values
Fieldname2 = the field you had selected for option labels
TableName = the name of the table for this section
Once you've got those in, change it like so:
SELECT fieldname1, fieldname2
FROM `<?php echo $TABLE_PREFIX ?>tableName` WHERE hidden = 0
I can't tell if it's pending or hidden that's the name of the field, but hopefully you get the idea. Any records that are marked as hidden or pending will be excluded.
Let me know if this helps!
--------------------
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/