Add multiple value logic to single line text Form dependency rules
Jul 1, 2020 9:56 AM
Goal: Allow for multiple values logic in Forms dependency rules when evaluating a single line text field, such as allowing comma-delimited values entry when building the rule.
When working on building a dependency rule for Country and State fields on my HubSpot form, I was unable to create multiple conditions for how the user might enter values into the Country field, which is single line text type.
In this example, I would like to show the State field for if Country contains any of the following values: US, USA, United States, United States of America. If I were using a tool like filtered views, I could use commas to separate those potential values, but that function is not available in the Forms tool.
Attempting to add multiple dependency rules for the same field and dependency throws a duplicate error. In this example, after building the first rule for US, I get an error building the rule for USA that says the State field is already in use on the form.
I understand that for Country and State fields, a defined picklist is best for maintaining data integrity, and would also solve this issue (Forms can evaluate multiple entry values if the field type is dropdown or multiple checkbox type, for example). However, there may be conditions where a field is best used as single line text where this logic may come in handy.
Note: There are a few ideas on here that deal with multiple layers of dependency on forms, or that ask about the best way to implement a Country-State dependency rule. This idea is different from those, specifically looking to add more control to setting logic rules for single line text fields.
Investigate > Align > Implement > Resolve > Innovate