Hi guys!
I recently created several items that share the same variable set. All these items belong to the "sn_sm_legal_request" table. Anyhow, I'm consequently going to have to create several reports and analysis using the values from the variable set (which is not possible). What I'm hoping to do and make work is create new columns in the "sn_sm_legal_request" table and fill it with the values inserted into the variables by the user. For example, the variable "country" (variable name) belongs to a variable set and whenever a user fills a form and fills up the "country" variable, I want the newly created column's field "u_country" (from "sn_sm_legal_request") table to be filled. After all, I will now be able to create reports using the values off the table. I've been trying to use business rules but it isn't working. Any ideas?
