Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
minLevel1
maxLevel3
stylecircle

Related pages:

...

Expand
title* Filter Related Submission by

The filter can be applied to multiple fields at once using the following format:
Multiple-filter format:
AND((Field;Operator;Value),(Field;Operator;Value))
OR((Field;Operator;Value),(Field;Operator;Value))
Single filter format:
Field;Operator;Value

Note

Multiple-Filter Format Precautions: Within a multiple-filter format, leaving a response value blank could lead to unexpected behaviour or errors. It's strongly advised to input valid response values to maintain proper filtering functionality. Remember, these response values are case sensitive and must precisely match the values recorded in the submission for effective filtering.

The following Data Types are supported by the filter:
MSPL, Phone, Text, Picklist, Date, Number, Currency, Percent

Case-Sensitive Operator Values: When entering the operator value as part of the filter, ensure it is in uppercase letters, strictly following the Strictly follow the specifications outlined in the Operator Label column of the provided table.

Data Type

Operator Label

Operator Value

MSPL

IncludesINCLUDES

Excludes

EXCLUDES

Phone

Equals'='

Not equal to!='

ContainsLIKE

Does not containNOT LIKE

Text, Picklist

Equals=

Not equal to!=

Starts with

LIKE%

ContainsLIKE

Does not contain

NOT LIKE

Date, Number

Example:

  • ampi__Status__c;Equals;In Progress

  • For a custom field (without an ampi namespace):
    Narrative_Type__c;Not equal to;Budget

Date, Number, Currency, Percent

Equals=

Not equal to!=

Less than<

Greater than>

Less or equal

<=

Greater or equal>=

Info
  1. Phone Data Type Filter: The value passed in the filter for the Phone Data Type should be unformatted. For instance, use unformatted numbers (e.g., 1234567891) instead of formatted ones (e.g., (123) 456-7891). This ensures compatibility and accurate filtering.

  2. Date Data Type Filter: When utilising the Date Data Type filter, ensure the value is formatted in the YYYY-MM-DD format. This format standardises date input for consistent and effective filtering.

  3. Text/Picklist/Phone/MSPL Data Type Recommendations: To prevent unexpected errors or behaviour, refrain from using response values containing specific symbols like "_", ";", and “,” for Text, Picklist, Phone, and MSPL Data Types in your filters. This practice minimizes the potential for issues and ensures smoother operation.

...

  • Object: Question__c

  • Field set name: Add_Edit_Question_Popup

  • Unsupported field types: Encrypted String, Multi-select Picklist, Time

...

Custom Permissions
Status
colourRed
titleNashira v1.38 onwards

This functionality is available Nashira v1.38 onwards.

Label

API Name

Description

Override Locked Submissions

Override_Locked_Submissions

This custom permission grants an exception to the "Response Locked" setting. Assigned users will have access to edit responses within the Submission Response Form even if the Response Locked field on the Submission object is set to TRUE.

...

Submission User Access & Permissions

...