Survey123 if then statement with an 'and' and a pulldata

516
2
Jump to solution
02-03-2021 02:54 PM
SSeymour
New Contributor

I am trying to use an if then statement with an 'and' included and a pulldata. The data I am using is GSA's per diem rates. I have a ‘select one’ for location (county), and a begin and end date in Survey123 form. I have also concatenated the two date columns but not sure this is necessary.

What I am trying to do is pull the lodging and MI&E rates into the form, so once a location is selected (county) it then gives the options for the ‘SEASON BEGIN’ and SEASON END’ columns. In the case of Kootenai, there would be three options, once that is chosen it fills in the Lodging and MI&E fields.

If ‘Kootenai’ and ‘begin’ and ‘end date’ are this, then lodging and MI&E rates are this.

SSeymour_0-1612392641560.png

I have seen examples with if then statements and nesting but nothing that adds 'and' or multiple columns the way I need it to. I would really like to keep this as a pulldata and not enter it into the form because it will be updated every year and I would rather update the spreadsheet then the Survey123 form.

Any ideas, suggestions, help would be greatly appreciated. Thanks in advance. 

0 Kudos
1 Solution

Accepted Solutions
IsmaelChivite
Esri Notable Contributor

Are you looking for something like this?

GSA.gif

 

If so, check the attached XLSForm and associated media files.

In short:

  • A cascading select (choice filter) to display the seasons according to the county
  • A pulldata to retrieve the rates

View solution in original post

0 Kudos
2 Replies
IsmaelChivite
Esri Notable Contributor

Are you looking for something like this?

GSA.gif

 

If so, check the attached XLSForm and associated media files.

In short:

  • A cascading select (choice filter) to display the seasons according to the county
  • A pulldata to retrieve the rates
0 Kudos
SSeymour
New Contributor

That is exactly what I'm looking for. Thank you so much!