Good Afternoon,
I was wondering if it was at all possible to have dynamic fields setup in a template however have the end user add a new record if it's not listed in the template field's list?
Thanks,
Jennifer
Jennifer this is possible to due using Laserfiche Forms and Laserfiche Workflow.
- Create a form with the field(s) that you want updated
- Once form is submitted, have workflow parse data from form and update SQL database
Unfortunately we do not have forms. Is there a workflow that I can create?
It is possible using Workflow and the Laserfiche Client or Web Access, though it can create security (depends on what users have access to the field) and data integrity issues (free text fields can lack constraints on data input highly recommend using regular expressions).
1. Create Field 1 (this will be the dynamic linked field)
2. Create Field 2 (this will be a free text field)
3. Create Workflow session that monitors Field2 for data input.
4. When Field 2 has data input Workflow writes the value(s) to the SQL table. (I say values because Field 2 could be a multivalue field and workflow can parse those values and write them as separate rows in SQL)
5. Make sure that Workflow queries SQL first to make sure the value from Field2 does not already exist in the table. If the value(s) exist make sure that Workflow has an exception in place (use a conditional sequence, conditional parallel, or conditional decision.
6. I would recommend having a 'review/approval' process before Workflow writes the data to SQL.