Forum Discussion
JamesCarr
5 years agoQrew Trainee
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
------------------------------
------------------------------
James Carr
------------------------------
MarkShnier__You
Qrew Legend
5 years agoYou 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
------------------------------
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
------------------------------
- JamesCarr5 years agoQrew TraineeThat 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__You5 years ago
Qrew Legend
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
------------------------------- JamesCarr5 years agoQrew TraineeI 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
------------------------------