Another month of enhancements. A nice set of new features and fixes although I can't shake the feeling that we can't seem to be able to stop the feature creep. More for things I see coming than what arrives this month. All in all, progress as usual.

• Document Management System keeps going
• Master Grid work continues
  • control paste event from the map, copy-paste functionality, reload detailview after save, open everywhere in the application
• MicroTasks widget and Tasks module. We add a new module to manage our To-Do list. We can write a title, and a date and manage a status of things that need to be managed. We create a widget to easily list and manage these microtasks. This is a work in progress but already looking very good. I will talk about this in another blog post.
• Import enhancements
  • add support for EvolutivoFW Rules based skipping logic. By default, a new record will be created if it doesn't already exist in the application. We can avoid this behavior by checking the Skip record creation (only update) option so that only updates will be done and the other records will be discarded. Now we also support a record-by-record decision of this functionality. If you set a Business Map in the select a rule to decide if we should skip record creation option you will be able to decide if any given record you are importing that doesn't already exist in the application should be skipped or created. We add support for this functionality in the direct import business map
  • add orderby directive in import business mapping to uniquely define FIRST and ALL update directive
• GenDoc
  • add debug messages for foreach sorting and others
  • changing the icons and select to LDS
  • enhance GenDoc_Template_Access to support business maps, now if this global variable returns a business map it will be evaluated to retrieve the list of template IDs that should be shown.
  • construct order by clause for foreach when list sorting is active
  • support text and images with links
• activate Spanish Language on the install
• deactivate 2FA for admin user and add db_host option in reset_admin_pw script
• add checks for database connection with foreign modules in ping.php health endpoint
• move "From Email" setting to Application_FromEmail Global Variable. Finally got rid of that!
• create new fields in survey modules for summarizing notes, a default Not Applicable value and GenDoc template for merging results
• filter related documents when opening the "attach documents" popup in emails
• support more fields (and custom fields) in the purchase order related list
• the EvolutivoFW Updater orderFieldsInBlocks method is now capable of creating the block if it doesn't exist and moving the indicated fields to the new block in order
• apply LDS icons to the standard business actions
• migrate the javascript based static autocomplete to the browser native datalist
• add a generic doJS function in Field Dependency that permits us to execute any javascript code
• operate the OpenStreet Map marker by coordinates instead of address in the OSM EvolutivoFW widget but we still use the address if coordinate fields are not found
• add RELATEDPANES mode in Actions to show different types of panes based on rules
• Validations: add support for asking the user for confirmation by prefixing the message with the special string %%%CONFIRM%%%
• Workflows
  • support multireference field in workflow expressions, mostly we make it work as a related list
  • get last day of month workflow expression
  • return immediately if RAC rule check is done without record ID
  • evaluate validations before saving for updateFieldTask. This enhancement permits us to indicate if we want to run the current validations on the record that is going to be updated to maintain data integrity

• EvolutivoFW Standard Formatting
• Documentation: code and wiki.
  • wiki documentation keeps going
• LDS Styling
• Refactor and Optimize code
  • sonarqube recommendations
  • eliminate reference to deprecated uitype 68
  • add extra measures for foreign module support
  • optimize XLSX export data, faster and less memory-intensive
• Security fixes and updates
  • update DOMPurify to 3.0.6
• PHP constant updates
• Unit Tests: keeps getting more and more assertions.

• Application_FromEmail: The FROM EMAIL setting in Settings > Outgoing Server has always been incredibly misleading. Its functionality is to override the From Email field in all emails being sent by the application. It is a mostly useless, very edge-case feature but since it is so prominent in the configuration of such an important setting of the system it was always getting in the way. I moved it to a global variable where it can be buried and forgotten forever

• eliminate javascript error if calendar activity response is not a valid JSON
• set user type fields (101) to the empty string if not set
• enable related panes for the documents module
• set correct quotes for document download.
• avoid error when we cannot connect to mail server in Mail Manager
• make the app not crash on foreign module connection loss
• removed duplicate HTML element IDs
• check if columns are empty and remove new lines from strings in the Pivot view
• do not list inactive users in Reports sharing options
• ShowSetofFields action is changing to DetailView after the first save of the widget
• Workflow
  • not calculating delay in email and SMS tasks due to inexistent property
  • fix upsertTask bug while saving the record
• Translations

September	October

Thanks for reading.