Skip to main content
Question

Adjust Form If Child Table Has A Record With Current Date

  • May 24, 2020
  • 0 replies
  • 94 views

Forum|alt.badge.img+9
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 RSVP to (Date, event name, cost, and link are the fields). I have the relationship as one event to many RSVP's. Here is my dilemma:

I want the form for the RSVP's to display particular sections I have, depending on whether or not the event table has one or more records with the date field having the current date. I was thinking I needed to establish another relationship with the events related to itself, so I could use a summary field to get a count of records with the current date. Unfortunately, my summary fields always end up blank so, I am not understanding summary fields completely and/or, I cannot do what I want the way I want. I considered maybe using a formula field with, perhaps, an API_DoQueryCount call or something but, trying to figure that out has been even further beyond my understanding. 

Any suggestions on approach, links to explanations for how summary fields and/or using API calls in formulas would be greatly appreciated. Please do not direct me to QuickBase's help guides. I have read and read their info and, while I am future along with the overall development of the app, I am still stuck with this dilemma. Thank any and everyone who chimes in for attempts to assist in advance for your time.

------------------------------
James Carr
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------