Hello,
I'm currently developing a survey that will be used to prompt local businesses. The business owner will be able to include various data about their business including hours of operation. Currently, there is a lot of variation in the hours of operation submission format. (see the image below)
I'd like to eliminate as much variation as possible. I came across a public survey in my searches and would like to do something similar. It looks like they have a multiline text box with the days of the week prefilled.
Does anyone know how to accomplish this in connect? I'm open to other ideas too! Any information or assistance would be greatly appreciated. Thanks!!
Solved! Go to Solution.
Since data quality seems to be an issue, have you considered doing something more regimented?
Here is an example of what you can do with repeats:
This ensures:
You can of course change what needs changing.
I am not sure if default can do this but you could try it. You would use a concat with '\n' as the separator to give you a new line. If default does not go then you can use calculation but it gets funky since it will add a refresh button and if the user taps it, then what they entered will get wiped. Set it up and test thoroughly.
Thanks for your help on this @abureaux ! I had to adjust the questions slightly and add a few extra calculate fields to get it to function as intended, but your answer pointed me in the right direction. I've attached a copy of what I used in case anyone else comes across a similar issue in the future. Thanks again!