URL code help

Question

Hi,I am very new to URL coding, and everything I have done so far is copy paste from what I find (usually some code Kirk has made). I found two bits of code I would like to combine, but am not sure how to go about doing it.The first bit of code is to toggle a checkbox on and off.The second bid of code is a pop up that states "Email has been sent." I was hoping I could just add the second bit of code after the first, but I wasn't that lucky. Is it possible to combine?Thank you.If([Checkbox] = false, URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp; "&amp;rid=" &amp; [Record ID#] &amp; "&amp;apptoken=d9eascudwjxs2sesxkjccwgtq9r" &amp; "&amp;_fid_101=1" &amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;rid=" &amp; [Record ID#]), URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp; "&amp;rid=" &amp; [Record ID#] &amp; "&amp;apptoken=d9eascudwjxs2sesxkjccwgtq9r" &amp; "&amp;_fid_101=0" &amp; "&amp;rdr=" &amp; URLEncode(URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;rid=" &amp; [Record ID#]))2nd code I would like to add on
"javascript:" &amp;
"$.get('" &amp;
$url &amp;
"',function(){" &amp;
"$.jGrowl('Email has been sent', {life: 5000, theme: 'jGrowl-green'});" &amp;
"});" &amp;
"void(0);"------------------------------Mike Tamoush------------------------------

markshnier__you · Answer

Try thisvar bool NewToggle = not [The name of your checkbox field];var text URL = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;&nbsp;"&amp;rid=" &amp; [Record ID#] &amp;&nbsp;"&amp;apptoken=d9eascudwjxs2sesxkjccwgtq9r" &amp;&nbsp;"&amp;_fid_101=" &amp; $NewToggle;"javascript:" &amp;"$.get('" &amp; $url &amp; "',function(){" &amp;"$.jGrowl('Email has been sent', {life: 5000, theme: 'jGrowl-green'});" &amp;"});" &amp;"void(0);"&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

michaeltamoush · Answer

Mark,&nbsp;I don't get any error messages, and it gives me the 'email sent' message, but it doesn't toggle my checkbox. I'm not sure why? I don't know a lot about app tokens, I just am going to my settings and coping and pasting. Perhaps there is more I need to do there?------------------------------Mike Tamoush------------------------------

laurathacker · Answer

Can you:1. triple-check that FID 101 is a regular checkbox (and not a formula)2. create a new apptoken, and substitute the new one for the old one in your formula3. check the key field of your table is [Record ID#] and not some other key value instead (if you have chosen another key value; then use &amp;key=" &amp; [Key Field]4. try removing the redirect; and see if you get the XML response that shows you have made an update or have not made an update------------------------------Laura Thacker (IDS)laura@intelligentdbs.com(626) 771 0454------------------------------

markshnier__you · Answer

When&nbsp; you use that javascript, unfortunately it hides the error message.A next step is to just do thisvar bool NewToggle = not [The name of your checkbox field];var text URL = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord"&amp;&nbsp;"&amp;rid=" &amp; [Record ID#]&amp;&nbsp;"&amp;apptoken=d9eascudwjxs2sesxkjccwgtq9r"&amp;&nbsp;"&amp;_fid_101=" &amp; $NewToggle;$URLThat will simply run the URL and if there is an error message it will be exposed.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

michaeltamoush · Answer

Thank you for the suggestions Laura. A couple of updates:1) I wasn't quite sure of something before, but now I can confirm. When I first attempt, and click the button, it triggers my notification email, and sends it to me. It's as if the checkbox is in fact toggled (but not visibly so). However, that only happens twice, and then it never triggers the email notification again. At no point does my checkbox visibly toggle though. This pattern seems to 'reset' when I put in a new token number.2) I triple checked I have the correct FID and that it is a regular checkbox, and tried the new app token. Also checked that the primary key is Record ID#.&nbsp;3). I'm not sure I understand what you mean by removing the redirect? Which part of the code is the redirect?------------------------------Mike Tamoush------------------------------

Forum Discussion

URL code help

Related Content

Formula Url Buttons

URL formula -API_RunImport

Formula URL - Edit then Add

Conditional formula url

Color Coding based on field value