Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoIs 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
------------------------------
- AndrewNelson5 years agoQrew CadetNo, [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
------------------------------- MarkShnier__You5 years ago
Qrew Legend
I just did a test relationship and it sees to work for me. Key field of the Parent was a text field and on the child side my formula was a totext([date field type])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- AndrewNelson5 years agoQrew CadetIt lets you create the relationship? Or it lets you add summary fields? I can create the relationship, it just won't allow any summary fields.
The limits page the error message linked to states:
You will be able to create a summary field only when the foreign key meets the following conditions:-
-
The field must not have any custom permissions.
-
Any referenced fields in the formula must not have any custom permissions.
-
The formula field only references other fields which are either scalar or formulas that follow these rules.
-
The maximum number of text values that a combined text summary field can accumulate is 150.
-
Only the following formula functions are supported when not referencing dates, datetimes, or users.
-
ToText()
-
Nz
-
ToFormattedText that does not reference a timezone
-
ToNumber
-
ToBoolean
-
Mathematical functions like log, mod, etc.
-
Text functions like right, left, mid, etc.
-
URLEncode
-
Duration conversions like ToDays, ToMSeconds, etc.Note: Any function above, like ToText(), referencing a date or time will not be allowed.
-
-
------------------------------
Andrew Nelson
------------------------------ -