Unable to create summary field
I've been getting the following error when I attempt to create a summary field in a relationship:
We are sorry -- at this time, you cannot use this formula and have a summary field using ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhen you have a relationship and the reference field on the right side is composed of a lookup field, you are not permitted to make a summary field. That has always been a Quick Base limitation going back to like 2000.
The only solution is to have a scalar (data entry) type field and have an Automation maintain to be the same as the lookup field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The only solution is to have a scalar (data entry) type field and have an Automation maintain to be the same as the lookup field.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- The issue is that the reference field on the right is not a lookup field, just a formula field. It does have a somewhat complex formula that introduces two variables in its formula, if that makes a difference.
The formula reference field I have that is working is not a complex formula field but a simple concatanation.
I'll give your automation method a chance and report back.
------------------------------
Niraj Shah
------------------------------- MarkShnier__Youbut does the formula field use other fields which are lookups? or does the formula field user the
User() function?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- No.
The reference formula field for the relationship where I can create the summary field is:
[Month Recorded]&[Year Recorded]
The reference formula field for the relationship where I cannot create the summary field is:
var date DateWords = ToDate([Date/Time Received]);
var text Monthly = Case(Month($DateWords),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December");
$Monthly & "" & ToText(Year($DateWords))
------------------------------
Niraj Shah
------------------------------
