I need help creating a button that will "convert" a lead.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am new to quickbase and am working on the sales process for our client. I have a table called Prospects (basically leads) and what I am trying to do is create a button in the prospect record that is called "Convert". What I want is for when they click convert it will create an account record and populate some of the fields with info from the prospect. Seems simple enough but I keep getting an error when trying to save the URL formula field.  Any help would be greatly appreciated. 
Photo of Ben Salisbury

Ben Salisbury

  • 132 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Can you post you most recent URL attempt?
Photo of Ben Salisbury

Ben Salisbury

  • 132 Points 100 badge 2x thumb
Yes so when I use this 

URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?a=API_GenAddRecordForm&_fid_276=" & URLEncode ([Record ID#])& "&z=" & Rurl()
It will take me to the new account record form but when I try to add fields for it to populate like this 

URLRoot() & "db/" & [_DBID_OPPORTUNITIES] & "?a=API_GenAddRecordForm&_fid_10"&[Account]&"&=&_fid_276=" & URLEncode ([Record ID#])& "&z=" & Rurl()

it is not populating the account field.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
Try this
URLRoot() & "db/" & [_DBID_OPPORTUNITIES]& "?a=API_GenAddRecordForm"
& "&_fid_10="   & [Account]
& "&_fid_276=" & URLEncode ([Record ID#])

& "&z=" & Rurl()
Photo of Ben Salisbury

Ben Salisbury

  • 132 Points 100 badge 2x thumb
That worked perfectly. Thank you!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
I like to line up my syntax vertically to help avoid syntax errors.  I still often have initial errors, but at least when I go back in to debug them, they are easier to spot.spot.