AnsweredAssumed Answered

Can Survey123 auto concatenate text and integers/times from other fields?

Question asked by lindsay.raabe on Jun 25, 2017
Latest reply on Jul 7, 2017 by lindsay.raabe

I have a series of questions asking if a place is open on set days where the answers are either "Closed", "All-day" or "Set Times". If "Set Times" is selected then Open and Closing time fields appear for manual input. I would like to then concatenate all these answers into a single field for use later. This would result with multiple combinations in that field as shown below;

 

i) "Closed"

ii) "All_day"

iii) "08:00 am - 05:00 pm" or something to this effect if I could get it to work

 

I've tried numerous combinations of formulas based on the "IF" scenario in the calculate and default fields with the type as hidden and calculate. I manage to get the "Closed" and "All_day" answers to work but not the concatenate part if "Set Times" is selected. I don't know if this is possible so hopefully someone can set me on the right path (if it exists!). 

 

 

I've uploaded some sample data. 

 

Thanks!

Outcomes