Question

Creating a SQL view based on Forms Reports data

Forms Version 10

Updated February 26, 2018

asked on February 23, 2018

Good Morning,

We have and end user that wants to be able to send emails of Forms report data to employee's that aren't licensed for Forms.

What we would like to do is create a SQL view that pulls in that Forms report data and then utilize that and Workflow to send out a report.

Has anyone been able to do this? Or are there any guidlines LF can provide on which tables within the Forms DB would contain this data?

Thanks!

0 0

Replies

replied on February 25, 2018

Hi Charles,

The "report data" are not saved in database tables: we keep the instance data/submitted values, and generate the report when you open the report. Submitted values are in table [cf_bp_data] and instance data are in [cf_bp_main_instances]

If you have created snapshots of the reports, the snapshots data are saved in table [cf_static_report_data].

Besides, in Forms 10.3.1 there will be a feature called "Report schedules" where you can create a schedule to send report through email to users or email addresses. The report will be attached in the email in xlsx/csv or image format. It seems this feature would meet your needs, what do you think?

1 0

replied on February 26, 2018

Rui,

Awesome! Thanks for providing that information! That functionality seems like exactly what we need.

Two questions:

1.) Will the emailed report be available to anyone who has an email address and not just licensed LF users?

2.) Do you have a rough ETA on when this functionality will be available?

Thanks!

0 0

replied on February 26, 2018

1. Yes, it can be sent to any email address and the report is attached as a file so you don't need to login to Forms (file is the same as the one you could get through download report)

2. Forms 10.3.1 ETA is March.

0 0

You are not allowed to follow up in this post.

Question

Question

Creating a SQL view based on Forms Reports data

Replies

Sign in to reply to this post.