Submitted by desbest on 2023/10/04 13:57

How do I make a field uppercase using a conditional?

I tried reading the documentation but the instructions aren't clear.

Below you'll see my attempt.

my grid

 

infoqube url field

infoqube autoembed field

Comments

Hi desbest,

First a warm welcome from the entire IQ community!

The best option depends if you want to just display the URL as upper case or you want it stored as upper case. The Auto-assign route will store it as upper case. This will work:

AM:TestCharCount = ucase([URL])

If you just want to display it as upper case, you could use conditional formats to set the font to a font face where lower case letters are actually upper case. There are a number of these pre-installed by Windows.

Otherwise, it can be done using the Options section below it. From Field Management Dialog:

5. Options

Sets some additional field options:

  • <CAPS>: Displays all text as upper case

HTH!

Pierre_Admin
IQ Designer 

How do I ?