I have an new enquiry app that links through with a relationship field to another app called Quoted. In the Quoted app we we can select if a band is an 'Option' or whether it is a 'Pencil' via a category field and add a quoted value.
In the enquiry app I have an 'enquiry value field' I want it to show the value of the following:
If there is a Quoted item linked that is marked as 'Pencil' = The full value of Quoted Value
If there are Quoted items that are marked as 'Option' = The average value of Quoted value of all items marked as 'Option'
Can anyone help?
Please sign in to leave a comment.