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
      • 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
      • Datatable and Spectrum Dataflow integration
      • Python Access Datatable
  • Enterprise
    • Buzzy Enterprise CMS
      • Getting Started
        • Signing up or logging in
        • Logging in with a password
        • Sign up or login using other credentials
        • Change your password or set a new password
      • Using Buzzy Enterprise CMS
        • Finding a Buzz
        • Following a Buzz
        • Creating a Buzz
        • Editing a Buzz
        • Duplicating a Buzz
        • Deleting a Buzz
        • Adding people to a Buzz (Owner/Author/Audience)
        • Buzz privacy settings (Private/Unlisted/Public)
        • Buzz status settings (Draft/Published)
        • Adding content to a Buzz
        • Rearranging content in a Buzz
        • Adding and editing images on a Buzz
        • Changing the cover image on a Buzz
        • Optimising the cover image
        • Import bulk contacts/email addresses quickly into a Buzz
        • Copying items between Buzzes
        • Uploading a local video to a Buzz
        • Adding a web video (eg Youtube or Vimeo) to a Buzz
        • Buzzy Analytics and message tracking
        • Embedding a Buzz in a website (eg Wordpress, Weebly, Wix, Square)
      • Using Datatables
      • Using Advanced Maps
        • A Guide to Mobile Mapping
        • Vector Layers
        • Tile Layers
        • Adding Data
        • Offline
        • Optimize
        • Integrating GIS data
        • Adding Spectrum Spatial data to maps
        • Export MapInfo Professional CSV and Import into Buzzy
      • Using Templates
        • What are Templates?
        • Creating a Template
        • Using a Template
      • Receiving Payments
        • How to create and connect your Stripe account
        • How to insert a payment button
      • 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
      • Administration
        • Performance and Reliability
        • Content Management
      • Security
        • Platform
        • Users and Roles
        • Datatables
        • Audit Trail
      • Troubleshooting
        • Controlling Buzzy alerts, notifications and emails
        • Help! I can’t log in!
        • How do I check that someone on my Buzz has been correctly added and is receiving my Buzz updates?
        • I made a Buzz into a template and can’t find it now. Where’s it gone?
        • Inserting a Buzz into your website using an iFrame
        • Switching the Buzzy app to Classic view
        • Why am I not receiving notification or updates about a Buzz?
        • Why can’t I edit this Buzz?
        • Why can’t I see a Buzz that was shared with me?
        • Why can’t people see my Buzz?
        • Why is location map not working?
        • Why is my embedded Youtube or Vimeo video (or other web content) not rendering in the Buzzy app?
      • About Buzzy Enterprise CMS
Powered by GitBook
On this page
  1. The building blocks
  2. Datatables, Fields & Data
  3. Advanced Fields

Formula

PreviousAdvanced FieldsNextSub tables

Last updated 11 months ago

Formula Field are calculated using JSONata and can refer to other fields in the Microapp. The result of the calculation is displayed in the field. An example of a Formula Field is a running tally.

For examples on the formulas, please see

Settings

The calculation is specified using .

The output of the calculation can be displayed as:

  • Text

  • Number

  • Currency

  • Date

example formulas
JSONata
FonteAwsome 4