Buzzy Documentation
  • Welcome to Buzzy
  • Getting Started with Buzzy
    • Getting Started Guide
      • 1. Starting with Buzzy AI
      • 2. The Buzzy Workspace
      • 3. Create a new app
      • 4. Preview and edit your app
      • 5. Manage your app
      • 6. Import your app to Figma
      • 7. Using Buzzy with Figma
      • 8. The Buzzy Figma plugin
      • 9. Creating a simple app
      • 10. Screens and navigation
      • 11. Forms, fields and data
      • 12. Data-driven menus & content
      • 13. Data edit and delete
      • 14. Search, sort and filter
      • 15. User login and registration
    • Buzzy AI or Figma first?
  • Working with Buzzy
    • Buzzy AI
      • About Buzzy AI
      • Kickstart with AI
      • Enhance with Figma
      • Extend with Code
      • Example prompts
      • Tips
      • Troubleshooting Buzzy AI
      • AI tokens and pricing
    • Buzzy for Figma
      • About Buzzy for Figma
      • Learning Figma
      • Creating a new app directly in Figma
        • Step by step version
      • Automarkup
      • Responsive layouts
      • Responsive layout checklist
      • Overflow and scrolling
      • Forms and fields
      • Images and galleries
      • Logging users in to your app
      • Theming
      • Troubleshooting Buzzy for Figma
      • Plugin error messages
    • Buzzy Deployment & App Stores
      • Setting up your custom Buzzy app
      • Connecting your own server
      • Apple & Google App Stores
    • Buzzy Marketplace
      • Buzzy Accreditation
    • Buzzy Project Guide
    • Buzzy App Examples
      • Buzzy Templates
      • AI-Powered Chat App
      • AI-Powered Custom T-Shirt App
      • AI-Powered Strategy App
      • AI-Powered Stock Portfolio App
      • Golf Course Finder
      • Personal Finance App with Figma AI
    • FAQs
  • The building blocks
    • Datatables, Fields & Data
      • Introduction to Fields
      • Basic Fields
        • Text
        • Number
        • Date
        • Location
        • Toggle
        • Checkboxes
        • Checklist
        • Selectlist
        • Rating
        • Attachments
        • Images
        • Signature
        • Audio Recording
        • Embedded Link
      • Advanced Fields
        • Formula
        • Sub tables
        • Linked Table field
        • Button
        • Teams
        • Payment
        • Notification
        • Event
        • User Vote
      • Display Fields
        • Header
        • Display Text
        • Image
        • Divider
      • Metadata Fields
        • Author Name
        • Author Phone
        • Submitted
      • Filter Controls
        • Viewers
        • Tags
        • Condition
      • External Fields
        • IBM Connections File
        • Box File
      • Sort Fields
      • Formulas
      • Datatable to Datatable Relationships
      • Security and Access Control
      • Displaying a field based on the values of other fields
      • Hiding a field based on role using a display formula
      • Importing data from a text file
      • Importing data from a URL
      • Import data from Datatable
      • Export data using Chrome
      • Export data in Browser
      • Export data using Safari
      • Datatable Field Type - Cheat Sheet
      • Troubleshooting Fields & Data
    • Code widget (custom code)
      • Code Widget Fields - Advanced Guide
      • New Async API + React HTML Components
      • Examples
        • Image Galley Slideshow
        • Ratings Average and Distribution
        • Event Locations Map
    • Analytics
  • Troubleshooting
    • App Error Codes
      • Action Error
      • App Not Found
      • Component Missing
      • Component Not Set
      • Component Settings Error
      • Datatable Not Found
      • Datatable Not Set
      • Field Not Found
      • Field Not Set
      • No App Selected
      • No Context Name
      • No Screens Found
      • Runtime Exception
      • Screen Not Found
      • Screen Not Set
    • Troubleshooting Buzzy AI
    • Troubleshooting Figma
  • REST API
    • Buzzy REST API
      • Integrating 3rd party applications
      • REST API
        • login
        • createappwithprompt
        • MicroApp Data Operations
          • microappdata
          • microappdata/row
          • insertmicroapprow
          • updatemicroapprow
          • removemicroapprow
          • microappchild
        • User & Organization Operations
          • userid
          • insertteammembers
          • teammembers
          • insertorganization
          • insertteam
        • enforceteammembership
      • Node.js API Client
      • Datatable Rules
      • Datatabledata Tutorial
      • Integrating with Mailchimp
      • Python Access Datatable
  • Advanced Deployment Settings
    • Installation
      • Pre-installation Planning
      • Deployment
        • Introduction to deployment
        • Minikube install guide
        • AWS ECS Fargate install guide
        • HCL Connections install guide
        • Azure AKS install guide
        • Windows container install guide
      • Buzzy settings
      • Whitelabelling Buzzy
      • Certificates
      • Release Management
    • Performance and Reliability
    • Security
      • Platform
      • Users and Roles
      • Datatables
      • Audit Trail
