I have a priority rating field, which I would like to auto-populate based on the answer to some previous choice questions. Can I do this with 'If' rules, or something else?
If field 1=x and field 2=y, then auto-populate field 3 with z, for example.
Auto populate choice field 'C' based on choice selections in fields 'A' and 'B'
+2
+7Hello,
1. Is this a calculation? or is more like a lookup matrix? For instance Probability and Impact can give me a Risk rating. Probability = 2 and Impact = 3 then Risk rating = 2 x 3 = 6. This can be done with a calculated field.
2. If it is a lookup, i.e. Car = Audi and Model = A4 then Price = $20,000. For example 2, you can have a list on the site and use the lookup function to go and fetch the Price based on Car and Model selected.
Does this help? Or can you explain the example in a bit more detail?
Kind Regards,
Francois Crous
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.