Why is this formula putting the record ID into the last name?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hey all,

I have the Add to Employees formula, which totally works except for one weird thing... it adds the record ID to the last name of the new employee.  I think this somehow is because of the URLencode, but I can't really tell.  I'm sure my formula just needs tweaking... ideas?


URLRoot() & 

"db/bi99eyts3?a=API_GenAddRecordForm&_fid_44=" &

"&_fid_15=" & [NH - First Name] &

"&_fid_16=" & [NH - Last Name] &

URLEncode ([Record ID#]) &

"&nexturl="  & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" &[Record ID#])


Thanks!

Michael Custer

Photo of Michael

Michael

  • 20 Points

Posted 4 years ago

  • 0
  • 1
Photo of Rama

Rama

  • 0 Points
in your URL you are setting field ID 16 to the last name AND the record ID.  


if youre generating a new record you dont need the record id in the first half of your formula
Photo of Michael

Michael

  • 20 Points
that was it, thanks!