Discussions

 View Only
  • 1.  Is there a way to have a conditional dropdown select the option if there is only 1 available.

    Posted 07-21-2019 15:17
    So I have several tables.

    Organizations (have many) Contracts
    Contracts (have many) Project Codes
    Project Codes (have many) Tasks
    MMS Codes (have many) Tasks
    Work Elements (have many) MMS Codes

    When I am on my Tasks table, I select the organization, then (via conditional dropdown) I select the Contract, next I select the work element then (via conditional dropdown) I select the MMS Code.  At this point I am ready to select my project code; however, I am EVER going to have one option (the correct option).  Is there a way to have this final dropdown select the project code automatically since it will be the only option available in the dropdown?

    Because of what this information is, we have to implement the process of selecting a Work Element and then MMS Code.


  • 2.  RE: Is there a way to have a conditional dropdown select the option if there is only 1 available.

    Posted 07-21-2019 18:34
    If its only one option just set the default value of this field to the record ID number (or the key value) of that option.


  • 3.  RE: Is there a way to have a conditional dropdown select the option if there is only 1 available.

    Posted 07-21-2019 19:31
    You have a relationship where 1 Work Element ha s Many Project Codes. Use a combined Text Summary field to float up the Project code to the Work Elements Table.

    Convert it to a text field using the ToText function.

    Then use a form rule to say when the Work Element is not blank and the MMS project code is blank, change the MMS Project Code that combined text Summary Text field.

    .


  • 4.  RE: Is there a way to have a conditional dropdown select the option if there is only 1 available.

    Posted 07-22-2019 13:42
    I think you can achieve this by using form rules but that would be applicable only for entering the new records into the table using form and not for the grid edit.