Forum Discussion

BenjaminBrooks's avatar
BenjaminBrooks
Qrew Trainee
4 years ago

Button to Create New Form With Fields that Populate

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
------------------------------

6 Replies

  • 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
    ------------------------------
    • BenjaminBrooks's avatar
      BenjaminBrooks
      Qrew Trainee
      First Name is good
      Last Name is good
      Phone number is good
      Nothing in 101,32,83

      brought me to dashboard and not return to form 12 in edit which the button exists on form 18

      ------------------------------
      Benjamin Brooks
      ------------------------------
      • BenjaminBrooks's avatar
        BenjaminBrooks
        Qrew Trainee
        Fid 32 and 83 area text multichoice btw

        ------------------------------
        Benjamin Brooks
        ------------------------------