Skip to main content
Keyword: Option Button

#EN #Excel #Keyword

Updated over a year ago

What is the keyword to use?

In order to create an option button type control, please use one of the following keywords:

Description

Keyword to Use

Custom option button

optionbutton

Legacy option buttons


Why use this keyword?

With this control, you will be able to:

  • Get offered multiple choices, depending on the variant keyword used

  • Can only pick one option at a time

    • Picking the other option will remove the selection of the first

  • Multiple variants are at your disposition, depending on your need at the moment

  • Numeric choices are considered as text; they can not be used for calculations


How to use this keyword?

As a FIELD

Using columns A, B and C in the Excel spreadsheet, you can create a field.

  • Column A will be used for the TITLE

    • The title will be displayed to add a description regarding your input

  • Column B will be used for the KEYWORD

    • The keyword defines what the field will be used for

  • Column C will be used for the VALIDATION RULE(S)

Here are examples:

  • If you use the custom option button:

  • If you use a legacy variant of the option button:

Here is how it displays in the application:

  • If you use the custom option button:

  • If you use a legacy variant of the option button:


As a COLUMN

Using three consecutive rows (or as we refer to it, 123) in the Excel spreadsheet, you can create a column.

  • Row 1 will be used for the TITLE

    • The title will be displayed to add a description regarding your input

  • Row 2 will be used for the KEYWORD

    • The keyword defines what the column will be used for

  • Row 3 will be used for the VALIDATION RULE(S)

Here is an example:

Here is how it displays in the application:


Custom option button restrictions

In order to use the custom option button properly, there are some guidelines to follow and some limitations:

  • The options will be displayed in circles only if the number of characters for all the options are between 1 and 3.

  • The options will be displayed as flat text if the number of characters exceeds 3 for any of the options.

  • The option button will not work and be displayed a text editor if:

    • There is only one programmed option button.

    • There are more than 10 programmed option buttons.

    • The number of characters for one of the options exceeds 15.


Available validation rules for this keyword

STATE CHANGE

INVALIDITY (LIMITS)

AUTOMATION

FORMULAS

None.


Legacy option buttons (all variants)

-#-

Keyword to Use

Buttons in Paperless

-/+

-+na

+/-

+-na


-A-

Keyword to Use

Buttons in Paperless

a+abc

a+abcd

a+abcdna

a+abcna

ab

abc

abcd

ac

acceptableunacceptable

acceptableunacceptablena

acceptedrefused

acceptedrefusedna

acre

activateddeactivated

ampm

arrivalbeforepurchase

AU

AUNA


-B-

Keyword to Use

Buttons in Paperless

bd

beforeafter


-C-

Keyword to Use

Buttons in Paperless

celciusfahrenheit

checkx

choice01234

choice012345

choice012na

choice12

choice123

choice1234

choice12345

choice123456

choice1234567

choice12345678

choice123456789

choice12345678910

choice1234568

choice123459

choice12345910

choice12na

choice123na

choice1234na

choice12345na

choice1259

choice34567

choice359

CNC

CNCNA

CNCNO

CNCNONA

CNCOFI

CNCOFINA

correctincorrect


-D-

Keyword to Use

Buttons in Paperless

dayafternoonmidnight

dayevening

dayeveningnight


-F-

Keyword to Use

Buttons in Paperless

freshfrozen

freshfrozenboth

fritosun


-G-

Keyword to Use

Buttons in Paperless

gkg

goodbad

greengraypurple

greenyellowred


-I-

Keyword to Use

Buttons in Paperless

internalexternal


-L-

Keyword to Use

Buttons in Paperless

leftright


-M-

Keyword to Use

Buttons in Paperless

malefemale

mggkg

minormajorcritical

montofri

montothu


-N-

Keyword to Use

Buttons in Paperless

negativepositive

negativepositivena


-O-

Keyword to Use

Buttons in Paperless

onoff

openclosed


-P-

Keyword to Use

Buttons in Paperless

passfail

passfailna

positivenegative

positivenegativena

potatotes


-R-

Keyword to Use

Buttons in Paperless

receivingshipping

redyellowgreen


-S-

Keyword to Use

Buttons in Paperless

smiley

SMU

SMUNA

startend

startinprogressend

SU

SUAO

SUNA

SUNAAO

SUNANP

SUNO

SUNONA

SUNP

suntosat

SUOFI

SUOFINA


-T-

Keyword to Use

Buttons in Paperless

truefalse

tuetofri


-Y-

Keyword to Use

Buttons in Paperless

yesna

yesno

yesnomaybe

yesnona


More details

Here you can find a description for some of the abbreviated buttons.

Button

Description

A/U

Acceptable/Unacceptable

C/NC

Compliant/Non compliant

AO

Already observed

M

Marginal

NA

Non applicable

NO

Not observed

OFI

Opportunity for improvement

NP

No production

S/U

Satisfactory/Unsatisfactory

Did this answer your question?