Address Field: Impact of Changing State from Dropdown to User Entry on Table Data

If I change the "State" line of the Address block in my form from a drop-down list to a user-entry format, how will this affect my table data?

Hi Mike,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Based on the information available in the knowledge base, Jotform Tables can be edited directly, and changes made in Tables can be saved as updated entry values. The knowledge base also confirms that Tables can use Single Selection columns for dropdown-style values, and that editing entries in Tables can be done inline without triggering after-submission events.

However, I do not have information in the knowledge base that specifically explains how changing the State line of an Address block from a dropdown list to a user-entry format will affect your table data.

I don't know this information and our support team will handle your request.

Let us know if you have any other questions.

Hi Mike,

If you change the State field in the Address element from a dropdown to a user-entry text field, the data will still be captured in your Jotform Tables without any issues. However, this change may affect data consistency since users can enter the state in different formats or with typos, for example, CA, California, or Calif, which can make filtering, sorting, or grouping data less reliable.

Your existing submissions will remain unchanged, and only new entries will reflect the updated format. If you rely on consistent data for reporting or integrations, it may be helpful to keep the dropdown or apply input validation to guide users toward a standardized format.

Let us know if you have any other questions.

Thanks, Adrian.  That's helpful.  How do I add a validation?
Mike
...

Hi Mike,

To add validation to your State field, you'll first need to ensure you are using a Short Text element rather than the default Address block, as the Address block's text fields don't support custom validation patterns. Here is how you can set that up:

1. In Form Builder, click on Add Element from the upper-left corner.

2. In Form Elements panel, drag & drop the Short Text field.

3. Click on the field's Gear icon to open its Properties on the right.

4. Then, input your Field Label, e.g., State.

5. Go to the Options tab.

6. Click on Validation, and select Alphabetic.

7. Next, toggle the Input Mask to On.

8. Input @@ to the Textbox to restrict the users to match the format you specify.

9. Go to Advanced tab.

10. In the Hover Text section, input a Text(s) to provide hint to the users. Example: State abbreviation, example: CA for California.

See the screencast below for my results:

You can check out our guide on Getting Started With the Basic of Input Masking.

Reach out again if you need any more help.