Use choice fields in a formula field
Hello,
Here is what I have:
- A number field called (Bedrag) where I put in a value, the number field is in an parent table called (Kosten).
- A choice field where I have 6 options in parent table (Kosten)
- 6 formula fields in an different parent table called (vastgoed)
I make a new record and I put a value in number field (Bedrag), then I choose one of the choice field options corresponding to my record, then I would like have the sum of the values that I put in number field (Bedrag) of all the corresponding records in the corresponding formula field (vastgoed).
Hopefully I made myself clear ;-)
Many thanks.
Ronald Schuyten
7 replies
-
Thanks for the table names. Very helpful.
Are Kosten and vastgoed related?
Are the six choices in the choice field related to the six formula fields? Can you post the code of one of the formula fields?
Content aside
- Status Answered
- 1 yr agoLast active
- 7Replies
- 174Views
-
3
Following