Use setFieldValue with Cascading dropdowns

Forums SPJS-Utility Use setFieldValue with Cascading dropdowns

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

  • Author
    Posts
  • #7017

    Brent Caudill
    Participant

    I am using a function call to set a number of field values via setFieldValue and am having difficulty getting a field that is part of a Cascading dropdown to update. I am using spjs-utility v1.183 w/DFFS 4.2

    Is there a trick to updating this field via setFieldValue? Or should I use a different method? I’ve tried a number of different jquery updates, but can’t quite get it to update.

    Thanks,

    Brent

    • This topic was modified 2 years, 10 months ago by  Brent Caudill.
  • #7020

    Alexander Bautz
    Keymaster

    Hi,
    The problem is that the field is actually a single line of text field (but the input is hidden), and the script generates a dropdown in its place. This means that using “setFieldValue” will set the single line of text field because the script “knows” this field is of type single line of text. You must therefore add another line of code to find the select and set its value “manually”.

    Alexander

  • #8615

    David S Kaimann
    Participant

    Hi there!

    I just wanted to add an additional comment / question on this topic. Basically, I’d like to leverage the same “idea” here when using the “Mutli” option. Here’s what I have / what I’m trying to do:

    Cascade 1: Project Status
    Cascade 2: Project Manager
    Cascade 3 (multi): Project Name

    Ideally, I want the last cascade to include a URL / Hyperlink that I’ve stored in a calculated column, but it the “multi” box doesn’t display or save the full URL. I’m fine storing just the “text”, but I’d really like to be able to be able to store the URL in <i>another field</i> if I can’t get the URL / Hyperlink to come through in the “multi” option. I’m basically trying to replicate the “Lookup” function in SharePoint for multiple values since it would let me add multiple links back to the other item (in a many to one relationship).

    I’ve attached screenshots as well.

    Thanks!

    Attachments:
    1. Cascade.docx
  • #8647

    Alexander Bautz
    Keymaster

    Hi,
    Sorry for the delay. I’m afraid this will not work with this solution as it is based on plain text multiline fields. This means that even if you managed to put the links in, list views would just display them as plain text – revealing the HTML code as text.

    Alexander

You must be logged in to reply to this topic.