User input to formula URL

  • 0
  • 2
  • Question
  • Updated 2 years ago
  • Answered

I am looking to modify the below logic to accept a numeric user input (Quantity) and apply that value to a field in my add record form. 


URLRoot() & "db/" & [_DBID_TABLE_NAME] & "?a=nwr&"&"dfid=11" &
"&_fid_45=VALUE" &
"&_fid_13=" & URLEncode ([Record ID#]) &
"&_fid_21=" & [Related Item Master] &

"&_fid_22=$Quanitity" &

"&z=" & Rurl()


Photo of Justry Weir

Justry Weir

  • 10 Points

Posted 3 years ago

  • 0
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
Try something like:

&_fid_22="&URLEncode(ToNumber([Quantity Field]))&"