Discussions

 View Only
  • 1.  Form to Edit Related Records

    Posted 11-03-2017 21:32
    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? 


  • 2.  RE: Form to Edit Related Records

    Posted 11-03-2017 21:35
    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.


  • 3.  RE: Form to Edit Related Records

    Posted 11-03-2017 21:40
    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?


  • 4.  RE: Form to Edit Related Records

    Posted 11-03-2017 21:42
    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.