Hi,
I’m working on a use case where "Programs" (stored in a custom table) are triggered based on Record Producer intake variables.
Current design:
- Users submit a Record Producer (Intake Form)
- Intake variables are evaluated using a Decision Table
- Based on the decision table output, one or more Programs get triggered and will be added in a List collector field
- The trigger logic works correctly, and data is present in the Decision Table
Challenge: I need to build Report and Dashboard showing:
- Which Programs were triggered
- Based on which intake variables
- Conditions between variables (AND/OR)
- Frequency / trend of Program triggers
However, Decision Tables are not directly reportable, and the evaluated results are not stored by default.
Question: What is the recommended approach to store Decision Table evaluation results so that:
- Each intake submission and its evaluated result is captured
- Reports and dashboards can be created
Any best practices or sample design suggestions would be really helpful.
Thank you!
