Discussions

 View Only
  • 1.  Reoccuring Tasks - Still No Solution

    Posted 20 days ago

    Hello, 

    Below is a YouTube of something I want to do so badly for one of my tables, and I cannot figure out how to configure it to my tables. 
    The examples he provided are tailored to his table.

    Please help! 
    I have reached out to QuickBase support as well, and they've been trying to do something for over a month, it is something I need sooner than later, and this is exactly the way I want it, I just can't read the code well enough.

    SOS?

    https://www.youtube.com/watch?v=OtE_j7kPJK0


    Update* I still haven't received any kind of help. SOS?



    ------------------------------
    Savi Newman
    ------------------------------


  • 2.  RE: Reoccuring Tasks - Still No Solution

    Posted 20 days ago
    Edited by Evan Martinez 20 days ago
    Hi Savi,

    Kirk was a member of our team who was very technical and comfortable with diving into coding and gave this video as a reference for how code pages could be used to accomplish even more outside of standard Quickbase. That does mean it is outside of the realm of what our tech support team typically is able to help someone build.

    Looking back I saw in your previous messages you were having trouble reading his code? Was that the code from his code pages you were having trouble with or the formula field? I know that on that video he attached the two code page documents below as links you can access from dropbox.

    From there you would need to customize the code with your own DBIDs to get it to work for your specific application. While I can't go into the exhaustive list of things that need to be updated the most common things that typically need to be updated to get a code page rolling is references to things like the DBID (The ID of each table you are using), User Tokens, App Tokens, DBNames, etc. which in a code page that long can take a bit of work. There are partners who offer services that include developing solutions that might be able to help with coding like this.

    ------------------------------
    Evan Martinez
    ------------------------------



  • 3.  RE: Reoccuring Tasks - Still No Solution

    Posted 20 days ago

     

     

    Sent from Mail for Windows

     

     

    Savi, see this link below that is to signup for Office Hours which used to be Kirk's class

    But his son has now taken over. He is great at answering and helping out with all types of apps

    And any questions QuickBase related.

     

    Kirk was awesome! I miss our daily meetings online in Quickbase.

    But his son is great too and even has contact with Kirk for questions

     

    Webinar Registration - Zoom






  • 4.  RE: Reoccuring Tasks - Still No Solution

    Posted 10 days ago

    Savi,

    I think I have found everything you need by digging around Kirk's other apps.

    Step 1:   Copy this App Token into your Application 

    c5gchf9bhwx6umbd2ii5zdqtb5x8


    Step 2:  Create a Formula URL field in your table where you want to generate the recurring tasks - this is the button that will launch the Code Page you want.  Make sure you update the datefid from 8 to the correct Field ID# value of your [date] field in your table.

    URLRoot() &"db/9kaw8phg" & "?a=dbpage&dbid=" & Dbid() &"&rid=" & [Record ID#] & "&datefid=8" & "&pagename=recurring.html"


    Unfortunately, because we do not have direct access to the original Code Page(s), we are limited to generate up to 50 records.

    I found the "instructions" in this App on the exchange: ABC Employee Vacation and PTO Tracker which includes a "recurringhotwto.html" Page in it.  Unfortunately, the link on the instruction Page launches a Code Page to "create the button" in your app (step 2 above) - but because the original Code Page was created to use a javascript-pop-up window; the code page fails to run properly.  You can bypass this step by following my Step 1 and Step 2 though, although you will not have direct access to the original Source Pages to deploy in your own apps.

    Hopefully this gets you the results you want.
     






    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------