I know that I have found that it is easiest for me to save the form submission (without a pdf or tiff, so just the values) to the repository to get an entry created; that also provides the Instance and Submission ID as viable metadata variables, then using those you can query the forms business process in workflow to tease out what ever field values you need.

After the workflow query I drop the entry itself as it is no longer needed.

Apparently, the ability to populate a field value on the form at time of submisison with the instanceID as "default" no longer works, but my VAR reported that it used to on previous versions of Forms. So, I guess this is a bug?

I am on Laserfiche Forms Professional Version 11.0.2212.30907

Hi Priya,

We do have an api that get the variable value for you, you can open the dev tools first, when you open the History page of a specific instance, there will be an api call in the Network tab, the url is like https://{FormsServer}/Forms/webapi/v1/Data?dashboardType=&extendedInfo=fieldtype&instanceId={InstanceId}&mode=all&submissionId=-1, this api returns the latest value for all the variables, but they are just raw data and not easy to understand. As for the query, it is kind of complex as several tables involved, the api itself already have all the data you want.

There isn't really a straightforward way to do this.  Variable values in the database are tied to the submission ID not the instance ID (since a variable can change multiple times throughout an instance).  You would need to determine the field ID number for the specific field, then determine which submission(s) during the instnace updated that field ID, and then you could have multiple values based on different changes, so you'd have to decide which one(s) to return.

Any update please?