- New
- Support for long queries
- Ozma now waits for a response from the database, even for queries taking 2-3 minutes
- Improvement in event logging
- Customizable user view
- Banner contact editing
- First page button
- A "to the first page" button has been added to the page switching window on forms
- Trigger error calls
- The cancelWith error call from triggers now works
- Multilingual support
- Users can now add translations to Ozma for different database users
- Fixes
- Form styles
- Fixed styles for some cases when fields overlapped on forms
- Menu styles
- Various minor errors
- Various minor errors have been fixed
- New
- FunQL supports split_part() function
- Update a few hardcoded captures and translations
- Fixes
- Fix the scroll kanban board column on mobile
- Fix a user story with a selection from a popup
And +6 features are done but the documentation is not ready — will describe them soon.
- New
- New interface design and a lot of related small fixes
- Translation to Spanish for hardcoded buttons and hovers
- Now users of ozma can switch language to Spanish
- Add information about how to call actions to the FunAPI wiki page
- External links from embedded pages don't work
- Implement operators
.@ and .@@
- Mappings for enum arrays and function for getting a list of enum values
- Wiki article about roles configuration
- Allow choosing language on instance level
- Allow choosing language on user level
- Fixes
- A lot of small fixes related to the design
- New
- Wiki article about using iframes
- Wiki article about creating dashboards
- soft_disabled / disable_insert in kanban view
- Hide errors when not authorized
- Add stack trace to action exceptions in events
- Fixes
- Translate to EN admin.ozma.io
- Translate reditect_register page to english
- Сontent on the kanban card isn't clickable
- Error "Cannot read properties of undefined (reading 'deleted")"
- Do not display "read-only field" icon with buttons and nested forms
- Variants are not applied when no preferred theme is set
- Sometimes table is stuck and you can't load more rows
- Burger and kebab menus dont close after switching to another view
- Fix small text error in demo modal
- Autosavings is not working
- User can change value of soft_disabled field using hotkeys
- Reference fields with phones and emails became unclickable
- Reference fields in tables don't block autosave
- New
- Use filters auto-apply as default and create a new attribute for "apply" button option
- CHECK restrictions for roles
- Debounce arguments application when auto-applying
- Fixes
- "Apply filters" button isn't visible in some cases
- New
- Apply color variant to options with caption in reference fields
- Remember order for enum entries
- Wiki article about actions
- Wiki article about triggers
- cell_variant for card field in kanban
- Developer Mode
- Disable autosave by default when entity has triggers
- Cascade delete (applied guide with examples without abstract details)
- Copy schemas and data during save_restore
- Show @text in kanban cards and in column names by default
- Try to re-connect on connection error
- Add on premises prices to prices page
- Fixes
- Problem with '__main' in reference fields with null values
- Table mass inserts fail on last row with enums
- Do not copy data from public.events when cloning instances
- Popup Modal creation broken
- Boolean field value is set to false in previous record when user adds a new row
- Buttons don't work after opening any popup (on mobile)
- Autofocus in table broken
- Burger menu overlays title on forms
- "Full screen" button overlays "close" button on mobile forms
- Tables refactoring
- Nullable argument with numeric type throws an error
- Сreating new record in modal requires page reload
- Problems with search in big tables
- soft_disabled field attribute doesn't work with references
- Fix time picker
- Fix copy/paste in table
- Filters can't be applied after clearing once
- Fix add record with autosaves problem in tables
- In-place edit window in big tables opens in random places
- Modal window closes while creating a new record from table
- Strange sub_entity value in entity inheritance
- Wysiwyg editor freezes in mobile browsers
- Small style fixes
- Layers order problems on mobile
- Long form opened in modal scrolls down automatically
- Еmpty argument values are passed to another view with NULL values and break it due to the conversion to empty array
- Default values in argument editor are applied without being displayed in filter fields
- Fix scrolling and copy-paste processes in table multilines (mobile, pc)
- Error "Cannot read properties of undefined (reading 'deleted")"
- Table that opens in full screen scrolls to the middle
- Unable to create new row in table view
- Page layout is broken on some userviews
- Closed argument editor reopens after changing data in table on mobile
- Problem with
array(string) type arguments conversion
- Pasting datetime does not set it in the editing control
- Search in numeric fields doesn't work
- New
- Update autosaves in admin scheme
- Button "Filters" in admin scheme
- "Enter" and "Tab" button behavior in edit mode in tables
- Article with runCommand() examples.
- Add indexes for public.events
- Fixes
- Copied table cell is pasted as a double quoted string
- Disable on mobile “all synced” button
- New
- Options_view for multiselect
- Autosave to cnahge focus
- Display small button in table header, that will show/hide arguments editor.
- Improving "+ Add entry" buttons in tables
- New x-erp.ozma.org (ERP) instance now open to the internet
- New x-pm.ozma.org (Task manager) instance now open to the internet
- Rename all technical captions
- Update help page styles
- Add loading icon instead of loading bar
- Change behavior of "to full screen" button
- New example of api check_access added.
- Button "home" in modal windows removed
- "Saved" icon to be sure all saved
- Disabled background color for markdown in review mode
- Add helps to all admin pages for acmeinc-crm
- Return JSON errors from report generator
- Update some styles
- Add an action for acmeinc-crm - new people for new user
- Fixes
- Modal window displays incorrectly if screen is split vertically
- Hide x-scroll for invite form
- Add funapp.embedded_pages to funapp.observer role
- Select options for dragging/dropping kanban card
- Еrror while exporting admin schema in it-template instance
- New
- Support selection of many cells in tables
- Paste multiple cells in table
- Help pages for user view.
- Help button with partner's contacts.
- Now you can create demo instances for clients.
- Query args editor for userviews. Multiple select in argument field. Add example with nullable param in UV.
- New attribute for the form, that opens after saving a new record.
- Reference fields with restrictions updated.
- Calling DML commands: UPDATE, DELETE etc.
- Pages or lazy loading for user views.
- Add docs and example with href in the menu ('https://google.com for example).
- Attribute for fields that cant be edited by condition 'soft_disabled'.
- Actions on multiple rows.
- Add attribute for disabling auto-saves 'disable_auto_save'.
- Support more than one
create_link in tables.
- Color variants docs updated.
- Roles docs updated.
- Add autofocus for the first input in /new form
- Make service for invites and add invites button to the main screen
- Hide "Edit user view" button for simple users
- Hide add/delete buttons when access denied by role
- Remove seconds from all datetime fields by default
- Update menu urls for application
- Update calendar controller style
- Update default styles
- Update params styles
- Multiselect design update
- User View height limits
- Add to admin.ozma.io new button: clone schemas
- Add new button to admin panel: "copy schemas" from other instance (not clone)
- Add support for attributes in userview arguments
- Add new buttons from metaapp to burger menu for all instances
- Add way to save unchanged new entries
- Fixes
- Block small arrow animation for dropdown lists for disabled fields
- Cell variants dont work correctly until first changing the theme
- Temporary fix for errors from actions
- @Soft_disabled attribute for tables requires a page reload
- Fix copy-pasting formatted number cells
- Fix buttons appended on long inputs
- Error in reference field if reference entity has no main field
- Refresh tooltips when new UV opened
- Fix white screen in document generator
- board_order field creation kanban problem
- Fix kanban cards design for moving
- Fix z-index for calendar and next/prev buttons
- New
- Make week order locale-depended in datepicker
- Translate light and dark theme names
- Fixes
- Problem with displaying the rightmost header
- ReferenceField UV clear-all button not working sometimes
- Problem with incorrect main_field
- Empty values in multiselects in new entry forms
select_view doesn't closes modal on save- Fix 'ctrl-s' hotkey in modals
- Variants for buttons problem
- New
- Batch edit in tables
- admin.ozma.io restyle
- Show document-generator errors in frontend
- Confirmation popup or something like this on closing modal with unsaved changes
- Keep current page in views with pagination in URL
- Upgrade select in tables
- Open next/prev modal depended on table
- Replace title in /new forms
- Show link button on inputs with links
- Use Russian translate for ru locale for admin.ozma.io
- Sort added rows in tables too
- Redesign "Save" button
- Make table in "funapp" schema for iframe codes
- Rename "Создать в модале" to "Создать в модальном окне"
- Fixes
- Tooltips don't close sometimes on mobile
- Fix no templates illusion on admin.ozma.io
- Fix soft disable for dates
- Buttons style problems
- Add ability to remove "plus" buttons for creating child records in trees
- Empty values in multiselects
- target="_blank" does not work in banners
- List in reference field opens down in last table rows
- Problem with dropdown buttons in table cells
- Make themes available for unauthorized users on acmeinc.ozma.org
- New
- User View for charts/plots/graphs
- Make consistent color theming system
- Add notifications to menus
- Styles update
- Redesign disabled inputs
- Update default time for datetime field
- Add attribute for hiding first column with checkboxes in tables
- Fixes
- Style fixes
- "connection pool exhausted" problem
- Redirect before first document generation using generator
- New
- PWA for ozma.io
- Update header and button styles
- Implementation of a universal scanner for multiple entry of the Bar code and QRcode
- Implement generic buttons
- Implement a universal QR/Bar code scanner through the camera
- Renaming barcode attributes
- Display buttons in table horizontally
- Add opportunity specify the QRcode encoding
- Implement adding a row below the current row in a table
- Scrolling in panel buttons list
- Fixes
- Transparency issues with multi-select fields
- New title length for mobile
- Fix loading style on loaded headers
- Tree user view is broken with specific data
- New
- Write article about document generation
- Scanning text from bar/qrcodes to string inputs
- Font sizes in text input fields and date/datetime input fields are different
- Fixes
- Autosaves dont work in timelines in modal windows
- Ids in kanban column titles
- Use translation instead of data_will_load_after_save in /new forms
- New
- Comments (or chat) functionality for any user view
- Support keyboard control on tables
- Resizable and draggable modals
- Add attribute for fraction digits number in tables
- Move input field icons to the right
- Add spinner/skeleton loaders to MarkdownEditor and maybe something else
- New border radius for references and enums
- Fixes
- Fix interaction with nullable checkboxes in tables
- Interface bug with panel buttons when new row adding
- Fix time in timeline user view
- Fix tabbed modals on mobile
- Fix copy-pasting reference fields in tables
- Fix kanban cursor styles
- Crash in V8 when .js extension is used
- Copying data from email and tel fields
- Two focuses on one form
- Fix infinite loading indicator on ValueSelect in tables
- Style problem with header in tables for safari
- Boolean field in table looks different from cell in first column
- Date and datetime input problem
- Unable to insert copied value from cell into search input
- Fix 'add entry' table button on horizontal scrolling
- New
- Language-sensitive representation of integer and decimal numbers
- New default template for instance creating
- Fix tree state change
- Add shared templates for create and reset options in admin
- Reverse list of scanned items (qr, bar codes)
- Fixes
- Fix strange behaviour of "back" button on modal by iphone
- Update kanban styles for cards moving
- Long names in reference fields on mobile overflow
- Delete close button in a circle
- Fix search field closing/clearing in nested views
- New
- Частичная загрузка данных для reference fieldов
- Bar-codes recognition
- QR-codes recognition
- Scan QR code with scanner
- Different behaviour for banner_important setting for
True and true values
- Panel buttons in inline user views
- Add transitions to userview changes and userview loads
- Move qrcode_input attribute from Input component to ReferenceMultiSelect
- Block horizontal scroll for mobile (except subuserviews)
- Restrict title length on form in mobile version
- Update mobile modal styles
- Add spinner to login page
- No white background color for some cases
- Add button "Scan barcode" in table (not in "...")
- Add important global banners
- Fixes
- Fix tree problem for long text
- There are no panel buttons in modal windows
- Fix problems with banner for safari
- Cleanup funadmin after UI updates
- Table is scrolled up after saving changes
- Input control for required enum field in not displayed
- Pointer for the unactive zone in multyselects
- Date picker problem for right part of screen
- Required fields are not highlighted
- Fix popups (autofocus; z-index)
- Calendar window doesn't open in full size
- Multiple input via barcodes does not work
- Data in table is not loaded again after changes in UserView code
- Restyle titles for mobile
- Fix titles for subuserviews when record is new
- Update mobile titles for UVs
- Attribute @visible with CASE doesn't work
- Fix "..." button position
- Strange space for subtables on mobile
- Fix multiselect popup position in edge cases
- Number of records in full table and in table on form is different
- New
- Different font sizes for mobile and desktop
- Add
max_width form attribute
- New special message for all instance by settings
- Use Bootstrap for as much components as possible
- Update menu entries styles
- Save changes instantaneously by default
- Actions for buttons in table
- Remove input edit modals on mobile
- Fixes
- Fix wrong label problem
- Old data in markdown field when open connected record in modal
- Position of reference fields on form
- Plus button in empty table
- Update data field on mobile
- Set background color for buttons in tables
- Scroll to top when moving between different user views
- Adding new entries in mobile table immediately opens a cell for editing
- New
- Make icon buttons change on hover
- Change behavior of boolean field
- Add skeleton loaders
- Update menu design settings
- Allow material design icons in menu
- Update modal windows design
- New placeholder for dates and datetimes
- Cursor for the title on modal is a pointer, but nothing happened on click
- Decrease distance between blocks in menu on mobile
- Fixes
- Restyle text editor borders
- Redesign codeeditor field
- Inline windows in different tables on the same form don't close
- "Unknown user view fetch error: generic" for users who are not added to public.users
- Fix some lines style in tables
- Fix creating new record in modal window from table
- Problem with default values on forms
- Update mask for autolinks for telephones and emails
- Remove restriction that doesn't allow scanning same QR-codes in a row
- Upper part of menu is inaccessible when desktop viewport is too small
- Add "return to databases" button to account settings
- Update spaces on forms
- New
- Do something with adding rows in table
- Update modal windows design
- Add "..." button to the fullscreen UVs (same as modal UVs)
- Correction of multi-select behavior
- Remove the red line from the kanban background
- Tree table User View
- Attribute for hiding/showing all records in tree view
- Fixes
- Problem with multiselect
- Fix default issues for record creation in tables
- "Three dots" menus are always empty on mobile
- Problem with codeeditor in tables
- Problem with table titles on forms
- Fix form padding in fullscreen view
- Fix bug on views type 'form'
- Problem with case in link attribute in fields attributes
- Save entry in modal on mobile is impossible
- Closing cell edit modal on mobile is impossible
- Bug with save and search
- @menu_centered attribute doesn't work
- New
- Rename trees attribute and find IDs out differently
- mailto: and tel: hrefs in texts and select fields
- Autodelete new empty records
- Solve task about icon from new menu
- Default cell_color attribute for date field doesnt work on form
- Open modal window to full page in mobile version
- Improve behavior of field with tree row
- Fixes
- Required text fields saves whitespaces-only text as empty string
- Default cell_color attribute for date field doesnt work on form
- Records in tree view are shifted to the end of table after modification
- Multiline textbox is wider than other input fields on form
- Default_values problem for the new record from kanban
- Update icons style for kanban cards
- New
- Рекурсивные SQL-запросы
- Update align default options
- Text in text areas is not well readable when errored once
- Inline userviews design before saving
- Fixes
- Required field with date type is not highlighted in FormControl
- strange behavior with @block_sizes attribute
- View's menu don't open under button
- Text fields in forms have an extra offset compared to reference fields
- Fix many selections in many subtables in a same time
- New
- New order for all buttons in ozma
- Add text editor to some multiline fields (markdown for example)
- Appearance of select fields in tables
- Fixes
- Linked_view design in tables
- New
- Move the error message
- Update datatimepicker
- Redesign process of creation for new records
- Remove one of linked_view options — underline
- Add
?__export_to_csv feature by the attribute in UVs
- Fields alignments on forms, tables, and other views
- Restyle error color for fields on froms
- Add menu in modal forms
- Fixes
- No error state in problems reference fields in tables
- New record created in modal window is not substituted in table
- Remove Add button for some cases
- Fix
?__export_to_csv problem
- Fix mobile forms
- Fullscreen button autoselect
- Nested kanban view overlaps fields above it in forms
- Feedback button overshadowed by status line
- No field coloring on error
- New
- Уменьшить ширину полей с галкой и кнопкой "Развернуть"
- Make isMobile a constant, not a function
- Order actions in burger menu and add delimiters
- Update import from csv feature
- Redesign titles
- Remove red light from the kanban
- Move the delete button to the burger menu
- Labels in actions menu have margins
- Add horizontal line under top menu
- Кастомные кнопки и наборы кнопок для бизнес-процессов на любых UV
- Fields background colors in forms by attribute
- Case in the visible attribute
- Change default font size from 16 to 14
- Add a button to download all schemas in one zip file in save_restore
- Implement proper manual sorting of cards in kanban
- Update select and multiselect stiles
- Add function trunc()
- Restyle borders in multilins
- Align captions and fields to the middle on forms
- Decrease vertical distance for rows and heders
- Restyle modal titles
- Add titles to mobile
- Redesign mobile forms
- Increase left padding in fields in forms
- Autosave after focus change in tables by a special attribute
- New button in modal windows — full screen
- The new modal first approach in the interface
- Restyle save and error buttons
- Same design for save button in modal window
- Fixes
- Update kanban styles
- Can't restore all schemas on empty instance
- Autofocus for editing by mobile
- Multi-selects are broken
- Table cells do not receive status highlights if cell with required value is empty after save attempt.
- Error with default value on the form
- Sorting in tables doesn't work
- Sort error with date fields
- Modal window closes by click in text field
- Fix kanban bugs in MAC Safari
- Problem with cell_color attribute
- Empty kanban has style bugs
- Strange search
- New
- Add captions for full-screen User Views
- Show number of cards in kanban column
- Empty space on cards on kanban
- New attribute for modal form — Caption
- Dragging cards by inner text in Firefox triggers links
- Kanban horisontal scroll
- Fixes
- Block height on the form
- Multiselect problem
- Change card move process on kanban
- Window for select field doesn't close
- A datetime problem
- Problem with date and datetime types in javascript generated query
- Table search is broken
- Select field window is open by default
- New
- Реализован базовый функционал бизнес процессов
- Select style in tables for reference fields
- Enum design in tables
- Update search in reference fields
- Tabs design in modals
- Fixes
- Values in select field are not displayed in last rows of table
- More than one click for trigger needed
- New
- Search in inline tables
- Redesign open process for kanban cards
- Redesign edit process in tables
- Change select process in forms and tables
- Change default colors in the table
- Fixes
- Some problems with fixed column and cell select
- New
- Move chat button
- Increase spacing between links and headers in menu view
- Increase distance between icon and text in menu
- Login form position on mobile
- Change label and burger button for inline user views
- Change cell select format
- Move the menu a little bit
- Redesign caption column width
- Возможно стоит подкрутить стили плашек
- Fixes
- Inplace-edit window works incorrectly in tables, that are located on modal forms
- Menu is stucked open
- Второе перетаскиваниес канбан карточки на Safari не работает
- Select cells on tables strange behavior
- New
- Kanban board headers are fixed in height
- New
- Add messenger button with help in first instance
- Selected cell in table must be visible
- Fixes
- ReferenceField не работает на мобилке из таблицы
- New
- API documentation and simple examples
- Сделать модальные окна с открытимы вью на всю ширину телефона — оставить отступ только сверху
- Сделать экран загрузки при переходе между ссылками
- Изменить дефолтные настройки меню
- Fixes
- Forgot Password button doesn’t work
- Userview fetch error on some devices
- Inplace-окно в таблице перекрывает новую строку
- Strange behavior in calendar view on mobile
- Странно работает сортировка по дате
- Пропадает значок поля bool при заполнении новой записи из таблицы
- New
- Изменен дефолтный цвет у MainBorderTextColor
- Hide the 'Export to .csv' button for users without root
- Add attribute "control_height" for multiline input field
- Вернуть табуляцию в иерархическое меню. Табуляция должна быть чем меньше тем лучше, но чтобы было понятно что внутри чего.
- Переименовать в мультиселекте "Удалить всё" на "Очистить" или на крестик
- Fixes
- Fix the "autorisation", "registration" and "forget the password" forms on keycloack
- Modal window closes when you click in select input field
Changes before June 2020 are not recorded.
You can ask us about previous changes.