How to show/hide values of certain fields of a form depending on their value from another form

(Note: this is a rephrasing of my last question since I didn't get the answer I'm looking for)

I need to find a way to show/disable fields in one form based on a decision filed from another form

I have 3 form: Products, WorkOrders (like invoices) and WorkOrderProducts(The actual products the customer specifies)

The Products form consists of a single-line field and 8 decision boxes(e.g length, diameter, PN, etc...). Each product will have some of the decision boxes checked and others unchecked.

The WorkOrder form contains information about the customer's order. Here we determine the actual values for each field of the product (i.e Length = 10, diameter = 100, PN= 25, etc...)

The WorkOrderProducts form is simply the form that stores the actual products the customers order. Notice that here we store the actual Products and not just their specification as in the Products form.

What I want to do is simple:

In the WorkOrders form, I need a way to add multiple WorkOrderProducts to a single WorkOrder. I also want to make it so that the WorkOrderProduct's fields are disabled if they are unchecked in the Product's decision box.

I have tried using a Sub-Form in the WorkOrder form which links to WorkOrderProducts but I've been told that You can only disable the entire column for a specific field... I need to be able to disable each field for some rows and enable it for the others. So Sub-Forms won't work for my Use Case... I need to find another solution

Any Ideas?

Access your files securely from anywhere

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
zaham2
Damien Cregan

Sticky Posts
How to Add Users to your Organization in ZohoMail?
A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk) In this topic, We will be discussing on how to Add and Invite users only. The Import options are self explanatory. ____________________________________________________________________________________________________________

New to Zoho Social?

Manage your brands on social media

Access Zoho Social