Forum Discussion

JENNIFERPASCHAL's avatar
JENNIFERPASCHAL
Qrew Trainee
2 years ago

Formula Not Completing

Hello,

I recently submitted a question here regarding creating a new record with values copied over from the original (by using formulas instead of the native QB copy functionality).  (question linked here if needed)

After some more testing I noticed the formula fails on certain characters. Below is my current formula. For example if [Problem Statement] is...

Build X provisioning work flow from X to downstream systems, building on the capabilities from 1234 ABC (X) (ABCD-e) (QB# 1234)

...The formula will copy all fields ABOVE [Problem Statement] in the formula, it will only copy over the text within [Problem Statement] up until the "#' symbol, and then none of the other fields in the formula are copied over. I have also seen the same happen with "&".

How can i structure my formula so it does not fail once it reaches certain characters?

URLRoot() & "db/" & [_DBID_INTAKE] & "?a=API_GenAddRecordForm"

& "&_fid_8=" & [Initiative Type]
& "&_fid_7=" & [Requesting Business Unit]
& "&_fid_117=" & [Initiative Name]
& "&_fid_743=" & [Simplified Description]
& "&_fid_16=" & [Problem Statement]
& "&_fid_52=" & [Requestor]
& "&_fid_200=" & [TSM]
& "&_fid_11=" & [Channel(s) Impacted]
& "&_fid_12=" & [Product(s) Impacted]
& "&_fid_17=" & [Customer Experience(s)]
& "&_fid_18=" & [Employee Experience(s)]
& "&_fid_19=" & [Quantifiable Benefit Estimate]
& "&_fid_20=" & [Benefit Calculation]
& "&_fid_137=" & [Detailed Description]
& "&_fid_401=" & "NA"
& "&_fid_474=" & "Yes"
& "&_fid_116=" & "No"
& "&_fid_359=" & "N/A"
& "&_fid_856=" & "Yes"

------------------------------
Thanks in advance,
Jennifer Paschal
------------------------------

3 Replies

  • PrashantMaheshw's avatar
    PrashantMaheshw
    Qrew Assistant Captain
    You've to encode your field like below to escape # in URL formula

    URLENCODE([Problem Statement])ā€‹

    ------------------------------
    Prashant Maheshwari
    ------------------------------
    • JENNIFERPASCHAL's avatar
      JENNIFERPASCHAL
      Qrew Trainee
      Thank you! This worked for all the regular text fields but did not work for the textlist fields. Is there a way to get this to work with those field types?



      ------------------------------
      Thanks in advance,
      Jennifer Paschal
      ------------------------------
      • PrashantMaheshw's avatar
        PrashantMaheshw
        Qrew Assistant Captain
        you can try URLENCODE(TOTEXT(YOURFIELD))

        ------------------------------
        Prashant Maheshwari
        ------------------------------