Pulldata If Statement

482
2
Jump to solution
09-09-2021 06:20 AM
IFI
by
New Contributor II

Hi,

I have a working survey that uses Pulldata to populate various fields from a CSV.

This is working fine except when there is a new site (which is obviously not in the CSV) to be added.

I have been trying to add an additional question (siteType), which would use the Pulldata function if one of the four options is selected, but not use Pulldata if the selection was "New".

Is there a way to construct an If statement that only uses the Pulldata function for certain answers?

Thanks,

Paul

 

 

 

0 Kudos
1 Solution

Accepted Solutions
AlfredBaldenweck
Occasional Contributor III

I think this should work?

if(${siteType} != "New", pulldata("whatever your parameters are"), "")

That should check to see if the answer to your site type question is "New" or not, and if it is, it will leave those questions blank, but will populate for every other answer.

Make sure that it's checking for the name, not the label. 

View solution in original post

2 Replies
AlfredBaldenweck
Occasional Contributor III

I think this should work?

if(${siteType} != "New", pulldata("whatever your parameters are"), "")

That should check to see if the answer to your site type question is "New" or not, and if it is, it will leave those questions blank, but will populate for every other answer.

Make sure that it's checking for the name, not the label. 

IFI
by
New Contributor II

Hi Alfred,

Thanks! That worked perfectly. I realised that I could still use the Pulldata in the calcRiverName, and then use the value in the riverName from this if the siteType was not 'new' as you suggested:

if(${siteType} != 'new', ${calcRiverName}, " ")

I also figured out a way to populate the Site Name based on whether it was picked from the PullData or entered by the user (see attached screenshot). I need the Site Name later in the survey...

Thanks for your help!

Paul

 

 

0 Kudos