How to create Cascading Drop Down list in SharePoint Online/2016/2013/2010 - Using SP Services (JS )

Поделиться
HTML-код
  • Опубликовано: 30 янв 2025

Комментарии • 119

  • @ishan.upreti
    @ishan.upreti 3 года назад

    Thank you for the detailed video...
    And your internet speed is really very good ;)

  • @feda6004
    @feda6004 Год назад

    Thanks that's exactly what i was looking for

  • @jonaskarlsson477
    @jonaskarlsson477 3 года назад +2

    Why is my Form web parts not active? i cant press it its just grayed out

  • @fabioserenelli
    @fabioserenelli Год назад

    Thanks for the video. Does this method work for more 'modern' Microsoft list versions?

  • @maneenuchk6472
    @maneenuchk6472 2 года назад

    Very helpful, thanks for the video Lernen 😀😀😀

  • @phongthanhnguyen4899
    @phongthanhnguyen4899 3 года назад +1

    Very helpful, thanks for the video Lernen 👍. Is there any way you can share the code since the 2nd line was cut off?

  • @FSchimidtBR
    @FSchimidtBR 2 года назад

    Does this only work in Sharepoint "classic experience"? Can SPServices be used in "new experience"?

  • @udaykumar3043
    @udaykumar3043 Год назад

    Can't we do this cascading dropdowns in modern site?

  • @table031
    @table031 3 года назад

    Hi Lernen, these is a problem i can't solve it. When i down the all process, the second list (OutPutCountry) still show "none".
    How should I do ? please~ Hope you will see it

  • @BNR7979
    @BNR7979 Год назад

    Good information

  • @jasonstryker196
    @jasonstryker196 5 лет назад

    Hi. Can I add a space in the output column? Instead if OutputRegion, can I have Output Region? Thanks

  • @aaronhairston6057
    @aaronhairston6057 5 лет назад +3

    This was an excellent walk through, but I have encountered a problem with the way it works.
    When creating new records the drop-down works correctly, however when editing an existing record all the entries for the relationship list are shown.
    Is there a way to enforce the cascading drop-down while editing the record?
    Edit: I had to add the script to the edit page as well as the new page

    • @gustavodalpai4293
      @gustavodalpai4293 5 лет назад

      Hello Aaron, how did you solve this problem? Could you share with us?

    • @aaronhairston6057
      @aaronhairston6057 5 лет назад +1

      @@gustavodalpai4293 it's the same process as above, but you need to insert the code I to a custom web part on the edit item page.
      To get there edit a list item while in legacy, click on the ribbon to add a custom web part (same as shown on the video), and add the code from the video to the web part.

    • @LernenTech
      @LernenTech  5 лет назад

      hope you got the answer

    • @aaronhairston6057
      @aaronhairston6057 5 лет назад

      @@LernenTech I did, I just had to add the custom web part to the page where list items are updated.

    • @gustavodalpai4293
      @gustavodalpai4293 5 лет назад

      @@aaronhairston6057 In legacy I have two options: "new item" or "edit" this list
      . I click on "edit" and a list appears in spreadsheet format. But by adding the code in "Form Web Parts" and testing the option to edit I continue to see all countries. :S

  • @dondoyluna2574
    @dondoyluna2574 4 года назад +2

    Where to get the code?

  • @olenaoleary7218
    @olenaoleary7218 2 года назад

    Hello. Is there solution for today. I see this menu disabled nowadays

  • @waels.abughres5599
    @waels.abughres5599 5 лет назад +2

    Thanks for this video, i've followed this video and i've added the code at the end but it is stiil the same when i select Particular
    region i get all countries with no errors

  • @marsalkobarbara6987
    @marsalkobarbara6987 5 лет назад +1

    Thanks for the walkthrough, it worked for me! Is there a way to do the same for Quick Edit? If I try to edit the properties of my items there, it still brings up the whole list in the second dropdown regardless of what I chose in the first one. Thank you.

    • @LernenTech
      @LernenTech  5 лет назад

      didn't try that yet

    • @tw5683
      @tw5683 4 года назад +2

      Ever get this to work in Quick Edit?

  • @londonengland2309
    @londonengland2309 3 года назад

    This also means maintaining and updating 3 separate lists, right?

  • @ray-jaygenova7183
    @ray-jaygenova7183 4 года назад +1

    Hello, I tried your code but still, nothing happens with my dropdown. Please share the complete step or procedure of this. Thanks!!

  • @adamkorejwa776
    @adamkorejwa776 5 лет назад +1

    Can you switch from classic view after adding the code?

  • @jaypatel9316
    @jaypatel9316 5 лет назад +1

    I am trying to do the same as you are mentioning in RUclips video. I typed all thing correctly but still I am getting error like Error in function
    SPServices.SPCascadeDropdowns
    Parameter
    relationshipListParentColumn: Site or relationshipListChildColumn: Facility
    Message
    Not found in relationshipList Facility
    Your help will be highly appreciated. Thanks

    • @Vlerden
      @Vlerden 5 лет назад

      it looks like the SPServices java script library is no longer there. I'm getting 404d

    • @jaypatel9316
      @jaypatel9316 5 лет назад

      @@Vlerden so now?? Any other option??

    • @CrazyMade
      @CrazyMade 5 лет назад

      You would have done spelling mistakes..
      It's working charm to me ...I too received the error ... Spelling mistakes...corrected working fine

  • @alexapr2012
    @alexapr2012 5 лет назад +1

    where Can I download the web script in order to copy-paste?

  • @williepinaga7046
    @williepinaga7046 4 года назад

    Thanks for the video Lernen. Is there any way you can share the code since the 2nd line was cut off?

  • @xxx-hx2yp
    @xxx-hx2yp 4 года назад +1

    Thanks Lernen Tech. can i get the code ?

  • @srikanthhn2229
    @srikanthhn2229 5 лет назад

    Thanks Lernen Tech. From where can i get the code.

  • @neelamsoni1846
    @neelamsoni1846 3 года назад

    Hi I have tried it but it is not working for me

  • @gustavodalpai4293
    @gustavodalpai4293 5 лет назад

    Hello! Thanks for the video. But I have a doubt. I selected Lookup as an information type, but when I add a new item to my list the (None) option appears. Do you know what I need to do to remove this option?

    • @fever040
      @fever040 5 лет назад

      make sure the "Require that this column contains information:
      " option in the column is set to yes

    • @LernenTech
      @LernenTech  5 лет назад

      i hope you got the answer

  • @elenaodonovan785
    @elenaodonovan785 4 года назад

    instead of adding a new list to add State, can we just a new column within Country?

  • @aaqifshaikh7863
    @aaqifshaikh7863 4 года назад

    For Form Web Parts, it shows me that this control is currently disabled. Can you please tell me where I'm going wrong ?

    • @LernenTech
      @LernenTech  4 года назад

      lernentech@gmail.com for additional query

  • @tokiclone
    @tokiclone 3 года назад

    "Form web parts" is disabled, if I have no SharePoint admin privilege - I believe almost business user have no this, then your script can't run.

  • @virajmaisuria2006
    @virajmaisuria2006 Год назад

    Great video, could I please get this code.

  • @jitenprasadtarai1691
    @jitenprasadtarai1691 4 года назад

    very very informative

  • @jnncxii
    @jnncxii 4 года назад +1

    Hi, i followed your tutorial and manually copy the code presented in your video, and still nothing happens with my dropdown, can you share your code? Already emailed you. Thank you!

  • @jobmagautu
    @jobmagautu 5 лет назад

    Thanks for this tutorial. I followed your instructions to create somethinig similar but for Sites and Facilities in those sites. But when I run the code, I get this error. "Error in function
    SPServices.SPCascadeDropdowns
    Parameter
    relationshipListParentColumn: Site or relationshipListChildColumn: Facility
    Message
    Not found in relationshipList Facility
    Click to continue"
    What does it mean?

    • @LernenTech
      @LernenTech  5 лет назад

      there might be some miss in column name or the reference you are providing...please watch video carefully and let me know if it still exist.

    • @estrach86
      @estrach86 5 лет назад +1

      @@LernenTech I keep getting the same error even though I have thoroughly checked to make sure the column names and lists match correctly.

    • @LernenTech
      @LernenTech  5 лет назад

      @@estrach86 start thing from scratch you might doing some small mistake or write to me at lernentech@gmail.com

    • @jaypatel9316
      @jaypatel9316 5 лет назад

      Same thing I am getting. Did you find solution for that?

    • @racel24
      @racel24 5 лет назад

      Me too got the same error

  • @KumarSingh-bt5li
    @KumarSingh-bt5li 5 лет назад

    It's working for me ...But what can I do if have four combinations

  • @jray1429
    @jray1429 3 года назад

    Thank you VERY MUCH ← This is very helpful

  • @Firetalon-1121
    @Firetalon-1121 5 лет назад

    Does this only works for "Country" "State" scenarios?

    • @LernenTech
      @LernenTech  5 лет назад +1

      No you can choose your custom values

    • @Firetalon-1121
      @Firetalon-1121 5 лет назад

      I am also getting an error "not found in relationshiplist..."

    • @LernenTech
      @LernenTech  5 лет назад

      Please check the values in your list and their relationship

  • @markbassig1974
    @markbassig1974 4 года назад

    I have not tried but I am asking if anyone successful trying the solution when the cascading field is a required field. While making fields required, JS stops working.

  • @ricasortijas6251
    @ricasortijas6251 4 года назад

    I tried it in SharePoint List and it works fine. but is this possible for SharePoint Document Library?

  • @pakcikkitaro
    @pakcikkitaro 3 года назад

    Can i get full script this JS

  • @robertogarcia5028
    @robertogarcia5028 5 лет назад

    favor, do you have the code to share? so we can just copy past? #thanks

    • @LernenTech
      @LernenTech  5 лет назад

      not having right now small one you can just follow along

  • @kartikawulandari3284
    @kartikawulandari3284 4 года назад

    Have you ever tried it on SharePoint 2010? Will it work in SharePoint 2010?

  • @rajapicta1023
    @rajapicta1023 4 года назад

    Will you be able to share the code?

    • @LernenTech
      @LernenTech  4 года назад

      I lost it, you can google it.

  • @TheAmazeer
    @TheAmazeer 5 лет назад +3

    All that stuff only to filter a list regarding what is selected on another one, a bit pain in the ass

  • @Artiqx
    @Artiqx 4 года назад

    Thanks, however please paste the code next time in the comment as a link/upload. Also make sure it is working in (Quick) Edit Mode. Unfortunately, I cannot use this method. Is there a more up to date and elegant method for a simple cascading dropdown in SharePoint in the year 2020? It is unbelievable how complicated it still seems.

    • @LernenTech
      @LernenTech  4 года назад +1

      here you go with 2020 example - ruclips.net/video/DCkBraZZgZI/видео.html

  • @venugopalkorlahalli3351
    @venugopalkorlahalli3351 2 года назад

    Can we get the code pls

    • @LernenTech
      @LernenTech  2 года назад

      don't have now it's old one

  • @pratafwd
    @pratafwd 4 года назад

    I cannot believe that it is that complicated to get something too basic... isn't there any other option to cascade dropdown menus? I want to use them in a custom powerapps form

  • @tourcharl
    @tourcharl 5 лет назад

    super thanks

    • @pravin.jadhav3359
      @pravin.jadhav3359 5 лет назад

      $(document).ready(Function () {
      $().SPServices.SPCascadeDropdowns({
      relationshiplist:"Countary"
      relationshiplistParentColumn:"Region"
      relationshiplistPChildColumn:"Title"
      parentColumn:""
      ChildColumn:""
      debug: true
      });
      })

  • @eversonrafael8174
    @eversonrafael8174 5 лет назад

    Hello! Thanks for the video. But i have problem, i Can't put code JS on the Webpart, because my Sharepoint is 365 and dosen't have option to put. Anyone can help me?

    • @LernenTech
      @LernenTech  5 лет назад

      run your list classic mode

    • @aaronhairston6057
      @aaronhairston6057 5 лет назад +1

      You may need to assign yourself permissions to create custom scripts. This is not a default permission for any standard permission level

    • @ToddGreene
      @ToddGreene 4 года назад

      @@aaronhairston6057 This also happened to me. I had my IT team update my permissions and then it worked.

  • @Witiux
    @Witiux 5 лет назад

    Hey man! How can I get the code?
    Thanks for the video

    • @LernenTech
      @LernenTech  5 лет назад

      lernentech@gmail.com send hi message

    • @Witiux
      @Witiux 5 лет назад

      @@LernenTech thanks...I got it now, I literally copy+paste the code directly from your video!
      It worked like a charm...thanks bro!

    • @LernenTech
      @LernenTech  5 лет назад

      @@Witiux your welcome

    • @MattPB
      @MattPB 5 лет назад

      Andy Moya Ortega anychance I can get a copy of that code?

    • @kurniasihfajar2002
      @kurniasihfajar2002 5 лет назад

      @@LernenTech Hi Bro, I send message you. Please reply. thx

  • @lashler3
    @lashler3 6 лет назад

    Thanks

  • @qvarelli
    @qvarelli 3 года назад

    Could share the code, thanks in advance

    • @LernenTech
      @LernenTech  3 года назад

      In the description

    • @amechia
      @amechia 3 года назад

      @@LernenTech Do you have the new code?

  • @SumitG189
    @SumitG189 4 года назад

    Can someone get the code for this video?

    • @LernenTech
      @LernenTech  4 года назад

      will share in description.

  • @schmittyrusmsncom
    @schmittyrusmsncom 4 года назад

    @lernen tech I sent you an email. Thanks!

  • @istifaaqamarzaman761
    @istifaaqamarzaman761 5 лет назад

    Hi can I get the code

    • @LernenTech
      @LernenTech  5 лет назад

      code already mention in video or you can google it for reference.

    • @istifaaqamarzaman761
      @istifaaqamarzaman761 5 лет назад

      @@LernenTech I keep getting an error saying "relationship list country" not found...any idea what I'm doing wrong

    • @LernenTech
      @LernenTech  5 лет назад

      @@istifaaqamarzaman761 have you created country list if yes have you created lookup column there