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
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
      ------------------------------
      • JamesCarr's avatar
        JamesCarr
        Qrew Trainee
        5 years ago
        I saw someone (might have been you, now that I think about it), mention this approach in another discussion and it went over my head.  I think I am grasping it now.  It's finally giving me the count of events for today.  However, it's still only giving me that count when a related event is chosen for the RSVP being added.  Is there no way to see that count even when the form is empty?  I believe I can just use form rules to do some auto-populating and force the scenario I want to happen.  At this point, I'm just curious about whether or not I can pull this off without doing so.  While I have your attention, is there any significance to the =1 in the relationship field name for the Summary relationship?

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