Forum Discussion
DanielJohnson2
4 years agoQrew Trainee
Response from QB Care:
"So you cant pass a blank value through Pipelines. When you clear the field on the form it's not defaulting it to 0, it is just blank. Pipelines do not work with blank values so it is not changing the field in Step B because there is nothing coming from Step A.
So when you clear the value, Pipelines does not convert it to a null value or a zero it is just blank. Actually, if you changed it to a zero that would work as zero is a value."
The Pipeline is fairly straight forward to setup. Here's what my button looks like:
URLRoot() & "db/" & [_DBID_ALIAS_CHILD] & "?act=API_EditRecord&apptoken=xxxxxxxxxxxxx123456789&rid=" & [Record ID#]
& "&_fid_25_="
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ALIAS_PARENT] & "?a=er&rid=" & [Related Parent Copy])
fid=25 is the Related Parent field on the child record.
------------------------------
Daniel Johnson
------------------------------
"So you cant pass a blank value through Pipelines. When you clear the field on the form it's not defaulting it to 0, it is just blank. Pipelines do not work with blank values so it is not changing the field in Step B because there is nothing coming from Step A.
So when you clear the value, Pipelines does not convert it to a null value or a zero it is just blank. Actually, if you changed it to a zero that would work as zero is a value."
The Pipeline is fairly straight forward to setup. Here's what my button looks like:
URLRoot() & "db/" & [_DBID_ALIAS_CHILD] & "?act=API_EditRecord&apptoken=xxxxxxxxxxxxx123456789&rid=" & [Record ID#]
& "&_fid_25_="
& "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ALIAS_PARENT] & "?a=er&rid=" & [Related Parent Copy])
fid=25 is the Related Parent field on the child record.
------------------------------
Daniel Johnson
------------------------------