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.

2 replies

    • Sviluppatore Ninox
    • Fabio
    • 3 yrs ago
    • Reported - view

    Hi Anna. try this:


    record('Stock Parts',number('Stock Parts CABLING')).RRP



    • Anna_Wenlock
    • 3 yrs ago
    • Reported - view

    Brilliant, works perfectly! Thank you so much (again) Fabio

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 406Views