Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoI am pretty sure that each derived field on the counts once.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Here are two techniques to keep under the limit of 40.
The first is that while using a look up field counts a derived field if you use the reference field in a relationship that is not a derived field as that would be a scalar data entry field. By that I mean to use the field [Related Customer] instead of the field for a [Customer Name] (lookup field).
Secondly if you are using formula fields then often you may be able to create a single formula field which can replace two or three other smaller formula fields and that single formula field will count just once as opposed to two or three other formula fields which count as two or three derived fields.
Secondly if you are using formula fields then often you may be able to create a single formula field which can replace two or three other smaller formula fields and that single formula field will count just once as opposed to two or three other formula fields which count as two or three derived fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- MichaelTamoush5 years agoQrew CaptainMark,
Good call on using the related field vs lookup. I bet I have a few of those. I'll look to see about the formulas also.
------------------------------
Mike Tamoush
------------------------------