Check for holidays in submitted dateTime

Question

I'm working on a permit request form in Survey123 Connect where submitted beginning and ending event dates (dateTime) need to be checked if they fall on a Memorial Day, Independence Day or Labor Day (many years in the future). If they do, dates are accepted but a note needs to be displayed that the selected dates fall on a holiday. Then, the form needs to assign a "special permit" category to the submitted request.

Any ideas, tips, suggestions how to achieve it?

AnnaStefanowicz · Answer

The reason for my troubles was that I linked the csv file to the survey, instead of saving it in the media folder. Your original solution works well in the Connect app when the csv file is in the media folder. However, after publishing the survey, I get below error in the browser. I also get the same error when having the csv file linked to the survey, instead of having it in the media folder. Any ideas what's causing this error?

MobiusSnake · Answer

Is your first question (the one with the pulldata calculation) set to hidden?  If so, could you temporarily make it something like an integer-type question, and check that it's returning the correct 1/0 value based on whether the date is a holiday?

If the first question is working as expected but your note's relevant field still isn't working, maybe you could try setting your note's relevant field to this (using your field name rather than mine):

pulldata('holiday_date', 'is_holiday', 'datecode', ${date_disp}) = 1

If this works, and you don't need the "is_holiday" check anywhere else, you can probably just delete the first question and go with this approach instead.

AnnaStefanowicz · Answer

Thank you for your helpful tips.

I still have trouble triggering a note using the output of the if() statement. In below, the second row is a note with a statement in the relevant column. But that note doesn't appear in the form when it should be. The relevant statement calls for the text field name where the if() statement is used.