nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey123 analog to MS Access checkbox or tickbox

EricaNova

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.

Trouver plus de publications taguées avec

Accepted answers

dougbrowning

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

All comments

abureaux

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.

EricaNova

It's a TRUE/FALSE field.

dougbrowning

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

abureaux

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.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.