Skip to main content
Question

Button to Create New Form With Fields that Populate

  • May 11, 2020
  • 0 replies
  • 22 views

Hello,

I am trying to build a button that will allow for me to take the client and build the lead with the info that is provided in the variable boxes that I have listed and the set variables that are included in the formula below. It is putting the phone number, first and last name, but it is not putting the lead source or the "referral" status. It is then directing back to Dashboard and not to the edit record view in form 12 like i would like it to. Please let me know what you would change to make this work my phone number is the key field for the table we are adding to:

"https://seniorchoiceplans.quickbase.com/db/bqfx8k92p?a?a=API_addRecord" &
"&apptoken=xxxxxxxxxxxxxxx" &
"&_fid_101=" & URLEncode(User())&
"&_fid_32=Prospect" &
"&_fid_83=Referral" &
"&_fid_7="&[Phone Number]&
"&_fid_6="&[First Name]&
"&fid_38="&[Last Name]&
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() & "?a=er=fid=2&rid" & [Phone Number])

------------------------------
Benjamin Brooks
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • May 11, 2020
Try with these corrections

"https://seniorchoiceplans.quickbase.com/db/bqfx8k92p?a?a=API_addRecord" &
"&apptoken=xxxxxxxxxxxxxxx" &
"&_fid_101=" & URLEncode(User())&
"&_fid_32=Prospect" &
"&_fid_83=Referral" &
"&_fid_7="&[Phone Number]&
"&_fid_6=" & URLEncode([First Name])&
"&fid_38="& URLENcode([Last Name])&
"&rdr=" &
URLEncode(URLRoot() & "db/" & Dbid() & "?a=er&key=" & [Phone Number])

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------