Just wondering if it was possible to tweak a document generation app to populate a template/document based on specific input fields whilst incorporating some rules?
To be specific, I have created a new object/app called 'Product Solution'. This object has 5 fields that can be populated using a multi-option defined picklist. Once the fields are populated and the record saved, I want to generate a document that includes specific product information based on the field contents. My difficulty comes from the fact that some pick-list answers will invalidate certain information from appearing in the final template. For example, the first field is a customer volume estimate with 3 possible options (only one can be chosen) 0-250 annually, 250-1000 and 1000+. When populating the final template I would want to invalidate all contract only products from appearing if 1000+ is not chosen, as this is the contract product access requirement in my organisation.
Any help much appreciated!