Example - Formula using Lookup Fields
This is an example app to answer the query in this community question: https://quickbase-community.intuit.com/questions/889863-creating-a-formual-field-using-a-formula-from-another-table?jump_to=comment_2038525 Objective: - incorporate a lookup field from a parent table to calculate a value using formula fields Solution: - 2 table: Companies, Debts - LPInterest RateTotal is a Formula-Numeric field on the Company table - the Debt table looks up that value in [Company - LPInterest RateTotal] - the Interest fields uses that lookup field as part of the formula calculations
Reviews
Write a reviewLookup Fields are super confusion
I had to do and undo and redo the relationships several time to figure out what they where doing. It always seems backwards to me.
Try Quick Base Today
30 day free trial. No credit card required.