You are viewing limited content. For full access, please sign in.

Discussion

Discussion

How do we use Forms backend validation with lookup-populated dropdown fields?

posted on May 15, 2018

We have dropdown fields that are filled from database tables. When we submit, we get "This value does not belong to the list of choices."

We don't want to turn off Backend Validation completely though. We just want it to ignore these specific fields.

Forms 10.3.1

0 0
replied on May 16, 2018 Show version history

Have you tried setting the Form Settings validation level to "Validate user input" instead of "Validate all"? That should only validate user input instead of the fields filled by lookup. 

Link to documentation

0 0
replied on May 15, 2018

Instead of dropdown fields, can you try just single line text fields? Those will fill with the available options from the database and shouldn't throw back end validation errors. 

1 0
replied on May 15, 2018

No because we don’t want users to be able to freely type in those fields (they contain unique IDs that are then utilized by workflow behind the scenes).

0 0
replied on May 15, 2018

I concur. I had same issue, drop downs hold the data for lookup but does not retain it when passed to another process or submitted. You can hide a single field and pass the data to it from the drop down and use that field for workflow.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.