Button to Create New Form With Fields that Populate

Question

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" &amp; "&amp;apptoken=xxxxxxxxxxxxxxx" &amp; "&amp;_fid_101=" &amp; URLEncode(User())&amp;  "&amp;_fid_32=Prospect" &amp; "&amp;_fid_83=Referral" &amp; "&amp;_fid_7="&amp;[Phone Number]&amp; "&amp;_fid_6="&amp;[First Name]&amp; "&amp;fid_38="&amp;[Last Name]&amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=er=fid=2&amp;rid" &amp; [Phone Number])------------------------------Benjamin Brooks------------------------------

markshnier__you · Answer

Try with these corrections"https://seniorchoiceplans.quickbase.com/db/bqfx8k92p?a?a=API_addRecord" &amp;"&amp;apptoken=xxxxxxxxxxxxxxx" &amp;"&amp;_fid_101=" &amp; URLEncode(User())&amp;"&amp;_fid_32=Prospect" &amp;"&amp;_fid_83=Referral" &amp;"&amp;_fid_7="&amp;[Phone Number]&amp;"&amp;_fid_6=" &amp; URLEncode([First Name])&amp;"&amp;fid_38="&amp; URLENcode([Last Name])&amp;"&amp;rdr=" &amp;URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=er&amp;key=" &amp; [Phone Number])------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

benjaminbrooks · Answer

First Name is goodLast Name is goodPhone number is goodNothing in 101,32,83brought me to dashboard and not return to form 12 in edit which the button exists on form 18------------------------------Benjamin Brooks------------------------------

benjaminbrooks · Answer

Fid 32 and 83 area text multichoice btw------------------------------Benjamin Brooks------------------------------

markshnier__you · Answer

try this one."https://seniorchoiceplans.quickbase.com/db/bqfx8k92p?act=API_AddRecord" &amp;"&amp;apptoken=xxxxxxxxxxxxxxx" &amp;"&amp;_fid_101=" &amp; totext(User())&amp;"&amp;_fid_32=Prospect" &amp;"&amp;_fid_83=Referral" &amp;"&amp;_fid_7="&amp;[Phone Number]&amp;"&amp;_fid_6=" &amp;&nbsp;URLEncode([First Name])&amp;"&amp;_fid_38="&amp;&nbsp;URLENcode([Last Name])&amp;"&amp;rdr=" &amp;URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp;&nbsp;"?a=er&amp;key=" &amp;&nbsp;[Phone Number])The redirect should work, but if for some reason we cannot get it to work, then tnhis would land the user onthe recor in view mode"https://seniorchoiceplans.quickbase.com/db/bqfx8k92p?act=API_AddRecord" &amp;"&amp;apptoken=xxxxxxxxxxxxxxx" &amp;"&amp;_fid_101=" &amp; totext(User())&amp;"&amp;_fid_32=Prospect" &amp;"&amp;_fid_83=Referral" &amp;"&amp;_fid_7="&amp;[Phone Number]&amp;"&amp;_fid_6=" &amp;&nbsp;URLEncode([First Name])&amp;"&amp;fid_38="&amp;&nbsp;URLENcode([Last Name])&amp;"&amp;disprec=1"if your formula is not working,&nbsp; can you post the latest version?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

benjaminbrooks · Answer

Above is the form that we are filling out and the button that is new client referral is our work in progress this is form ID&nbsp; 18

Above is what we are trying to push to this is form id 2Tried this and got the same:"https://seniorchoiceplans.quickbase.com/db/bqfx8k92p?a?a=API_addRecord" &amp;"&amp;apptoken=xxxxxx" &amp;"&amp;_fid_101=" &amp; ToText(User())&amp;"&amp;_fid_32=Prospect" &amp;"&amp;_fid_83=Referral" &amp;"&amp;_fid_7="&amp;[Phone Number]&amp;"&amp;_fid_6=" &amp; URLEncode([First Name])&amp;"&amp;fid_38="&amp; URLEncode([Last Name])&amp;"&amp;rdr=" &amp;URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=er&amp;key=" &amp; [Phone Number])As well as this and got the same:"https://seniorchoiceplans.quickbase.com/db/bqfx8k92p?act=API_AddRecord" &amp;"&amp;apptoken=xxxxxxxxxxx" &amp;"&amp;_fid_101=" &amp; ToText(User())&amp;"&amp;_fid_32=Prospect" &amp;"&amp;_fid_83=Referral" &amp;"&amp;_fid_7="&amp;[Phone Number]&amp;"&amp;_fid_6=" &amp; URLEncode([First Name])&amp;"&amp;fid_38="&amp; URLEncode([Last Name])&amp;"&amp;disprec=1"Neither are taking me to the form that i want though it is taking me to dashboard!

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

Forum Discussion

Button to Create New Form With Fields that Populate

Related Content

Add button to create record in different app

New Form - Show Create Record button

API Button Help

Delete Formula Button Error

Formula Url Buttons