Bespoke Listboxes

When [gb_bespoke_fields] input_type = 'listbox', listbox displayed on screen.

Users able to select from list when editing screen.


Set-Up

To remove existing listbox choice from list, update [gb_bespoke_listboxes] status_flag to 'inactive'.

Bespoke fields configured with listbox can be added and edited in patchQuote API.


Example Setup with Notes

Bespoke Listbox ID

Bespoke Field ID

Value

Status Flag

Notes

100000

100000

Listbox row 1

active

100001

100000

Listbox row 2

active

100002

100000

Listbox row 3

active

100003

100000

Listbox row 4

inactive

Entry will not display in available list selection because status_flag is 'inactive'

100004

100000

Listbox row 3

active

Duplicate value acceptable


Notes

  • Listbox entries stored in [gb_bespoke_listboxes] table

  • Each entry linked to bespoke field via bespoke_field_id

  • Inactive entries hidden from user selection

  • Duplicate values across different bespoke_listbox_id entries acceptable

  • value field contains text displayed in listbox to user

  • status_flag controls visibility: 'active' displays, 'inactive' hides