Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Re: Relationship/Summary Restrictions on Date fields

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

7 Replies

  • AndrewNelson's avatar
    AndrewNelson
    Qrew Cadet
    5 years ago
    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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      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
      ------------------------------
      • AndrewNelson's avatar
        AndrewNelson
        Qrew Cadet
        5 years ago
        It 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.
        Which makes it clear that what I'm trying to do is not allowed.  I'm just trying to understand WHY (and, more importantly, trying to find a workaround that lets me do what I'm trying to do).

        ------------------------------
        Andrew Nelson
        ------------------------------