For one webform, I want to retrieve one field from each iteration of this form to put them in a pdf file. For exemple : in a form I have a name's field. Each time this form is submit I want to retrieve the value of the name's field to put it everytime in the pdf file in a cumulative way. Is it possible ?
Question
Question
Replies
In Workflow, when you retrieve the field values, it allows you to specify the form the variable is coming from. You may need to set one of these activities up for each form though, as the tokens will likely overlap and cause a headache when publishing or trying to keep track. It's easier to just use separate instances of the Retrieve Laserfiche Forms Content activity to get it done
Instead of a PDF, have you considered storing the information into an Excel spreadsheet? By using the Insert Data activity in Workflow, you can append a new row of values into a table every time a new form is stored into Laserfiche.
How would they keep that up to date though? Removing the excel spreadsheet from the repository then updating it and placing it back in LF? Seems a bit complicated and many things can go wrong with that since people might accidentally change the spreadsheet when saving.
Better way would be storing everything into a SQL table and then having it add to a spreadsheet on the server then import that spreadsheet as a new version to the entry with the previous version of the spreadsheet. this would reduce the opportunity for errors, but may need to be run on a scheduled basis instead of immediately depending on the volume of modifications since ODB Connections are single use items so 2 workflows at the same time would cause a problem.