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

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • In Progress
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.
Photo of Amber Polston

Amber Polston

  • 642 Points 500 badge 2x thumb

Posted 4 weeks ago

  • 0
  • 1
Photo of Micro Dev

Micro Dev

  • 1,906 Points 1k badge 2x thumb
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.
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.

Photo of vijay singh

vijay singh

  • 342 Points 250 badge 2x thumb
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.