Skip to content

Collections and records

A collection is a table you define: «Orders», «Students», «Opportunities». It has fields, views, rules and automations. Each row is a record. All business data in Heskala lives in collections.

Special kinds:

  • Line collection: the detail of another one (the lines of a quote). It is edited inside the parent record.
  • Configuration collection: a single record per company or per branch (for example, tax data). Its values are used as @config.<key>.<field>.
  • Private collection: created by one person for themselves and shared with whoever they choose.
  1. Create or edit collections in Settings → Collections (Configuración → Colecciones), button New collection (Nueva colección).
  2. Put related collections in a group so they appear together in the «Collections» menu.
  3. Open records from the menu: table, kanban or calendar (see Views).
  4. Export the table’s records to CSV or Excel with Export (Exportar).
  • Up to 80 collections in the schema and 100 fields per collection.
  • Up to 5 line collections per collection and 500 lines per record.
  • What you see in each collection depends on your role: all records or only your own, and some fields may be hidden or read-only.
  • Deleting a record sends it to the trash.
  • get_schema_canvas: collections with their fields and how many views, automations, scripts and templates each one has.
  • export_schema: the full heskala.collections manifest or one collection.
  • list_records, get_record, create_records, update_record, delete_record (configuration) or list_my_collections, describe_collection, search_records (data).
  • To create or change collections: Schema and draft and get_field_guide.