Stump the Panel » SharePoint Workflow for All Users

Setting a hyperlink field with a long URL

(3 posts)

  1. bhorner
    Member

    I'm trying to use SharePoint designer to set a hyperlink field with a bunch of the values that are part of that item (so that I can use the JQuery pre-populate script on another page). What happens, it seems, is that I'm hitting a character limit in creating the link, somewhere around 280, and it just errors out my workflow. My link looks like this:

    https://server/sites/site/Lists/Scheduling%20form/NewForm.aspx?Church/Event Name=TEST&Address=TEST&City=TEST&State=TEST&Zip Code=TEST&Church Phone Number=TEST&Website=TEST&Contact Name=TEST&Cell Phone=TEST&Email=TEST&Music Style=TEST&Concert Location=TEST&Dress=TEST, Schedule an Event

    Replace TEST with lookups and that's what I have. If I cut the link in half, it works, but to add all that data, it doesn't. Any ideas on how to get this to work? I tried looking at a calculated column but hyperlinks get messed up whenever there's a space involved.

    Posted 3 days ago #

  2. eric
    Moderator

    It is probabaly the Sharepoint 260 character limit your hitting. You'll have to decide what values need to be prepopulated and which ones don't (or could be set as default values on the column level).

    Posted 2 days ago #

  3. jbhoward
    Member

    Depending on how many querystring key/value pair you might end up with (and the length of the values), you'll most likely need to shorten your keys:

    Church/Event Name = n (BTW, that / is going to give you trouble, anyway)
    Address = a
    City = c
    etc.

    https://server/sites/Lists/Scheduling%20form/NewForm.aspx?n=TEST&a=TEST&c=TEST…

    You might also make your link relative:

    /sites/Lists/Scheduling%20form/…

    or from QuickLaunch:

    Lists/Scheduling%20form/…

    Where are you getting the lookups? And why are you prefilling so many? Wouldn't it be better to set defaults in the columns?

    Where is this hyperlink going to be? Could you concatenate a couple of fields when you are drawing the link, rather than trying to store it all in one field?

    Blessings,
    Jim Bob

    Posted 2 days ago #

RSS feed for this topic

Reply

You must log in to post.