Hi, I am new to Zoho and i am currently stuck on something.
Here is my scenario i wonder if you can help.
My Girlfreind has a hairdressing company so i have created her a job record , payment tracking system.
The form has the following fields.
- Date
- Name Of client (drop down selection using realtionships) (from Clientel form)
- Discount (dropdown list, with values set on the form)
- Job Undertaken (Multiple selection list using relationships) (from Price list form)
- Number : (used to calculate price from the multiselect selection )
- Amount Payable ( Displays the total calculated value from Number)
- Total ( Using a function to minus the discount from Amount payable if selected)
I have got the discount to work but i would like to use the multiselect dropdown list , to select multiple jobs from the price list and pull the price with it for each item into another filed, this will also have to add the prices together. I am going to hide this from view on the form and display the total into amount payable.
If somebody could help that would be much appreicated.
Many Thanks