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
------------------------------
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
------------------------------
