Example - Formula using Lookup Fields

Author: Xavier Fan
Try This App

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


Write a review doublechevronCreated with Sketch.

Lookup Fields are super confusion

By over 3 years ago

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.

Overall Rating

68 Installs



Xavier Fan

Xavier Fan Consulting focuses on small and medium-sized business, with deep experience in website development, user experience design, information architecture, and prototyping. We will work with you to understand your process and develop the right QuickBase apps for you.