Filter Values corresponding to a ID in the Form option

anilkrag1984

Hi Team can anyone suggest me if there is a way where, If we enter ID 123 in customer ID Field the values belonging to that ID only visible in the other field say in Smartnet Contract Number Field

Smartnet Contract Number Field.png

Customer ID Field.png

in the Form option. Like Data Validation in Excel.

anilkrag1984

The Smartnet Contract number field should not show values of ID 234

Andrée Starå

Hi @anilkrag77641

Yes, it’s possible through the Form Logic feature, but you need to create a so-called helper column for each ID, so I don’t think it will work for you.

More info: 

https://help.smartsheet.com/articles/2481701-use-conditional-logic-to-streamline-form-submissions

Another option could be a 3rd-party solution/integration. Is that an option?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!