Powered by GitBook
On this page
  • Table of contents
  • BASIC FIELDS
  • ADVANCED FIELDS
  • DISPLAY FIELDS
  • METADATA FIELDS
  • FILTER CONTROLS
  • EXTERNAL FIELDS
  • EXPERIMENTAL FIELDS
  1. The building blocks
  2. Datatables, Fields & Data

Datatable Field Type - Cheat Sheet

A quick overview of the field types available in a Datatable.

PreviousExport data using SafariNextTroubleshooting Fields & Data

Last updated 4 months ago

Table of contents


BASIC FIELDS

Text

Text field allowing input of plain text - it can be multiline (it will resize itself as user types). Links within the text are automatically parsed on submit (but are clickable only in readonly version ie by users without edit rights). Options include specifying whether it should be a text field, a url, email or phone number (on mobile devices this will open the relevant keyboard type).

Number

This is a single-line numeric input (on mobile devices this will open the numeric keyboard if available).

Date

A date/time field - can be a single date/time or a duration (ie with start and end date/time). User can specify as ‘all day’ (enter date only, no time). Can also limit field to allow time/day/month or year selection only.

Location

An address or location field - opens a map view.

Toggle (true/false)

This is an on/off switch control that renders as a single checkbox with an optional label. Use this when you only need the user to set a single value to true/false or on/off.

Checkboxes

A list of checkboxes with a labels allowing user to select either none, one or multiple options.

Checklist

A ‘todo’ or task list widget that renders as a series of checkboxes with a ‘percentage complete’ progress bar - as items are checked off, the progress bar/percentage adjusts. You can specify default items and/or allow users to add/edit/remove their own.

Selectlist

A single dropdown selectbox field allowing user to select only a single option out of a list. Can also render the options as buttons.

Rating

A rating selection from 1 to 5 - can specify from a choice of icons eg stars, hearts and more (default is stars).

Attachments

An attachment field that allows users to attach one or more files (including images). Attached files render as a list, with each item clickable (depends on file type and device/browser whether click triggers view or download).

Images

Similar to the Attachments field, but limited to images - these render in a gallery view when clicked.

Signature

A signature/drawing field allowing user to sign via mouse/screen touch and save their signature.

Audio - (LEGACY)

No longer supported.

Embedded Link

Renders as a text input allowing a user to add a url/link. This then displays as a clickable card with title, image and description from the link (if available). User can also manually enter information for that card (eg title or description) if the link doesn’t automatically provide it.


ADVANCED FIELDS

Event

An event widget that includes a title (text input), start and end date/time and location (opens map view). When viewed in results, includes ‘add to calendar’ button which triggers an email notification with calendar link in it. Can also include an RSVP option.

Button

