Recommended configuration patterns

Active reference table

{
  "tableName": "Production Unit",
  "visible": true,
  "requestColumns": [
    "@row.id",
    "PU_ID",
    "Description",
    "Active"
  ],
  "queryFilter": "[Active] = true"
}

This pattern is appropriate for a reference table where only active records should be available to the app. If users do not need to open the table directly, it may still be downloaded and used as reference data. visible controls whether the table appears in the table list; it does not determine whether the data can be used as downloaded reference data.

Hidden reference table

If a table is needed only by components and users do not need to browse it directly:

{
  "tableName": "Production Unit",
  "visible": false,
  "requestColumns": [
    "@row.id",
    "PU_ID",
    "Description",
    "Active"
  ],
  "queryFilter": "[Active] = true"
}

The table can remain available as locally downloaded reference data while being hidden from the table list. Remember that this is a navigation choice, not a security boundary.

Role-specific additional fields

{
  "tableName": "Staff",
  "visible": true,
  "requestColumns": [
    "@row.id",
    "Id",
    "Full Name & ID",
    "Production Unit",
    "Barcode Text"
  ],
  "roleAccess": [
    {
      "role": "B. Farmtrace Developers",
      "isAllowedToView": true,
      "addedColumns": [
        "Email",
        "Phone"
      ],
      "hideColumns": []
    }
  ]
}

Users with the B. Farmtrace Developers role download:

@row.id
Id
Full Name & ID
Production Unit
Barcode Text
Email
Phone

Other roles use the base requestColumns unless another matching role rule exists.

Different fields for different roles

{
  "tableName": "Staff",
  "visible": true,
  "requestColumns": [
    "@row.id",
    "Id",
    "Full Name & ID",
    "Production Unit",
    "Barcode Text",
    "Phone"
  ],
  "roleAccess": [
    {
      "role": "B. Farmtrace Developers",
      "isAllowedToView": true,
      "addedColumns": [
        "Email"
      ],
      "hideColumns": []
    },
    {
      "role": "Field Operators",
      "isAllowedToView": true,
      "addedColumns": [],
      "hideColumns": [
        "Phone"
      ]
    }
  ]
}

Before hiding Phone for Field Operators, confirm that no feature available to that role depends on Phone. This includes:

forms;
reports;
lookups;
scans;
dropdowns;
filters;
posting actions.

Dsync guides

Function setup

Configuration

Formula language

Formula reference

Configuration patterns

Recommended configuration patterns

Active reference table

Hidden reference table

Role-specific additional fields

Different fields for different roles

​Recommended configuration patterns

​Active reference table

​Hidden reference table

​Role-specific additional fields

​Different fields for different roles

Recommended configuration patterns

Active reference table

Hidden reference table

Role-specific additional fields

Different fields for different roles