CustomField

The band’s own fields on core tables. Each row is one real column, named with the x_ prefix, on the table it belongs to. Retiring a field hides it everywhere and keeps its data.

  • the date-time notation as defined by RFC 3339, section 5.6, for example, 2017-07-21T17:32:28Z

  • The table the field is on, e.g. gigs or venues. Fixed once created.

  • Fixed once created; to change a field’s type, retire it and add a new one.

    values
    • rich_text
    • number
    • currency
    • date
    • time
    • checkbox
    • select
    • multi_select
  • The column name: lowercase, starting with x_. Fixed once created.

  • the date-time notation as defined by RFC 3339, section 5.6, for example, 2017-07-21T17:32:28Z

  • The allowed values of a select or multi_select field.

  • The table a relation field points at. Fixed once created.

  • New records must supply a value. Checked by the API, not the database.

  • A retired field is hidden from the API and the app; its column and data stay.