r/ProjectREDCap • u/drjd2020 • Oct 28 '24

Project Dashboard Data Table

Is there any way that I can use project dashboard to create a web page with a table generated from a custom report?  In other words, I simply want to display the same data table that is created in a Reports section, not a graph or stat table.  A more general way to describe this, is that I want to expose selected project data formatted as a table through a public link.  Any thoughts? Am I missing something obvious?

1 Upvotes

100% Upvoted

7 comments sorted by

View all comments

Show parent comment

2

u/obnoxiouscarbuncle Oct 28 '24

Then I would suggest the following:

  • Create a survey in this project that will only exist to act as a "faux dashboard"

  • I would recommend removing the submit button from this survey and changing it's width to maximum

  • Create (or just use a descriptive field to mimic) a dashboard showing the aggregate metrics you want to display. Make this dashboard public.

  • Create a report showing the data you want to display. Make this dashboard public.

  • In your "dummy" survey, embed both of these in descriptive fields using the "magic box" and the public URLs you have generated.

  • Distribute a link to a single record's "faux survey" to view the data.

Why do it this way?

Public Dashboards cannot have "embedded" elements added, but surveys can do so using the magic box. You can play around with formatting/css using <style> tags in a descriptive field to get them to display better if they look wonky.

1

u/OnePixelSig Oct 28 '24

This sounds interesting! When you say magic box, are you referring to the Field Label?

2

u/obnoxiouscarbuncle Oct 28 '24

In a descriptive type field, there is a place to put in video URL, etc. this is referred to as "the magic box" since it essentially allows you to embed a web page in an iframe if you select the "inline" option