I’m trying to create an estimating tool that pulls pricing details from one base and sums them together.
I have 10 “item” fields and 10 “quantity” fields. The item field is linked.
The goal is to select the item, enter a qty and then get one big total for all the prices as well as the individual totals for each item * qty.
Problem 1: I now have 10 linked fields on the services base. I can just hide them, but I don’t understand this at all.
Problem 2: Do I have to create 10 lookup fields to pull the pricing details into the estimate base and then have that be the data that’s used for the formula? Is there an easier way?