Form to Edit Related Records

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I have created a table report that will exist on a dashboard. This table report includes select fields in records (events) from TODAY. These select fields are pulled via API from our booking platform.

Some of those fields are TIME OF EVENT, NAME OF EVENT, # OF PARTICIPANTS, and LOCATION OF EVENT. Next to the name of each event, I would like to have a button that links to a form that will edit other fields related to the record; however, I would like to make some of my fields conditional drop downs based on the LOCATION OF EVENT field, which I wasn't planning on including in my form since it is already populated via API. Is there anyway around this? 
Photo of ltduran

ltduran

  • 590 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
You will likely find that the field needs to be on the form for the Conditional Drop down work.  But you may be able to hide it with a form rule that makes it hidden all the time, but still not break the CDD functionality.
Photo of ltduran

ltduran

  • 590 Points 500 badge 2x thumb
Got it. Since there will be many Locations, this would be a drop down if it weren't pulled via API. How do I get this form field to auto populate to the related Location?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
I suggest that you base your CDD on the location words then and not the [Related Location] if Related Location is not populated.

But now you have confused me as to your relationships and what is auto populated.