Nocoly V6.2: “Where’s This Used?” – Now See References for Worksheets & Fields

UJCEO2A7ABAEG

What’s New

  • View field references
  • View worksheet references
  • A new view in worksheets: Data Management
  • Optimized function editing experience and more functions supported
  • New containers in custom pages: Tab and Card

Reference relationships

Worksheet references

When modifying or deleting a worksheet, dependent functionalities may experience data errors or broken relationships. This update highlights critical worksheet references to help users assess risks before making changes.

  1. View worksheet references in:
    • More Actions menu of the worksheet
    • ER Diagram
    • Confirmation pop-up when deleting a worksheet
UQW2XJA6ABAGY BCL2XJA6ABACA 4HTKXJA6ACAGU
  1. Click to navigate to specific reference locations.

HOBTK2A7ACQA4

  1. With this update, users can view the following worksheet references:
Reference locations
Referenced by worksheets Relationship, Subform, Cascading fields
Referenced by workflows Nodes using the worksheet

Field references

Similarly, modifying or deleting a field may cause data errors or broken relationships in dependent functionalities. This update also highlights critical field references to help users assess risks before making changes.

  1. View field references in:
    • Field settings
    • Confirmation pop-up when deleting a field
    • Confirmation pop-up when modifying field settings

FJJTM2A7ADADM

BTLDM2A7ACAE4

  1. Click to navigate to specific reference locations.

CKFDY2A7ACQCS

  1. After this update, users can view the following field references:
Referenced locations
Referenced by fields Default value (other field values/function/query worksheets not yet supported), Formula, Concat, Autonumber (reference field), OCR (input parameter), API Query (input parameter), Barcode (data source), Subform (duplicate values are not allowed in this record), Relationship (selection scope), Cascading (filter data source/specified start item), Foreign Field (related record/display field), Rollup (related worksheet/rollup field/rollup range)
Referenced by workflows Filter conditions in all nodes, all dynamic values, initiator/approver/filler/notifier, get user info (members field)
Referenced by business rules Filter conditions
Referenced by views General settings: filters, filter list; Board (grouping field), Resource (resource field/filter for display items/start field/end field), Org (related field in current worksheet/start level-items meeting conditions-filters), Calendar (start field/end field), Map (positioning field), Gantt (start field/end field/grouping field)

View

A new view in worksheets: Data Management

This update introduces the Data Management view, providing application administrators with global data control capabilities. Displaying all records in table format, this view bypasses all business rules, field permissions, and function switches restrictions, allowing admins to view and edit all fields (excluding fields like Formula, Concat, Autonumber, etc.) while retaining full system functionalities such as printing and custom actions.

Use Case:

When certain fields are locked or hidden due to business rules, application administrators can still access and maintain data, offering a comprehensive overview.

Key Features:

  1. Access entry:
    • Visible only to application admins on PC.
    • Path: Worksheet > All Views > Data Management
  2. Functionality:
    • Not displayed in view lists when configuring roles permissions or function switches.
    • It supports bulk record deletion and batch data calibration.
    • Newly created records display all fields (including hidden ones).
    • Newly created records allow editing all fields (except read-only fields like formula and autonumber).
    • Always enable print templates and custom actions (subject to activation conditions but not usage scope restrictions).
    • Bypass field visibility settings, business rule restrictions, and function switch states.
  3. View configuration:
    • Does not support:
      • Filter or display field settings.
      • Mobile display or link parameter configurations.

5H5QZBI6AAQEU

C3XQ3BI6ACAAE

Table view: enhanced column styling configuration

This update introduces advanced column styling configuration for table views, supporting field alignment, fixed column widths, and cell display styles across 20+ field types. These flexible presentation options enhance data readability and enable more professional data displays.

Additionally, users can now apply column style settings to other table views within the same worksheet, ensuring visual consistency and reducing maintenance effort.

  1. Field alignment
    • Options: left, center, right, system default (Number field: right-aligned by default; other fields: left-aligned)
    • Supported field types:
      • Basic: Text, Telephone, Number (except Progress), Currency, Email, ID number, Region/City, Date, DateTime, Time, Single/Multi-select
      • Advanced: Autonumber, Check item, Formula, Concat, Level, Positioning
      • Others: Creation time, Modification time, Rollup, Cascading, Foreign Field (if related field supports)
    • Support batch alignment configuration
  2. Column width settings
    • Pixel-precise adjustment (20-1000px)
    • Auto-fit width for text type fields (dynamically match content length)
  3. Cell display styles
    • Single-select fields: Label/Cell background color/Progress bar/Plain text
    • Attachment thumbnails: Rectangle/Circle

5XNCFBI6ACQEW

TXKCDBI6ACAD2

  1. Apply settings to other table views
    • “Apply column styles to other table views” option:
      • If checked, sync alignment, width, and cell display styles across all table views in the worksheet; when unchecked, maintain independent styling for each view

