if you want to limit the List Boxes you could choose a list box expression, it's the option at the bottom
and type the following
=IF(A = 'Approved',A)
and for the other list box
=IF(B >= 1000000 ,B)
If it's a Straight Table that you want not to show these fields, use some Set Analysis in your table expression
Forgive my ignorance, in the example you gave, does this remove the selected values from the list or limit the list to these values.
This is important as some of the columns I will be working with have a lot of values, so i need to be abl eto use an expression to remove values from list.
Also, one thing that I forgot to ask before. In one of the docs I am uploading, it has columns that I need to upload but I do not really want to upload the contents. I would like to just load an empty column.
But I do not want to have to modify the spreadsheet to do that. Is there an easy way to do that in the script?
Also, no idea what "Set Analysis" is.