Form to Edit Related Records

Question

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?

quickbasecoachd · Answer

You will likely find that the field needs to be on the form for the Conditional Drop down work.&nbsp; 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 · Answer

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?

quickbasecoachd · Answer

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.

Forum Discussion

Form to Edit Related Records

Related Content

Show related records

Prevent save a record - New forms

Totaling Child Records Live on Parent Form

Filter out some records on related table

Add child record through parent form and redirect back to parent form in edit mode