Use formula to relate fields on different tables

how to write formula for a Table so i can multiply a figure from that Table with a related figure from another Table?

in the drop down field options for formulas when you open up a formula field, there ARE field options including ones that arent on that table so i selected one that is relevant

see formula below that failed and i am not sure why

do i need to specifically bring that value into the active table before i can use in formula?







Hey @mcmdennis is the main table(the one that you’re creating the formula) connected(using connected table field) to the other one?

Is this “effort descriptor” that you’re using in the formula, a number field as the time in minutes field?

yes they are connected tables

the descriptor field is not numeric but the related / matching field in the descriptor table is numeric

Thank you

Dennis McMahon
General Manager
Tanah Tara Estate
www.tanahtara.com
CEO, MCM GreenMan Group
Allsense IoT/ MAAStack
www.maastack.com

Ph/ WhatsApp +60169839715