I have a Forms process in Laserfiche Cloud where I have around 20 submissions. I pulled up the Forms Report for it and noticed that some of the variable values needed to be updated, so I went into Monitor and edited the variable values. When I go back to the Forms Report it does not refresh with the new values. How often does it refresh the data for the reports?
Question
Question
How often do Forms Reports update data in Laserfiche Cloud?
Replies
I'm starting to think that the Forms Reports are based off of the original data that was submitted and does not take into account if the variable values are updated by an Admin since none of the values have been updated in the report. Is that correct?
This may be a bug, we'll investigate this further.
Did you update the variables after the instance had completed?
The instances are still active instances and are sitting at a user task. I updated them in Monitor while they were still at the user task.
Interesting, thank you for the info
If you are able to look at my Laserfiche Cloud tenant, please feel free or I am happy to jump on a meeting with you to show you what I'm seeing.
@████████ were you able to find anything on this?
Apologies, this fell off my radar. My team confirmed this is a bug, we have some reporting enhancements coming up that I will include this in.
@████████ does this bug plan on being patched this month? It really makes the built-in reports unusable since they aren't showing accurate data.
It also looks like it might be pulling in data from submissions that have been cancelled by and Admin.
Working on getting this into our backlog right now. It will not be in this coming months update, I will follow up when it is fully triaged.
I checked with the team on this, there is no way to change the variable of a specific submission within an instance. The variables changed from the monitor page are appended to the submission history. This is mainly because we have to support auditability of the values present at submission time. If you use a custom report you will look at the latest variable values which in your case would contain the admin changed values.
Just to make sure I understand correctly, the built-in Forms reports only go off of the original submission and if an Admin changes a variable, it will not be reflected in the reports. If I use a custom report, then it will reflect those latest variable values. Does that sound correct?
If yes, is there any way that the built in reports could be updated to show the latest variable values instead of the values from the original submissions? Maybe under the "Form" drop-down have an option that says "Current Process Data", similar to when selecting which data to use in a Save to Repository task in Self-Hosted?
Ya definitely will look into that as an alternative. It may not be applicable on all reports but it does make sense to have that as an option