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;
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.