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
------------------------------
SterlingLong1's avatar
SterlingLong1
Qrew Trainee
6 years ago
It appears as though that I can, QB was just telling me that it needed to be a text return value, not a date. Making it return a date gave me an error, but I could still save and the formula functioned properly.

All is well. 

Thank you!

------------------------------
Sterling Long
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Well if you want to look at this in a more positive light, up until about two years ago there was no live editing in the formula box. You would save the formula and if it had an error it would tell you.
    A couple of years ago they put in the live error checking but it's not 100% perfect. So sometimes if you can't figure out the area just try saving and see if it takes.


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



      ------Original Message------

      Well if you want to look at this in a more positive light, up until about two years ago there was no live editing in the formula box. You would save the formula and if it had an error it would tell you.
      A couple of years ago they put in the live error checking but it's not 100% perfect. So sometimes if you can't figure out the area just try saving and see if it takes.


      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      markshnier2@gmail.com
      ------------------------------