Dear All,
Currently, our condition-based row-level permissions feature works smoothly for normal conditions, as described in the support article Row-Level Permissions. However, the current feature does not support permissions using a repeat group value. This post shares a workaround solution for using repeat group values to create condition-based permissions by using the if-statement
in a calculate
question type.
In the survey tab of your XLSForm:
In the choices tab of your XLSForm:
Note:
name_share: Shares the project (submission) with another account if the project has name
= Kalyan
in the submission for a text
question type.
age_share: Shares the project (submission) with another account if the project has age
>= 15
in the submission for an integer
question type.
male_share: Shares the project (submission) with another account if the project has gender
= male
in the submission for a select_one
question type.
female_share: Shares the project (submission) with another account if the project has gender
= female
in the submission for a select_one
question type.
all_share: Shares the project (submission) with another account if the project meets any of the criteria above for name_share
, age_share
, male_share
, or female_share
.
Setting Condition-Based Permissions:
- Go to project SETTINGS > Sharing to configure the settings as shown in the image below:
Checking Data/Submissions on the Shared Account:
Once you have configured the permission settings, start collecting data.
Note: Any data collected before the settings were configured will not be shared. Only data collected after the permissions were created will be shared.
Here is a screenshot of the sample data that was shared with one of my projects based on the settings used above:
Reference XLSForm:
Condition-Based Permissions Using a Repeat Group Value.xlsx (27.5 KB)
Alternative Approach Using the Join Function:
Alternatively, you can also use the workaround solution with the Join Function
as prepared by @Xiphware
Join Function.xlsx (11.7 KB)