I am trying to find a way to get a report on all our active forms in production with following parameters:
Any tips on how to go about this?
(And any explanations on how to use that Ref Form ID? It's just one of those things we've never used and wonder what it is for.)
Matt made some progress on getting some of these data using an SQL query.
But one parameter we are still stuck at is to find out when the form was first imported into prod. We could have used the form promotion property for that, but we haven't used it for all our forms and we need this report to be backwards compatible.
The form import log doesn't seem to provide a reference to the form it was imported to. And we often have to edit the archive file names when we export them because the path is too long.