Currently, through Data connections ProForma can retrieve JSON data from Rest APIs and use this data to populate choice lists on forms.

Forms provide the option to filter the JSON data using "List/Array of Objects." However, they do not provide the option to validate and filter responses based on certain field values.

For example -

• Let's say Forms retrieves details of users and fields in JSON.
• Forms will provide us with option to filter the response based on objects. We can list all the usernames by using "username" object and fields using "fieldname" object.
• Currently when we filter using above filters, Forms will list all the username and field name values present in JSON.
• It would be great if Form would provide us with an option to list certain field names based on username.
  • When we filter "User1", JSON should list only "field 1 and field 2".
  • When we filter "User2", JSON should list only "field 3 and field 4".

Use Case - In Form, the field name and usernames are obtained by "Data Connections". It would be great to have a validation where we can map the field names that should be listed based on usernames.