Recent searches


No recent searches

Any way to know what forms had any data in them in a ticket?



Posted May 09, 2024

I've been asked to create a report (in our data warehouse) that identifies tickets that had a specific form filled out - however there are some tickets with multiple forms filled out and the specific form that they want to report on has no unique fields so I can't base the report on field values being filled in. It looks like the data that is available via API and our Domo connector includes what the currently-selected form is, as well as a list of all available forms. But is there any way to identify which forms have ANY data filled in on a ticket? I'm guessing no, but wanted to confirm.


0

2

2 comments

image avatar

Dan Ross

Community Moderator

Hey Paul,

If none of the tickets have unique fields that you can test, you can perhaps test this by checking for the presence of ticket tags that align with your ticket fields? If a ticket has any tags present that matches a field, then you know it at least has some data present.

0


image avatar

Brandon (729)

Zendesk LuminaryUser Group LeaderThe Humblident Award - 2021Community Moderator

Hey Paul -

 

Ticket Forms & Fields are actually not directly tied together directly - that is to say if I fill out a field on Form 1, and then switch to Form 2 where the field is not available, the data will be retained and associated with the field even though it is no longer visible.  

 

Therefore, I believe you would need to look at tickets containing field data and then figure out which forms had those fields associated with them.  As mentioned, you can also determine which form the agent resolved the ticket on.  

 

Hope this helps!

 

Brandon

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post