Discussions

 View Only
  • 1.  Formula Not Completing

    Posted 08-18-2022 12:27
    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
    ------------------------------


  • 2.  RE: Formula Not Completing

    Posted 08-18-2022 12:44
    You've to encode your field like below to escape # in URL formula

    URLENCODE([Problem Statement])

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



  • 3.  RE: Formula Not Completing

    Posted 08-18-2022 15:09
    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?

    image

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



  • 4.  RE: Formula Not Completing

    Posted 08-19-2022 01:20
    you can try URLENCODE(TOTEXT(YOURFIELD))

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