I'm having trouble getting a dynamic picklist to work properly . Here are the specs for the 3 forms:
Form 1: Supervisor
Fields: Super_Name, Super_Location
Form 2: AC
Fields: AC_FirstName, AC_LastName, AC_ID (unique), AC_Supervisor (dynamically from form Supervisor.Super_Name)
Form 3: Input
Fields: PreCall_Supervisor (dynamic dropdown picked from Supervisor.Super_Name, working ok), PreCall_AC (dynamic dropdown to show only AC_FirstName, AC_LastName based on the selection in the previous dropdown, PreCall_Supervisor)
The field PreCall_AC does not populate any data when the PreCall_Supervisor dropdown is selected as intended.
Here is the code that is currently residing on With Action:
must have PreCall_Supervisor
(
displayname = "Supervisor"
type = picklist
values = Supervisor.ID
displayformat = [ Super_Name + " - " + Supervisor_Location ]
sortorder = ascending
width = 206px
)
PreCall_AC
(
displayname = "AC"
type = picklist
values = AC[AC_Supervisor.Super_Name == "input.PreCall_Supervisor"].ID
displayformat = [ AC_FirstName + " " + AC_LastName ]
sortorder = ascending
width = 206px
)