{"id":2787,"date":"2015-03-31T19:22:54","date_gmt":"2015-03-31T19:22:54","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2787"},"modified":"2017-10-27T16:44:08","modified_gmt":"2017-10-27T16:44:08","slug":"californias-prop-65-eformz-conditional-logic","status":"publish","type":"post","link":"https:\/\/minisoft.com\/support\/californias-prop-65-eformz-conditional-logic\/","title":{"rendered":"California’s Prop 65 & eFORMz Conditional Logic"},"content":{"rendered":"

Compliance with California\u2019s Proposition 65 can be challenging. After all, every item containing chemicals on the list of substances covered by Proposition 65 must be shipped with a WARNING label. Yet, this warning language isn\u2019t required for items shipped to places other than California. You don\u2019t want to send a WARNING label to a customer outside of California, but you have to include it for California customers. How do you solve this business process problem?<\/p>\n

Fortunately, Minisoft\u2019s eFORMz has the solution. eFORMz is equipped with powerful conditional logic that can add information to a form, or suppress it, depending on a particular flag. You can conditionally place logos, addresses, special messages, barcodes and much more. For placing the Proposition 65 WARNING label, you would enter the warning language as a constant value, and then make its placement conditional on the appearance of California\u2019s state code (CA) in your data file. Within the eFORMz Composer, it might look like this.<\/p>\n

1. First, you would right-click your form and select Add Variable > By position. We\u2019ll call this variable Prop 65. Next, right-click this variable and select Add Function > Set value.<\/p>\n

\"\"<\/a><\/p>\n

2. Next, you\u2019ll want to left-click and drag over the address, right-click and select Add Variable. Make sure to check Copy original data to output before selecting OK. Checking this will keep your information exactly where it is placed on your form. We\u2019ll call this variable Address Check.<\/p>\n

\"\"<\/a><\/p>\n

3. From here, right-click the Address Check variable, and select Add Advanced Function > Bulk Concatenate. This displays the address information in a string format.<\/p>\n

\"\"<\/a><\/p>\n

4. The Bulk Concatenate dialog box will display. Select the Address Check variable.<\/p>\n

\"\"<\/a><\/p>\n

5. After this, right-click in the bottom pane of the Viewer, where you would like WARNING label to appear on the form, and select Add Rule > Place Text. The Rule Properties dialog will display. Select the Prop 65 variable that contains the warning language. Select OK and the WARNING label will appear on the form.<\/p>\n

\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

6. Here\u2019s where the power of eFORMz conditional logic comes into play. Right-click the rule and select Add AND Condition > Contains. The Data Condition dialog box will display. Select the Address Check variable from the drop-down menu. In the field at the bottom, enter the state code. To make sure we don\u2019t have duplicate entries of CA in this string, we\u2019ve added the following in the field: , CA<\/p>\n

\"\"<\/a><\/p>\n

7. The WARNING label will continue to display, and in instances where the address doesn\u2019t contain \u201c, CA\u201d it won\u2019t appear.<\/p>\n

\"\"<\/a><\/p>\n

Video<\/h2>\n