dependent drop-downs

rss

Posted by palik - Nov 9 ’16 at 04:59

I got list of devices with columns like: country, region, city

 

can i limit the values available in 'city' depending on 'region'? And, before that, limit regions depending on selected country?

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 6 years 2 months 22 days
    #1 by Dmitry Kozlov Nov 9 ’16 at 07:56

    Hi,

    If you're using SharePoint 2010, I can recommend you to use SPServices:

    https://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns&referringTitle=Documentation

  • palik
    Member
    Member for: 3 years 1 month 1 day
    #2 by palik Nov 10 ’16 at 01:38

    [#1]: can i use SPServices alonside with Forms Designer ?

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 6 years 2 months 22 days
    #3 by Dmitry Kozlov Nov 10 ’16 at 08:51

    [#2]: Sure, please, read the thread:

    http://forum.spform.com/forms-designer/how-to-use-spservices-framework-with-fd-27/

  • Luca Faro
    Luca Faro
    Member
    Member for: 2 years 10 months 25 days
    #4 by Luca Faro Jan 16 ’17 at 03:17

    [#1]: Hi Dmitry.

    When I used spservices (cascadedropdown) everything seem to work when I add an element but I don't understand why in edit mode all fields are "None" and the field value is not prompted...

    Any suggestion?

    Thanks

     

     

  • Luca Faro
    Luca Faro
    Member
    Member for: 2 years 10 months 25 days
    #5 by Luca Faro Jan 16 ’17 at 05:16

    [#4]:

    Sorry, I add some extra infos.

    This is my code (in javascript editor) - jquery and spservices linked in master

     

    window.$().SPServices.SPFilterDropdown({

    relationshipList: "Elenco manifestazioni (edizioni)",

    relationshipListColumn: "Title",

    columnName: "Manifestazione",

    CAMLQuery: "<Eq><FieldRef Name='Anno' /><Value Type='Text'>2017</Value></Eq>",

    promptText: "",

    completefunc: null,

    debug: false

    });

     

    This script works perfectly but:

    I have a "None " prompted when I add a new element (and I'd like to know how to have the first element of the list and not "None" :-))  but when I edit an element the value is always "None" even the content of the field is not "None"..

    Excuse me if this is a simple issue due to my ignorance.

     

    Thanks Luca

     

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 6 years 2 months 22 days
    #6 by Dmitry Kozlov Jan 17 ’17 at 10:36

    [#5]: Hi Luca,

    Please, set debug property in 'true' and check the output from the console (F12).

  • Luca Faro
    Luca Faro
    Member
    Member for: 2 years 10 months 25 days
    #7 by Luca Faro Jan 17 ’17 at 12:57

    Hi Dmitry and thanks for your fast reply.

    I feel really stupid but I was editing a filtered field that was correctly NOT DISPLAYED!!!!!

    Thanks again Dmitry.

    Anyway I have a question: did you plan to develope a new version of your form designer and introduce the rights for a field (not for an element)?

    The admin of my server gave me some rights and I'm playing a lot with your designer :-)

    Bye and thanks again

    Luca

  • Luca Faro
    Luca Faro
    Member
    Member for: 2 years 10 months 25 days
    #8 by Luca Faro Jan 17 ’17 at 01:05

    Hi Dmitry and thanks for your fast reply.

    I feel really stupid but I was editing a filtered field that was correctly NOT DISPLAYED!!!!!

    Thanks again Dmitry.

    Anyway I have a question: did you plan to develope a new version of your form designer and introduce the rights for a field (not for an element)?

    The admin of my server gave me some rights and I'm playing a lot with your designer :-)

    Bye and thanks again

    Luca

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 6 years 2 months 22 days
    #9 by Dmitry Kozlov Jan 19 ’17 at 11:06

    [#8]: Forms Designer allows you to create completely different forms for different security groups. You can just remove those fields which a regular user should not see:

    http://spform.com/documentation/groups

Displaying 1 to 9 of 9 messages