Forum Discussion

SterlingLong1's avatar
SterlingLong1
Qrew Trainee
6 years ago

Date Formula as a Reference

Hello! I am trying to automatically relate records in a child table to a parent table based on the month that they are marked as "Complete". I have the date that they are marked complete in a fi...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
That does not seem possible.  You should certainly be change your reference field from being a date field to a formula date field.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
RichardChagnon's avatar
RichardChagnon
Qrew Trainee
6 years ago

I had a similar problem with a formula that returns a number.  For me it was a false positive error. When I ran a report on that table the formula appeared to calculate correctly. I continued to test and it works fine.  I put in a help desk request, but it closed as the formula worked.



------------------------------
Richard Chagnon
Northwestern University
Chicago IL
------------------------------
  • SterlingLong1's avatar
    SterlingLong1
    Qrew Trainee
    6 years ago
    You are quite right. It looks like I just needed to save it and it would work. I suppose I was a under the assumption that I couldn't save it, because generally a formula field will stop you from saving if you aren't returning a value of the correct type.

    So now everything works beautifully.

    QB Really should fix this though. It's a bit confusing.

    Thanks!

    ------------------------------
    Sterling Long
    ------------------------------