How do I do this?
How do I do this?
Hi, I am evaluating Zoho Creator and would like to know whether the following is possible. We work in the pharmaceutical industry and each drug has a trade price. I want to use Zoho Creator to keep track of our cost prices. The cost price is dependent on a two factors: - It could be on a list where the cost price is specified OR - Dependent on who the manufacturer is, a set percentage would be taken off the trade price. I thought about how I would create this using Zoho Creator and thought I would need three forms: 1. Product 2. Products where there is a set price 3. Discount percentages for each manufacturer How do I go about setting the cost price in the product form. In a manual process, the cost price would be determined as follows: 1. Select Product 2. Is it on the list where there is a set price? 3. If not, who is the manufacturer and what is the discount percentage? Also, since I am evaluating the product, I would like to know whether the following is possible: - Uploading data from inhouse databases on a periodic basis. - Creating queries Thanks Shaheed Fazal