Forum Discussion
QuickbaseUser1
10 years agoQrew Trainee
is this it?
If([# of Opportunities]<1,
URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?act=API_AddRecord&apptoken=xxxxxxxxxxxxxx"
& "&_fid_397=" & URLEncode ([Record ID#])
& "&_fid_381=" & URLEncode ([Sales Manager Record ID#])
& "&_fid_254=" & URLEncode([Standex-Meder Part Number])
& "&_fid_339=" & URLEncode("No")
& "&rdr=" & [_DBID_LEADS] & URLEncode("?a=dr&rid="&[Record ID#]),null)
If([# of Opportunities]<1,
URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?act=API_AddRecord&apptoken=xxxxxxxxxxxxxx"
& "&_fid_397=" & URLEncode ([Record ID#])
& "&_fid_381=" & URLEncode ([Sales Manager Record ID#])
& "&_fid_254=" & URLEncode([Standex-Meder Part Number])
& "&_fid_339=" & URLEncode("No")
& "&rdr=" & [_DBID_LEADS] & URLEncode("?a=dr&rid="&[Record ID#]),null)