How to get all questions/answers from a section in a form in automation?

[Kieran Fisher]

I have a form which has a dropdown for selecting a category. Based on this selection we have multiple conditional sections with 6 questions each. Each of these questions is weighted and that weight is displayed in their description. I've given each of these a field key with the format: <change_category> - Q1, <change_category> - Q2, etc. I would have preferred just Q1-6 but those would be duplicate keys.

In my automation, which is triggered by the form submission, I'd like to get all of the answers in the section and if the answer is "Yes" then cast the description to a float and add it to a running total.

I have tried to create smart variables using the change category and append " - Q1", " - Q2" to them, but that wasn't returning any values when I tried to fetch form fields using them.


I am also unable to grab the description from the field, even when calling it explicitly by the field key:
{{forms.last.Interface Configuration - Q1.description}}

Currrently, I've implemented this using an absurd amount of If statements to reference each field explicitly but that's not preferable.

[John Funk · Accepted solution]

Hi Kieran,

Can you share a screenshot of your field key from the form? Also, I suggest not using any spaces in the field key to see if that helps. I have not tried to get the description of a field before. Nor do I remember seeing any documentation that you can retrieve that. Is there something somewhere that leads you to believe that you should be able to get the description of a field? 

[Kieran Fisher]

Hi John, here's a screenshot of some of the field keys, they do indeed have spaces so I'll try remove those and see what happens, thanks for the tip! 

Regarding the description, I haven't seen any documentation either, it just seemed like a logical jump from the labels and the answers. 

[Bill Sheboy]

Hi @Kieran Fisher 

Just following up to check if John's suggestions answered your question.  If so, please consider marking this one as "answered".  That will help others with a similar need find solutions faster.  If not, please let the community know what help you need with the rule changes.

Thanks!