I'm transferring a database from MS Access to Survey123. In Access, some questions were in the form of a "tickbox" or "checkbox". What is the closest I can get to this in Survey123 - a single select question with two choices, defaulting to "FALSE" or "No"?
I liked that in Access you just left the box unchecked if FALSE. It seemed cleaner somehow.
Solved! Go to Solution.
In our old Access database we had these checkboxes and they got stored as 0/1 and then no one knew what the heck that meant 2 years later and we always had to go back and look. It was actually super annoying.
So instead now we have True/False or Yes/No and then set a default so False/No. Simulates the same function rather well and now everyone knows False=False.
Then for some projects we never knew if they meant False or they just missed the question. So then we went back and removed the default and added a required. Crystal clear then.
Hope that helps
I don't think "tic boxes" are a real thing. SharePoint also has those, but in reality they are TRUE or NULL fields. What does the data look like exported? It has been forever and a day since I looked at Access.
In the end, a custom select_one will likely be the answer. Just make the choice list's name equal to the values Access has in that column.
It's a TRUE/FALSE field.
In our old Access database we had these checkboxes and they got stored as 0/1 and then no one knew what the heck that meant 2 years later and we always had to go back and look. It was actually super annoying.
So instead now we have True/False or Yes/No and then set a default so False/No. Simulates the same function rather well and now everyone knows False=False.
Then for some projects we never knew if they meant False or they just missed the question. So then we went back and removed the default and added a required. Crystal clear then.
Hope that helps
This is they way.
I do the same thing in SharePoint. Microsoft's checkbox field feels like a trap. I always make a choice field for Yes/No and make the questions required in S123. Removes all ambiguity.
I think I misunderstood the initial question.