Cascading Dropdown Issue

Forums Dynamic Forms for SharePoint Cascading Dropdown Issue

This topic contains 3 replies, has 2 voices, and was last updated by  Alexander Bautz 1 month ago.

  • Author
    Posts
  • #23219

    Notrega
    Participant

    I have a calendar1 that pulls from a list1, user selects an email and 5 other fields populate. I have this working perfectly. However when I duplicate this with calendar2 and list2 created with templates from calendar1 and list1 respectively I can pull only the first field. Below is the debug… There is zero difference other than the lookuplist name. This exact configuration works with calendar1 and list1 but will only pull the first field.

    What am I doing wrong?

    Problem calendar2 and list2

    
    
    [SPJS Cascading dropdowns v3.7.13] :: DEBUG
    Function called with these arguments:
    lookupList:Escambia Roster
    lookupListBaseUrl:/teams/Detention
    lookupListFields:Employee_x002a_/UserName,Shift_,Trainee_x0020_Y_x002f_N,vh0m,utqp,Current_x0020_Title_x0020_,Id
    thisListFields:Employee_x002a_,Shift__,Status,RDO_Long,RDO_Short,Rank
    dropDownDefaultvalue:
    filter:
    hideEmptyDropdowns:false
    autoselectSingleOption:true
    clearInvalidSelection:false
    sideBySide:false
    debug:true
    dataSourceId:Escambia Roster
    numberOfDropdowns:7
    Populating this field
    Employee_x002a_
    Number of items returned
    42

    Working calendar1 and list1

    
    
    [SPJS Cascading dropdowns v3.7.13] :: DEBUG
    Function called with these arguments:
    lookupList:Duval Roster
    lookupListBaseUrl:/teams/Detention
    lookupListFields:Employee_x002a_/UserName,Shift_,Trainee_x0020_Y_x002f_N,vh0m,utqp,Current_x0020_Title_x0020_,Id
    thisListFields:Employee_x002a_,Shift__,Status,RDO_Long,RDO_Short,Rank
    dropDownDefaultvalue:
    filter:
    hideEmptyDropdowns:false
    autoselectSingleOption:true
    clearInvalidSelection:false
    sideBySide:false
    debug:true
    dataSourceId:Duval Roster
    numberOfDropdowns:7
    Populating this field
    Employee_x002a_
    Number of items returned
    63
    Populating this field
    Shift_
    Number of items returned
    1
    Populating this field
    Status
    Number of items returned
    1
    Populating this field
    RDO_Long
    Number of items returned
    1
    Populating this field
    RDO_Short
    Number of items returned
    1
    Populating this field
    Rank
    Number of items returned
    1
  • #23234

    Alexander Bautz
    Keymaster

    Hi,
    It’s hard to tell without looking at it. Do you see any errors in the developer console (hit F12 > Console)?

    You do have all the fields visible in the form so you can see the dropdowns that is not populating – right?

    Alexander

  • #23236

    Notrega
    Participant

    No errors in the developer console and all the fields are visible. The first field is actually a people picker – I changed that to a text field calculated on the people picker and got it to work – but the other calendar/list is still plugging along… I guess I need to change that over too in case it fails.

  • #23250

    Alexander Bautz
    Keymaster

    I’m glad you found a workaround. I do think it should work if the people picker is single choice, but it’s probably safer to use a text field or calculated value instead.

    Alexander

You must be logged in to reply to this topic.