- January 10, 2012 at 3:49 pm #929
I have a fairly basic report which uses a datalist with 10 columns. Is it possible to alter the value in a column (make it blank) based on a calculation or value in another column. I appreciate I can redesign the form to fulfil this requirement but want to apply it to a report on 150 previous form instances.
ThanksJanuary 10, 2012 at 6:01 pm #5973
Dennis @ PerfectFormsBlocked
As you have found, column values in datalists cannot be used in calculations. You had the right thought about redesigning your form (or simply adding a field to it). Once you have published your form changes you can map all of the existing instances to the new published version. Our help guide contains instructions for mapping instances to the new version: /Documentation/manual/html/?fl_mapping_form_instances_to_anot.htmMay 8, 2012 at 8:29 pm #6092
I have a similar question regarding the possiblity of altering the values for a column in the report, but the difference is I am actually using a List (under Resources) in order to populate my drop-down list for user. We now need the report to display the Caption for the selected item on the report (text), instead of the Value (numeric value). Same situation here, I already have lots of submitted production form instances, and I am hoping all of them can somehow be applied based on the changes. We are using v. 1.18. Thank you.May 9, 2012 at 3:39 pm #6093
You must be logged in to reply to this topic.