6RVCJBI6ACQFE

Custom title fields in views

Application admins can configure title display rules for different view types, enabling flexible multi-dimensional data identification.

Use Case

In a work hours worksheet, employee ID is typically used as the title field; however, in calendar views, “Name + Hours” as the title provides clearer visibility for managers.

More details:

  1. Use the worksheet’s title field by default.
  2. Card-style views
    • Views: Board/Gallery/Org/Map/Details (multiple records)
    • Configuration: Select a single field as title
    • Path: Configure View > Card Settings > Caption
  3. Time-based views
    • Views: Resources/Calendar/Gantt
    • Configuration: Multiple fields combined with text as title
    • Path: Configure View > Label

2LAWXAI6ABAFW

KZL25BI6AAAF6

Optimizations for card display settings in views

This update enhances card display configurations with additional customization options:

  1. When displaying circular or rectangular covers, users can now set the image fill mode to either Fill or Fit (previously only Fill was available).
  2. For circular or rectangular covers, users can now position the cover at the top (previously only Left/Right were supported).
  3. Users can configure the maximum lines for summary information (previously fixed at 3 lines).

D4WKFEA6ADAFM

Default sorting in view configuration

This update divides view’s sorting settings into custom sorting and default sorting:

  • Custom sorting: User-defined sorting methods
  • Default sorting: Applied when:
    • No custom sorting is set, or
    • Custom sorting yields tied records (e.g., when sorting by non-unique field values like options or members field)
    • Supported sorting fields: Creation time or last modified time only

Note: Include default sorting fields when creating indexes for optimal performance. Default sorting may be disabled if custom sorting uses unique-value fields (e.g., Autonumber).

6GOT22A7ADAH2

Field

Optimized function editing experience

  1. Field searching is available during function editing.

47XYTJI6AAQES

  1. Real-time error detection and prompts.

EG3IVJI6ACQCM

  1. Function testing: enter static test values or select existing records for testing.Note: Testing only validates the current field’s function logic (excludes parameter defaults, business rules, custom events, and workflows).

3A6YZJI6ACQDC

  1. Optimizations also applied to workflow functions.

More functions supported

Type Function
Math function
  • PI
  • RADIANS
  • DEGREES
  • SIN
  • COS
  • TAN
  • COT
  • ASIN
  • ACOS
  • ATAN
  • ACOT
  • NORM_S_DIST
  • PERMUT
  • COMBIN
Text function
  • SUBSTITUTE
  • STRREVERSE
Logical function
  • IFS
Date function
  • WORKDAY
  • WORKDAY_INTL
  • WEEKNUM

Text fields support Markdown input

Text fields can be configured with Markdown input, allowing formatted display on record detail pages and providing full-screen editing mode for Markdown-input text fields.

AUU5XAA6ABACI

WCRPDAA6AAQES

File field – Mobile input – Set dynamic field values as photo watermarks

Users can now select dynamic values of text-type fields in the current worksheet as watermarks when taking photos and uploading attachments in the mobile app.

Supported fields: Text, Number, Currency, Date, Time, Telephone.Multiple dynamic values can be selected.

IR3D62A7AAAEC

Improved subform data import experience

Optimized data loading after importing to subforms to prevent data loss.

Enhanced keyboard interaction when pasting data into subforms.

Workflow

New “Get array objects” node in workflow plugin

This update adds a “Get array objects” node to the workflow plugin. The node can retrieve object arrays output by “Send API Request”, “JSON Parsing”, or “Code Block” nodes in the workflow plugin, and output them as object arrays in the plugin’s output node.

ZJLF3AQ6ABAE2

Subflow reusability: Convert subflow to PBP/Date field-triggered workflow to subflow

Subflows with object array data sources can now be converted into packaged business processes (PBPs). Parameters from the subflow data source will automatically become input parameters for the PBP. The conversion creates a copy of the PBP without deleting the original subflow.

Additionally, date field-triggered workflows can now also be converted into subflows.

K3VGDAQ6ADAHM

GQ2WHAQ6AAABM

Expanded workflow parameter types and descriptions

Workflow parameters now support arrays and object arrays, including parameter descriptions. For number, personnel, department, and organizational role parameters, users can set increment/decrement operations in the “Update Parameters” node.

5Y6GLAQ6ADAGQ

Subflow’s object array elements support descriptions and titles

For subflows with object array data sources, users can now add descriptions and set titles for array elements. Title field values are visible when viewing workflow logs.

AGHWTAQ6ACAEY

Enhanced to-do delegation

Users can now select to delegate workflows within specific apps when creating to-do delegations, instead of being limited to all workflows. Multiple delegations can be created within the same organization.

X5VKBAA6AAAFE

DeepSeek model added to AIGC nodes

