Dynamic choice which trigger numeric value change?
Does anyone know how to have a numeric value pulled as a result of a dynamic choice please?
I have a dynamic choice field called 'Stock Parts CABLING' which pulls a list of parts from a table called 'Stock Parts' into another table called 'Parts'.
In 'Stock Parts' each record has an RRP, which I would also like to be able to pull into my 'Parts' table depending on the choice selected. I have code set up to do this with a regular choice field, but the dynamic one works differently, and so I can't figure it out.
How do I do this with the dynamic choice field please? It would be much easier this way because I can add parts and adjust pricing in one table and have the dynamic list automatically pull the updated results, rather than having to edit code each time.
Hi Anna. try this:
record('Stock Parts',number('Stock Parts CABLING')).RRP
Brilliant, works perfectly! Thank you so much (again) Fabio
- 2 yrs agoLast active