Skip to main content
Question

Form to Edit Related Records

  • November 4, 2017
  • 0 replies
  • 24 views
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? 
    This topic has been closed for replies.

    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.
    • ltduranltduran
    • Author
    • Quickbase Alumni
    • November 4, 2017
    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?
    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.
    Terms & ConditionsAccessibility statement