What I am trying to do is to validate the user input comparing the Zoho Report query Table.

I have a Stainless form which is used to update the Data inside creator. and I have another query table in Zoho Report also .. now I want to make user input the data correctly based on the Zoho Report Query Table. So I would like to create a script that validate the inputed data inside Zoho Reports Query Table first if it is true then user can enter the data.

Zoho Report Table Screenshot :

  MVPD :                                        Market:

Zoho creator Form View:

if you notice you can see  the MVPD-01: comcast -- is not in the above Zoho report Table with respect to Market (Dothan,AL) . So user shouldn't be able to enter this mvpd under the market.

Could anyone please help ?

Thanks 

Arfater