Unable to create summary field

Question

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 this relationship.

I have a relationship where the reference field is a fromula text field but I don't know what I am doing incorrectly. I have a similar relationship between the same parent table and a different child table where the reference field is also a formula text field but it allowed me to create the summary fields.------------------------------Niraj Shah------------------------------

markshnier__you · Answer

When&nbsp; 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.&nbsp; That has always been a Quick Base limitation going back to like 2000.&nbsp;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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

nirajshah4 · Answer

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__you · Answer

but 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
------------------------------

nirajshah4 · Answer

No.The reference formula field for the relationship where I can create the summary field is:[Month Recorded]&amp;[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 &amp; "" &amp; ToText(Year($DateWords))------------------------------Niraj Shah------------------------------

markshnier__you · Answer

Is the field dependent on the system generated field for [Date Created]------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Unable to create summary field

Related Content

Summary Reports

Maximum Summary field not working

AI Smart Builder for Creating Apps and Streamlining Pipelines

create pipeline to create new records based on current record

Add button to create record in different app