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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        OK, now I understand.  You will need to make a helper table with just 1 record in it. Let call the table Events Summary. Create the one  record.  It will be [Record ID#] of1.

        Make a relationship where One Event Summary has many Events.  Let it create a field for that relationship.  Then rename the field to be called [Link to Event Summary(=1)]. Then change the field type to be a formula numeric with a formula of
        1

        Then summarize the # of Events  where the [Event Date] is the current date.

        Then look that field up down to Events and then down to RSVP from Events.​

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