Excluding Values from a Range in a Display Form

I have a workflow that allows users to compare two different Zip Codes. I have two autocomplete boxes for the users to enter Zip Codes. However, this will be for a public map, and I don't want users to be able to submit Zip Codes that are not in our county, as they won't yield any results. I used validation to set a range of acceptable values between the highest and lowest Zip Code in the county, but there are many gaps in the range of Zip Codes that are not in our County. So users could enter Zip Codes that are within the set range but don't yield any results.

For now, I made an extra Flow Decision with the condition set as an exhaustive list of Zip Codes within the range that are not our county Zip Codes (ZipCode1 <> "93204" AND ZipCode2 <> "93204" AND...). If the user enters one of those Zip Codes, they will see an alert and then be looped back to the display form where they enter the Zip Codes. Does anyone know of a better way to do this? Any suggestions would be appreciated.

Thanks,

Denise

Permanently deleted user

4. März 2019 22:20

Hi Denise,

Can the autocomplete pull from data that only has your relevant ZIP codes in it?

Can you not use an autocomplete and only have a dropdown with your applicable values?

Regards,

Wayne

Denise Beckham

5. März 2019 01:00

Hello Wayne,

Thank you for your response! I do have the autocomplete boxes set up with drop downs that pull values directly from the data that the workflow is set up to compare. I'm just worried that people will ignore the dropdown and try to submit invalid Zip Codes. Is there a way to set it up so that it only accepts values from the dropdown?

8. März 2019 22:23

I am afraid not, you would need to populate a combobox with all the valid values. This can be done in the runtime modifications.

An autocomplete can always be modified, even after a record is selected.

Excluding Values from a Range in a Display Form

Kommentare

Sie haben nicht gefunden, wonach Sie suchten?