Example of global variable

There’s nothing specifically for global variables, although it is something we would like to add. Here’s a workaround:

  • Make a table that you decide will only be used for global variables - let’s call it Global.
  • Make a field for each global variable you want.
  • Have just one record in that table. A card widget is good for this.
  • Get that single record in other formulas with Global.lookupOne()
  • Get attributes from that record, so a formula might look like g = Global.lookupOne(); return $value / g.total
2 Likes