Formula field vs. lookup field: when does each make more sense for bringing in connected data?
In Jestor, a lookup field brings in a value that already exists in a connected table, without changing it, while a formula field processes a calculation — sum, multiplication, condition — from one or more fields, connected or not. The mistake of using the wrong field for the wrong data When structuring