Public Dashboard fed by Form Data

replied on August 28, 2024

I have a few different things that use data from Forms, but it kind of depends on what data you're trying to display and how current it needs to be.

For example, with most data that I need outside of Forms I use workflow to add it to an external database as part of the process, but there is at least one process where I do a nightly snapshot of data from the Forms db.

The one thing I would avoid is any kind of report that hits the Forms db directly (i.e., in real time).

0 0

replied on August 28, 2024

"For example, with most data that I need outside of Forms I use workflow to add it to an external database as part of the process, but there is at least one process where I do a nightly snapshot of data from the Forms db."

That makes sense. What do you use?

0 0

replied on August 28, 2024

95% of what I do is just Insert Data inside of a workflow.

For the rare cases, I use a scheduled SQL Job to copy data, join/format it, and insert it into a separate report database.

The SQL Job is a lot more complex because you have to figure out how to pull/join the right tables, and that can always break/change in a future update.

0 0

Question

Question

Public Dashboard fed by Form Data

Replies

Sign in to reply to this post.