The “AI Generated Text” and “AI Data Object Generator” nodes in workflows now include the DeepSeek-V3 model (currently integrated with Alibaba Cloud DeepSeek-v3-671B).

Department selection in notification nodes now includes sub-departments

In sending notification nodes, selecting a department automatically includes all its sub-departments, eliminating the need for manual selection.

ZZX2FCQ6ABQEU

Approval node – current approver can designate next approvers

Upon completing the current approval node, cuurent approvers can now dynamically assign approvers for the next approval node based on actual needs.

3VLRTCQ6ABAA2

Initiate Approval Flow node – Email notification

The Initiate Approval Flow node now includes an “Email notification” option. When configured notification content in Approval node, the system will automatically email the initiator when the approval is approved, rejected, or returned, keeping them informed of approval status in real-time.

27NRNCQ6ABQFM

XHUBNCQ6ABQCU

Custom Page and Chart

New containers in custom pages: Tab and Card

Tab

Create multiple tabs in a custom page to categorize components, displaying more content, and improving navigation efficiency.

UIDNNCQ6ABAFA

Card

Group multiple components into a card for intuitive content presentation and flexible page layouts.

IQY5NCQ6AAQAU

Chart: support for up to 18 custom colors and personal palettes

To enhance data visualization, we’ve upgraded chart color settings with:

18 custom colors – Richer color options for better data differentiation.

Save personal palettes – Save frequently-used color combinations for quick access.

3UUNPCQ6ADQDS

Organization Management

To-do Delegation section in organization management page

Organization admins can view and manage all active to-do delegations within the organization.

F62ABAI6ABQGW

Add “Delegation & Handover” permission in admin settings.

5QQTHJI6ACACG

General Settings – Custom Color: up to 18 custom colors

The “General Settings” section in organization management now supports up to 18 custom colors for use in custom page operations.

CDVQTCQ6ABQE2

Other Improvements

Online editing before printing

Users can now edit Word/Excel template-generated print files online before printing.

  1. Edits are not saved – only applied to current print.
  2. This requires admin configuration (disabled by default).
  3. This is not available for batch printing.

Export view plugins with applications

View plugins used in applications are now included during export. Exported plugins remain application-specific and won’t appear in the organization’s plugin list.

Role editing: search application items by name

When editing roles and permissions, users can now search for applications and views by name.

Z5Q6A6Y6ABAEG

Bulk edit user’s data permissions

When editing user permissions, it now supports batch modification of data permissions, which will apply to all selected worksheets.

DKVL5UQ6AAQDO

5H3L5UQ6ADAFK

Customize frequent collaborators

Users can freely add frequently collaborated members and drag and drop to reorder them.

Customized members will be added to “All”. Members not from current organizations won’t be displayed if switching organizations.

2SO6O7Y6ACQBA

HWZ6W7Y6AAACK

When choosing an option-set selection field as a filter condition, dynamic values can now select fields that share the same option set

For business rules and field settings (e.g., setting default values via worksheet queries, relationship fields, cascading fields, query records fields, etc.), when the filter field is a selection field with option set, for dynamic values, users can now select fields that share the same option set.

OTS6WZY7ACQEG

Language configuration included in app import/upgrade

App language configurations are now preserved during import and upgrade. New language items from source apps are added; existing language items in target apps remain unchanged.

Interface Push node: Add recipients

Interface Push node now allows setting specific recipients for targeted messaging.

A5BRK2A7ADQGO

Mobile App – Tab Bar: Customizable app items

For tab bar layouts, users can now customize which app items are displayed.

RIJBW2A7AAABM

 

About Nocoly

Nocoly is founded by a group of  enterprise software industry veterans, who believe many of the industry’s problems need to be addressed by different ways.

  • –  DevOps is getting extremely expensive for both ISVs and end customers.
  • – Enterprise suite apps are too complicated to implement in many occasions.
  • – The people who has the business know how and the people who can develop apps are always departed.

Nocoly’s flagship product, Hyper Application Platform (HAP) is a response for all above challenges. It starts from a No Code application building approach, and expand its capability by adding Hyper Automation and Integration features. This versatility makes HAP a handy tool when solve variety of digital management problems. 

With Cloud Native architecture, HAP is so easy to be installed on customer’s own cloud. On Premise is not expensive any more. You can even get a buy-out pricing option to dramatically reduce your IT spending and subscription burden.

Also, our production innovation optimizes business model. VAR partners can participate into HAP’s ecosystem to build their own vertical solutions and achieve much higher return on investment. 

There are still many heavy and expensive stuff in enterprise digitization domain, such as big data, internet of things, analytics and AIGC implementation. Nocoly’s mission is to make more of them nocoly. 

Our product is already in many clouds worldwide. Getting HAP up and running is easy and quick.  Jump to our SaaS signup or install on your own server can be minutes away. Begin your HAP story today.