-
ocstokrodeAsked on February 21, 2021 at 6:39 AM
Can you explain why sometimes things goes wrong :-)
I have a form and this will provide populated fields to another form.
In the first form I have filled in the (test)name "Louis Pidgeon"
I made screenshot of the confirmation mails I received.
I have two different confirmation mails and in both the name was correct displayed.However in the Target form there goes something wrong with the name:
So and extra %2 0 are added.
This happens not always. In most of the subscriptions it went well, but sometimes is goes wrong for one or other reason. So also in the reports of course it will also be displayed on the wrong way.How can we avoid this?
I can't divide the field name into two field (first name and last name) cause this is the filename for the name of a supplier company. And in case the company name is it's Coca Cola it would be strange to split it :-)
(the URL is the one from the Source form / the first form)Page URL: https://form.jotform.com/203112680616043 -
Ashwin JotForm SupportReplied on February 21, 2021 at 11:30 AM
It seems the users are putting extra space in the name field and when the value is being passed to another form, the space is not encoded. I would suggest you to please use "{URLENCODE:xxxxxxxx}" in the URL parameter.
Here is the URL you need to add in email alert:
https://form.jotform.com/203123288139352?pop={nummerBetalingsopdracht}&pop132={boekingsnummerVan}&pop133={leverancier}&pop134={adres}&pop135={postcode}&pop136={gemeente}&pop137={land}&pop138={btw123}&pop139={bank}&pop140={factuurnummer}&pop141={factuurdatum95}&pop142={totaalbedragFactuur22}&pop143={factuurbedragexcl}&pop144={omschrijvingGoederen}&pop145={uitspltsingVan}&pop146={basisbedragVoor98}&pop147={basisbedragVoor}&pop148={basisbedragVoor99}&pop149={bedragintracommunitaire}&pop150={bedragAan19}&pop151={bedragAan20}&pop152={bedragBTW21}&btw153={bedragAan120}&pop154={totaalbedragenAan}&pop155={leeggoedFactuur94}&pop156={leeggoedCredit108}&pop157={totaalLeeggoed}&pop158={omschrijving}&pop159={gestructureerdeMededeling166}&pop160={vervaldatum25}&pop161={vervaldatumin}&pop162={opmeringenVoor}&pop163={betalingsopdrachtIn}&pop164={naamMedewerker}&pop165={adresMedewerker}&pop166={rekeningnummer}&bedrag167={bedragTotaal}&pop168={bedragMet}&pop212={omschrijving44}&pop169={eventueleOpmerking}&pop170={naam}&pop171={adres164}&pop172={rekeningnummer48}&pop173={bedrag}&pop175={omschrijving}&pop176={gestructureerdeMededeling}&pop177={teBetalen85}&pop178={opmerkingenVoor82}&pop179={naam66}&pop180={rekeningnummer67}&pop181={bedrag68}&pop182={gestructureerdeMededeling69}&pop183={teBetalen}&pop184={teBetalen84}&pop185={opmerkingenVoor162}&fUitsplitsing={t144}&fBedrag={t147}&fBedrag188={t}&fBedrag189={t149}&fBedrag190={t150}&fFactuurbedrag={t151}&fBedrag192={t156}&fTotaalbedrag={t158}&fNaam={URLENCODE:t152}&fAdres={t157}&fVervaldatum={t153}&fTekst={t161}&fRekeningnummer={t154}&fMededeling={t155}&fOpmerking={t159}&fSysteemdatum203={Systeemdatum}&fDatumveld={datumveldVan}&fBetalingsopdracht={betalingsopdrachtNaar}&basisbedragVoor186={pop222}&bedragAan={pop223}
Hope this helps.
Do get back to us if you have any questions.