Forum Discussion

JamesCarr's avatar
JamesCarr
Qrew Trainee
5 years ago

Adjust Form If Child Table Has A Record With Current Date

I have been searching and searching and cannot find my answer. I am hoping someone can help.  I have a table to track who has RSVP'd for an event related to another table tracking the events to RSV...
Forms
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Here is my understanding of the question.

You are saying that One Event has Many RSVPs.

For some reason,  you want the Parent Event to know if any of the child RSVPs have today's date  in the [RSVP Response Date] field.
.
To make that field it would be a Summary field of he # of events where the [RSVP Response Date] is the current date.

Was that your question? 

​

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JamesCarr's avatar
    JamesCarr
    Qrew Trainee
    5 years ago
    Hi, Mark. Thank you for replying and sorry for the confusion. I want the child RSVP to know if the parent Event has a current date.  I don't want to add a child RSVP without a parent Event having the current date.

    ------------------------------
    James Carr
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      You can simply look up the the [Event Date] field from the parent down to the RSVP.  If you want to know if that date is today, then you can make a formula checkbox field called [Event is Today] with a formula of

      if([Event Date] = Today(), true)

      If you are trying to suppress the Add RSVP button when the Event is on or after today, then  you would do that on the Parent Event Record.  You can use a form rule

      When [Event Date] is on or before the current date
      hide ADD RSVP

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • JamesCarr's avatar
        JamesCarr
        Qrew Trainee
        5 years ago
        That approach seems to only check the box if the child RSVP is being related to an event with a current date. Am I missing something? I need the ability to tell if there are any parent events, including those not related to the child record being added, with the event date equal to today, regardless of what is currently populated for the record I am adding. I hope that makes sense.

        ------------------------------
        James Carr
        ------------------------------