Jam.py documentation contents

• Getting started
  • Installation
    • Install python
    • Install Jam.py
  • Creating a project
  • Demo project
  • Tutorial. Part 1. First project
    • New project
    • New catalog
    • Lookup fields
    • Lookup lists
    • Customizing Forms
    • Indexes
    • Filters
  • Tutorial. Part 2. File and image fields
    • Adding Image field
    • Capturing image from camera
    • Adding file field
  • Tutorial. Part 3. Details
  • Deployment
    • See also
• Jam.py programming
  • Task tree
    • Video
  • Workflow
    • Video
  • Working with modules
  • Client side programming
    • Index.html
    • Initializing application
    • Forms
    • Form templates
    • Form events
    • Form options
    • Form examples
    • Data-aware controls
  • Data programming
    • Dataset
    • Navigating datasets
    • Modifying datasets
    • Fields
    • Common fields
    • Lookup fields
    • Filtering records
    • Filters
    • Details
  • Server side programming
    • on_apply events
    • on_open_events
  • Programming reports
    • Report templates
    • Creating a report
    • Report parameters
    • Client-side report programming
    • Server-side report programming
• Jam.py FAQ
  • What is the difference between catalogs and journals
  • Howto upgrade an already created project to a new version of jampy?
  • What are foreign keys used for?
  • Can I use other libraries in my application
  • When printing a report I get an ods file instead of pdf
• How to
  • How to install Jam.py on Windows
    • Install Python
    • About pip
    • Setting up a virtual environment
    • Install Jam.py
    • Common pitfalls
  • How to implement a many-to-many relationship
  • How to migrate development to production
    • New project migration
    • Existing project migration
    • Importing metadata with the http server process shutdown
    • Importing metadata without the http server process shutdown
  • How to migrate to another database
  • How to deploy
    • How to deploy project on PythonAnywhere
    • A step-by-step guide to deploy a Jam.py on the AWS
    • How to deploy jam-py app at Linux Apache http server?
    • How to do with Nginx with Gunicorn?
  • How do I write functions which have a global scope
  • How to validate field value
  • How to add a button to a form
  • How to execute script from client
  • How to change style and attributes of form elements
  • How to create a custom menu
  • How to append a record using an edit form without opening a view form?
  • How to prohibit changing record
  • How to link two tables
  • How change field value of selected records
  • How to save edit form without closing it
  • How to save changes to two tables in same transaction on the server
  • How to prevent duplicate values in a table field
  • How to implement some sort of basic multi-tenancy? For example, to have users with separate data.
  • Can I use Jam.py with existing database
  • How can I use data from other database tables
  • How I can process a request or get some data from other application or service
  • How can I perform calculations in the background
  • Is it supported to have details inside details?
  • Export to / import from csv files
  • Authentication
    • How to authenticate from custom users table
    • How to create registration form
    • How to give user ability to change the password
• Business application builder
  • Project management
    • Parameters
    • Database
    • Export
    • Import
    • Find
    • Print
    • Export/import metadata
  • Roles
  • Users
    • See also
  • Code editor
  • Task
  • Groups
    • Item Group Editor
    • Report Group Editor
    • Detail Group Editor
  • Items
    • Item Editor Dialog
    • Field Editor Dialog
    • Edit Form Dialog
    • View Form Dialog
    • Filters Dialog
    • Details Dialog
    • Order Dialog
    • Indices Dialog
    • Foreign Keys Dialog
    • Reports Dialog
  • Details
  • Lookup List Dialog
  • Intergation with existing database
  • Saving audit trail/change history made by users
  • Record locking
  • Language support
    • Language locale
    • Language translation
  • Language translation
• Jam.py class reference
  • Client side (javascript) class reference
    • AbstractItem class
    • Task class
    • Group class
    • Item class
    • Detail class
    • Reports class
    • Report class
    • Field class
    • Filter class
  • Server side (python) class reference
    • App class
    • AbstractItem class
    • Task class
    • Group class
    • Item class
    • Detail class
    • Reports class
    • Report class
    • Field class
    • Filter class
• Release notes
  • Version 1
  • Version 2
  • Version 3
  • Version 4
    • Version 4.0.70
    • Version 4.0.71
    • Version 4.0.74
    • Version 4.0.78
    • Version 4.0.79
    • Version 4.0.81
    • Version 4.0.84
    • Version 4.0.88
  • Version 5
    • Version 5.0.1
    • Version 5.1.1
    • Version 5.2.1
    • Version 5.3.1
    • Version 5.3.3
    • Version 5.4.1
    • Version 5.4.11
    • Version 5.4.14
    • Version 5.4.15
    • Version 5.4.21
    • Version 5.4.22
    • Version 5.4.23
    • Version 5.4.24
    • Version 5.4.27
    • Version 5.4.29
    • Version 5.4.30
    • Version 5.4.31
    • Version 5.4.36
    • Version 5.4.37
    • Version 5.4.40
    • Version 5.4.53
    • Version 5.4.54
    • Version 5.4.56
    • Version 5.4.57
    • Version 5.4.60
    • Version 5.4.69
    • Version 5.4.109
  • Jam.py roadmap
• Jam.py Application Design Tips
  • Development Checklist
    • Development Checklist
    • Choosing the Web Server
    • Choosing the Database
    • admin.sqlite Database
  • Application Design
    • Getting Started
    • Top 5 Questions
    • Terminology
    • Journal/Detail (or Master/Child) scenario
    • Forms, Buttons and other user interaction items
    • Bulk updates, inserts or delete
    • Authentication Decision
    • User Registration Form
    • Forgotten Password Method
    • Using Python libraries
    • Generated Images
  • “How-to” guides
    • How to install Jam.py on Windows
  • How was Demo built?
    • Demo project
    • Demo database
    • What to expect?
    • Ok, how do I start?
    • A little code
    • More code
    • Server code
    • index.html
    • Dashboard
  • MS Access migration
    • MS Access migration
    • Top Migration Questions
    • Where from here?
    • Now what?
    • Some migrated examples
  • Acknowledgements
    • About the author