I’m working on a site where forms are being used for a contest, so contestants will fill in the whole form, but judges should only have access to certain answers. So, for example, the judges wouldn’t have access to the section with their contact info, just the section with their entry. Admins will be able to see the whole entry.
I was thinking of adding a checkbox, similar to the “Required” one, for “Private” so that those questions/answers would only be visible to admins. I found a hook for adding it to the Advanced section, which is fine, if there is no hook to add to the General Tab.
So the next step would be to display those entries in the front end. Any recommendations on how to do this? I don’t mind pulling directly from the DB, but if there is an easier way, I want to know. I also saw someone doing this by creating posts from the entries (do the answers get saved as meta?). I know there are plugins for this, but given the first requirement, I don’t think any of them will do what I want.
Lastly, all forms will be “Save and Continue”, so I will need to be able to pull all completed and partial entries and display them on a page per user (only users can apply to contests). A sort of dashboard so they can log in and see their own entries. Similarly, judges would be able to see only completed applications. Again, is accessing the DB directly the only way? Or are there functions for this?
Will I be able to create this with Gravity Forms? Or should I look elsewhere?
Thanks for any advice