Discussions

 View Only
  • 1.  Button to Check, Pause, Uncheck, Refresh

    Posted 08-30-2021 00:21
    Hi,

    I am trying to create a formula URl button that will check [Check Box A], pause by calling a Code Page, uncheck [Check Box A] then refresh to call a Pipeline, the pause being to give the Pipeline time to trigger.

    I was using one of Kirk Trachy's Magic Buttons but I need to change it at some stage because it contains java code.

    So far I've got this but not sure what the Code Page "URl is to execute" is.

    ----------------------------------------------------------------------------------------------------------------------------------

    //Check FID 367 then Uncheck FID 367
    var text url =

    URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=c7y3n83dz8fuc2n8jum5dzq4iky&rid=" & [Record ID#] & "&_fid_367=1&rdr=" &
    URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=c7y3n83dz8fuc2n8jum5dzq4iky&rid=" & [Record ID#] & "&_fid_367=0"));

    //Call Code Page
    var text callCodePage =
    URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=10" // Open CodePage 9
    & "&url=" & URLEncode($urlToExecute) // Pass in the URL to execute

    // Add some button styling
    var text style = "style='background-image: linear-gradient(to bottom, #00b300 0%, #00b300 100%); background-color:#00b300;color: white;' ";

    Any assistance would be appreciated.

    ------------------------------
    Tim Egerton
    ------------------------------


  • 2.  RE: Button to Check, Pause, Uncheck, Refresh

    Posted 08-30-2021 11:12
    Hi Tim,
    I am no Quick Base expert but I have been dealing with Kirk's magic button app and videos lately. I think what the highlighted portion is looking for is a url reference to a code page in the app home. In the app home you can make code pages which can have higher functions. I would check Kirks magic button's pages to see if he has a code page with the code for this button. From there mimic his code page and  copy the URL into the button code. I hope this helps a little bit.
    -Hank

    ------------------------------
    Hank Halverson
    ------------------------------



  • 3.  RE: Button to Check, Pause, Uncheck, Refresh

    Posted 08-31-2021 01:30
    Hi Hank,

    Thanks for the pointer.

    Tim

    ------------------------------
    Tim Egerton
    ------------------------------



  • 4.  RE: Button to Check, Pause, Uncheck, Refresh

    Posted 08-30-2021 12:41
    https://community.quickbase.com/blogs/ryan-pflederer1/2021/03/01/using-code-pages-to-refresh-with-a-delay?CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804

    It looks like you are using this or something similar to it and this page explains what the urlToExecute is. It is the URL the code page is going to execute for you while on it. You may have some struggles with the way you have this set up though. It is hard to give good advice here as this is not the whole formula or idea. For example where is your "url" var used? On another note I would not name that var just url.

    If this were me I would send the user to a code page and then have the code page execute the checking and unchecking of that particular record while verifying it got checked first before unchecking it. But that would require more JavaScript than the linked post shows. If you use Quickbase and just send the user via the api it may or may not work as anticipated based on how the URL you have above is formed. I am not sure it will work, but it might.


  • 5.  RE: Button to Check, Pause, Uncheck, Refresh

    Posted 08-31-2021 01:35
    Hi Austin,

    You are correct that is what I am trying to do.

    Actually using Kirks magic button was straight forward but with all the new features being released by QB recently maybe I'm getting to smart for myself.

    I'll keep working on it but thanks for the pointers.

    Tim

    ------------------------------
    Tim Egerton
    ------------------------------