Forum Discussion
MarkShnier__You
Qrew Legend
Is that date field a lookup field?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
AndrewNelson
4 years agoQrew Cadet
No, [Date] is a normal Date field, and [Date ID] (the reference field for the relationship) is just a Formula-Text field containing toText([Date]). It appears that because I have used a derivative of a date field as the reference field, QuickBase simply won't allow me to create ANY summary fields on the relationship.
I have done this in the past, and from what I can tell it is still working where it was already implemented. But even when I try to add another summary field to THAT relationship I get this message:
We are sorry -- at this time, you cannot create a summary field using a relationship where the reference field is this type of formula field. Please visit our limits page (https://XXXXX.quickbase.com/db/main?act=dohelp&page=quickbase_limits) or contact Care for more information.
------------------------------
Andrew Nelson
------------------------------
I have done this in the past, and from what I can tell it is still working where it was already implemented. But even when I try to add another summary field to THAT relationship I get this message:
We are sorry -- at this time, you cannot create a summary field using a relationship where the reference field is this type of formula field. Please visit our limits page (https://XXXXX.quickbase.com/db/main?act=dohelp&page=quickbase_limits) or contact Care for more information.
------------------------------
Andrew Nelson
------------------------------