Forum Discussion

AmberPolston's avatar
AmberPolston
Qrew Cadet
6 years ago

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

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.
Tables and fields
  • EOMDevelepors's avatar
    EOMDevelepors
    Qrew Captain
    6 years ago
    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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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.

    .
  • vijaysingh's avatar
    vijaysingh
    Qrew Cadet
    6 years ago
    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.