using pulldata function in relevant field

Question

i want to know if using a pulldata function in the relevant field so that based on the value given to the form a group of questions will show if the value is a 'y' can work?

pulldata('CSVfile, 'mtrchg', 'type',(${ser_order_num},= 'y'))

i don't get any errors when i add the above to the relevant field in the form... but what the outcome i want doesn't happen either.

JamesTedrick · Answer

Hi Jevita,

Try having the pulldata function populate a test text field to make sure it's working and the values are what you are expecting.  If it is 'Y', it should be 'Y' in the comparison as well - capitalization matters.

JevitaWebster · Answer

yes, my CSV file i has a column of 'N' and 'Y' if the field in my form displays the value that equals 'Y' then i would like the group of questions to show. That's not happening. when i add the pulldata and enter the value that should show the "grouped questions" nothing happens. the "grouped questions" dont show.

JamesTedrick · Answer

Hi Jevita,

The pulldata function should work within the relevant field.  I think the issue is that you've included teh comparison inside the pulldata function - you are wanting the questions to show if the value pulled is 'y':

pulldata('CSVfile, 'mtrchg', 'type',${ser_order_num}) = 'y'