Hi everyone,
I have created a parent and a child custom record (linked) that creates an entry form for the user.
On the child custom record I have added fields related to items such as Qty, Amount, Rate, Tax code, Tax Amount and so forth.
My idea was to use Validation & Defaulting to get values calculated by a formula.
example:
Tax Amount field would have the formula to say {Amount} * 0.25 (25% tax based on the tax code).
This works fine when I "un-tick" Store Value (which makes sense since it will recalculate everytime the user edit the Amount field).
However, if I un-tick the Store Value box, the field is not visible on the entry form any more.
What am I doing wrong? Any workarounds?
I tried to make a workflow as well but it doesn't give me access to child fields If I choose to trigger on Parent.