How to force capitalisation?

Support
1

  1. What is the issue? Please be detailed
    Is it possible to force capitalisation within xlsx forms?

  2. What steps can we take to reproduce this issue?

  3. What have you tried to fix the issue?
    Tried to review other posted topics

  4. Upload any forms or screenshots you can share publicly below
    Vehicle Check Form.xlsx (586.4 KB)

2

You don't need to enforce it, as you can calculate a capitalised value from the entry using the translate function.

Otherwise you could use a regular expression as a constraint to prevent entry of any lower case characters, but translating is going to be much less annoying for the enumerator

Here is an example regex expression from @Xiphware

Here is an (incomplete) example translate expression from @Alexander_Torrado

2 Likes
3

As @ahblake aludes to, you cant strictly (en)force uppercase character entry - that would basically require intercepting keystrokes and remapping them at runtime, which neither Collect or Enketo support [even presenting an onscreen uppercase-only software keyboard, in Collect, doesn't prevent people from attaching a bluetooth physical keyboard to their phone...).

So you are left with either checking that only uppercase characters had been entered (ie a regex based constraint), or remapping/translating whatever they did enter to all uppercase after-the-fact (aka translate approach) and storing it in another field.