We have several forms In Progress and we need to change date values to for a new year. Is there an easy way to update these forms that are in progress outside of using SQL in the cf_cb_data table?
Unfortunately, there isn't a streamlined way to edit a bunch of them at once.
You mentioned "using SQL in the cf_cb_data table". I believe that Laserfiche would tell you that editing the database values is not supported. This kind of thing is very risky, as it can be difficult to target specifically what you want to update and nothing else, and mistakes could completely corrupt all of your Forms data, current and historical. If you do choose to proceed anyway, I strongly recommend backing up your database first.
What version of Forms are you on?
Because recent versions (I think anything version 11 or newer) can edit the values of variables on in-progress instances from the Monitor page.
Yes we are on v11 update 3, and we can edit individually, I want to edit several at one because the values all need to change to the same thing.
Unfortunately, there isn't a streamlined way to edit a bunch of them at once.
You mentioned "using SQL in the cf_cb_data table". I believe that Laserfiche would tell you that editing the database values is not supported. This kind of thing is very risky, as it can be difficult to target specifically what you want to update and nothing else, and mistakes could completely corrupt all of your Forms data, current and historical. If you do choose to proceed anyway, I strongly recommend backing up your database first.
Hi Angela,
Currently there is no out-of-box way to bulk edit instance variables. You can only update variable values of 1 instance at a time.