How to remove blank spaces from data, entered by a user in a field? (to be used in an URL)

  • Profile Image
    NippersD
    Asked on May 05, 2014 at 04:52 PM

    In the email alerts notification, I want to create a quick link URL for the user and this URL would be pre-populated with most of their completed fields.  This would allow them to go into the same online form, but this time have some fields already completed.  I cannot use the Preferences -> advanced settings as I do not want every field pre-populated.  

    The URL cannot have blank spaces for the field responses, otherwise the URL only populates the new form with the first word prior to the first space or in other cases the URL breaks completely.  Subtext helps a bit as a reminder not to have blanks spaces, but humans still make mistakes.  Due to the variability of data entry, an Input Mask cannot be used.  I've tried using the conditions wizard tool to see if there was a way to "find and replace" blanks with underscores and then transfer the new string into a hidden, read only field (to be used in the URL creation), but this did not work.  Is there something else I could try, or something I need to do in the HTML editor of the email page?  Thanks

    example URL in email alerts notification: http://form.jotform.ca/form/41236284051245&make={make}&licencePlate={licencePlate}&unit4={unit4}

  • Profile Image
    BryanPaulo
    Answered on May 05, 2014 at 05:41 PM

    Hello NippersD,

    Here's a guide on how to pre-populate JotForm via URL parameters. Entries with spaces are automatically replaced with it's HEX value %20 when being passed to the URL.

    Please let us know if you need more info.

    Bryan

  • Profile Image
    Mike_T
    Answered on May 05, 2014 at 06:11 PM

    In theory you can also try a URL Encoding, so the URL will be:

    http://form.jotform.ca/form/41236284051245?make={URLENCODE:make}&licencePlate={URLENCODE:licencePlate}&unit4={URLENCODE:unit4}

    Thank you.

  • Profile Image
    NippersD
    Answered on May 05, 2014 at 07:10 PM

    Thank you - solved the problem, and pointed me to a wealth of info on your forum regarding other URL solutions

  • Profile Image
    Welvin
    Answered on May 05, 2014 at 08:47 PM

    Great! If you require any further assistance, feel free to contact us.