Jump to content

What table stores PCF form fields


Joyce
 Share

Recommended Posts

  • Victor changed the title to What table stores PCF form fields

yes I think i have a problem. All the values i am after have been recorded in the same form, so has same form ID and are all as answers. so it is difficult to filter ( i am ending up with 4 rows on the same request)

I guess, i was wondering if there is some kind of 'form' table  where the field ID and Answers are recorded as different columns/fields

image.png.c6a131ef6648c17636b38c5368056510.png

 

So i get report as 

image.thumb.png.e459a38722400bbbafdf82eaaa923897.png

 

 

 

Link to comment
Share on other sites

26 minutes ago, Joyce said:

I guess, i was wondering if there is some kind of 'form' table  where the field ID and Answers are recorded as different columns/fields

There is no such thing I'm afraid... what you need where is a sort of a "pivot" functionality which we don't have. I am facing the same issue trying to assist with a report for @SJEaton . The best solution most likely will be is to use PowerBi (https://wiki.hornbill.com/index.php/PowerBI_Reporting)

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...