Forum Discussion
Laura_Thacker
6 years agoQrew Commander
For each Threat entry, I would create a child-table record attached to this parent-entry so that you have a more-reportable set of data which you can filter, group, organize and build summary data from. My fields would be [Threat #], [Threat], [Timing], [Scope], [Severity], [Impact], [Comments]. Then you can do reporting on individual Threat responses across all your entries.
You could build automations to create each child; or build a formula-text field to compile a dataset that can be used by a single webhook (my preference) that would fire on-save.
You could build automations to create each child; or build a formula-text field to compile a dataset that can be used by a single webhook (my preference) that would fire on-save.
- Laura_Thacker6 years agoQrew CommanderI saw you had a follow-up that you might have deleted. Personally I would prefer to build one or two formulas than build 193 automations. It is also much easier to maintain if you end up adding more questions.
I can help you with this, if you would like; but you would need to call me at (626) 771 0454.