Renders a button on the Datatable form. You can enter the text to be used on the button, as well as specifying who can view the button analytics (who clicked the button and when). The button options/type include:

  • Click button: default, action needs to be specified via rules in the Datatable advanced settings (Settings modal > Advance tab > Rules tab)

  • Toggle button: similar to click button, actions need to be defined in advanced settings. In this case the button has 2 states (ie on/off), and each state can have custom button text.

  • Link button: can specify a link to open on button click (this can include an email address).

  • State button: allows you to set state on a form - like a local state variable that you can then use in validation or display formula.

  • Submit button: submits the form immediately.

Formula

Allows you to render a value via a JSONata calculation eg based on values entered in other fields within the same form (for instance, a tally or total).

User Vote

This field type creates a survey - users can select from one of a series of options. It is intended to collate the choices of multiple users and is thus redundant with a normal ‘submit’ form use-case since only the user submitting the form would make a choice - the Checkboxes or Selectlist field would be better suited here.

Cross-App Field

Advanced option to include values from a field in another app within Buzzy.

Embedded Datatable

Embeddatatable field allows you to nest an entire Datatable as its own field in a parent app - in effect, to form a one to many relationship between two Datatable.

Notification Button

Renders a button that triggers a messaging interface, allowing you to send in-app notifications directly to individuals, teams or organisations.

Payment Button

Payment Field creates a payment button within a result row. The button is not visible in the Datatable submit form itself. Payment settings are defined at result level (once created).

Recommendation: A simpler option in most cases would be to just add a payment button as a standalone resource (ie not as part of a Datatable) to the Buzz.

Teams

Teams is a select field that lets you choose Buzzy teams. Useful if doing advanced stuff with the information (eg formulas etc).


DISPLAY FIELDS

These are static text or display elements that don’t gather data themselves but are rendered in the Datatable submit form or result details view.

Header

A text heading used to group fields into sections.

Display Text

Static text - for instance help text or instructions you may want to render on your form. Links are parsed and become clickable.

Image

Displays a static image.

Divider

A static divider (horizontal rule) element.

METADATA FIELDS

These are static fields that render information about the current result. They don’t render in form views (ie before a result exists).

Author Name

Displays the user name (if available) of the row creator (ie who submitted a particular result).

Author Phone (LEGACY)

Displays the phone number (if available) of the row creator (ie who submitted a particular result).

Submitted Date

Displays the date/time a result was submitted.

FILTER CONTROLS

Viewers

A searchable select field that defines view permissions (by individual, team or organisation) on a Datatable result row.

Tags

A searchable select field that assigns tags to a Datatable result row (currently limited to global tags only).

Condition

Renders a checkbox, used to define a state on the row as true/false. Use this in conjunction with Datatable actions or rules.

EXTERNAL FIELDS

Box File

Field which allows user to insert/attach files from Box cloud storage service. Only available to users logged in via Box


EXPERIMENTAL FIELDS

Feedback

Similar to the rating field, but renders as unhappy to happy face icons, and on selection only the selected one is highlighted (ratings highlights the icons from 1 to the current selection).

SVG

Allows app author to insert custom (SVG image) code as a field - that code can refer to other field values. In the app, this is parsed and rendered as a .svg image, with an option to download and save it as a .png image.

Weather

Displays an OpenWeather weather forecast (in a result view only) based on the first available valid location field value in that row/result.


BASIC FIELDS
Text
Number
Date
Location
Toggle (true/false)
Checkboxes
Checklist
Selectlist
Rating
Attachments
Images
Signature
Audio - (LEGACY)
Embedded Link
ADVANCED FIELDS
Event
Button
Formula
User Vote
Cross-App Field
Embedded App
Notification Button
Payment Button
Teams
DISPLAY FIELDS
Header
Display Text
Image
Divider
METADATA FIELDS
Author Name
Author Phone (LEGACY)
Submitted Date
FILTER CONTROLS
Viewers
Tags
Condition
EXTERNAL FIELDS
Box File
IBM Connections File
EXPERIMENTAL FIELDS
Feedback
SVG
IBM Watson Personality View
Twitter Feed (for IBM Watson)
Weather