Template #Prompt Question

[ChrisBos]

I am creating a Template with a #Prompt:
#Prompt(‘Table:’,From(%file)),%thistfile that choses a single file.
A second #Prompt:
#Prompt(‘Select Fields’,From(%field)),%fieldList,Selection(‘Field Selection’) does not populate the selection list. How do I make %field dependent upon %thisfile?
If I skip this I can list ALL fields with:
#For(%file),WHERE(%file = %thisfile)
#For(%field)
…

[RobertoArtigas]

You will need to create a %multi-fieldlist structure and will have to do the #FOR as you are doing above and add the fields to this %multi-fieldlist.You can put these in a BUTTON to see them, and then you can select the field from the list into whatever you are going to use them.

There are a number of examples in the standard clarion templates that do this. And a bunch of vendors, and/or free templates written by a number of authors do this. Just search with KSS the standard template space and you will find something you can modify.

Good luck.

[ChrisBos]

Thanks, Roberto; I appreciate your help and the quick reply. I’ll see what I can do with that.

[CarlBarnes]

This post may help

Template #PROMPT with FIELD doesn't show all fields

I have a template that requries a BrowseBox(ABC). I wanted to limit the available selections to the primary file, so I used this approach. #PROMPT(‘Field2’,FIELD(%Primary)),%CpField However, this does not list the fields inside the DateTime structures, and these are the fields I needed here. I have workaround without scope, but ideally I would like to limit available fields to those that are both in the primary file and visible in the listbox Should I build a list from %ControlField?