Discussions

Expand all | Collapse all

Virtual Empower: App Library

  • 1.  Virtual Empower: App Library

    Posted 06-15-2020 14:43
    Just wanted to start a thread around the App Library that I presented on during Virtual Empower 2020.
    My hope is that this can be a place to share other use cases you've come up with, or simply ask questions if you've hit a snag.

    If you haven't seen it, you can find the demo app in the Exchange by searching App Library.

    ------------------------------
    Ryan Pflederer
    Implementation Consultant
    Quick Base
    ------------------------------


  • 2.  RE: Virtual Empower: App Library

    Posted 06-28-2020 22:00
    Ryan,
    I ran your app today. It saved a lot of time and makes documentation easier- which is always a good thing. 
    Thanks for putting this together
    Looking forward to the next version with queries

    ------------------------------
    Richard Chagnon
    Chicago IL
    ------------------------------



  • 3.  RE: Virtual Empower: App Library

    Posted 08-04-2020 09:31
    Hi guys,
    I downloaded the updated app and it pulls the info from my applications flawlessly.  However, the bulk updating does not work for me.  I created the pipeline as instructed, however, I noticed that there are no records being created in the schema changes table to trigger the pipeline to run.  Any help would be fantastic!  I have a lot of field comments to add to my app.

    ------------------------------
    Charlene Wilbur
    ------------------------------



  • 4.  RE: Virtual Empower: App Library

    Posted 09-16-2020 17:41
    I love this app and the concept and execution is great. Thanks for creating it!

    Would it be possible to also incorporate the Get Reports for Table API in addition to the existing ones? I'd love to be able to track all the existing reports in my apps.

    I'd also love to track notifications but I don't think there's an API for that.


  • 5.  RE: Virtual Empower: App Library

    Posted 09-25-2020 08:43
    @Tyler Brezler @Richard Chagnon I just published an updated version which includes Reports. One of the great things about the new RESTful Get Reports API is that it includes both Common and Personal reports, as well as the Last Used date and Used Count for all reports!

    @Charlene Wilbur​ It sounds like you may have missed getting the necessary webhooks setup to populate the Schema Changes table. When reviewing the additional setup instructions I believe it's the first step. There's also now a link on that page to a video of me walking through the additional setup.

    ------------------------------
    Ryan Pflederer
    Implementation Consultant
    Quick Base
    ------------------------------



  • 6.  RE: Virtual Empower: App Library

    Posted 01-05-2021 10:00
    I've just published an updated version to the exchange. Here's a few of the updates:
    • Capturing App Events
    • Capturing Table-to-Table Relationships
    • Added a Status to Applications and Tables to quickly identify possible areas for improvement based on Best Practices
    • Added a few reports to provide additional insights


    ------------------------------
    Ryan Pflederer
    Implementation Consultant
    Quick Base
    ------------------------------



  • 7.  RE: Virtual Empower: App Library

    Posted 01-05-2021 11:04
    I've just downloaded the app and started testing it out with a smaller app. When the script hits Get Reports for one of the tables, though, I'm getting a permissions error and the script crashes.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 8.  RE: Virtual Empower: App Library

    Posted 02-10-2021 19:57
    Hi Ryan, this app is great! It definitely helps with many aspects of configuring QB apps!

    I have a question about configuring apps that I add to the Library that are from different realms. I was able to set up the Pipelines to update changes in the to the apps, but making changes fires off all the Pipelines. the Correct Pipeline makes the changes, but the other Pipelines that are not related to the app I'm updating fire and return access errors. In your instructional video you mentioned that additional lines of logic need to be added to the YAML code. Could you help me out with this? I would like only the relevant Pipeline to trigger but due to the YAML code, I am not able to edit/update the Pipeline...

    ------------------------------
    Daniel Park
    ------------------------------



  • 9.  RE: Virtual Empower: App Library

    Posted 02-11-2021 09:09
    Hi Daniel!

    Within your existing Pipelines, you can update these to be realm specific by simply adding this AND{38.EX.'realmName'} to the Advanced Query in Step A. Just swap out realmName with the name of a specific realm. Once this is completed the Pipeline will only trigger on changes to that particular realm. Just make sure that you've got the right usertoken coupled with the realm.
    Hope this helps!

    ------------------------------
    Ryan Pflederer
    Implementation Consultant
    Quickbase
    ------------------------------



  • 10.  RE: Virtual Empower: App Library

    Posted 03-22-2021 16:18
    Hi Ryan

    Is there a way to get the Date of the recently modified record for tables? I think the definition of "Updated Date"  in your App is different from what I am looking for? 

    Thanks in Advance

    ------------------------------
    Karthik Sekhar
    ------------------------------



  • 11.  RE: Virtual Empower: App Library

    Posted 03-23-2021 12:09

    Hey @Karthik Sekhar

    Are you looking for the date that the table record was updated within the Tables table? (hopefully that's not too confusing, haha) If so, the default Date Modified should do the trick.

    If you're looking for the date of the most recent record update within the documented table (ex: Clients table, date of the most recently updated client record), this data isn't currently available in the RESTful APIs. However I do see that it's available in the XML APIs if you wanted to venture down that road.

    Thanks!
    Ryan



    ------------------------------
    Ryan Pflederer
    Implementation Consultant
    Quick Base
    ------------------------------



  • 12.  RE: Virtual Empower: App Library

    Posted 05-18-2021 09:43
    Thanks Ryan for your response. Is there any way we can automate the button click to refresh schema? Currently, we have to manually click the button and enter the User Token to run the refresh.

    ------------------------------
    Karthik Sekhar
    ------------------------------



  • 13.  RE: Virtual Empower: App Library

    Posted yesterday
    I am looking for the same functionality as @Karthik Sekhar requested.
    Would love to be able to track schema updates as they happen (or at the very least, daily) without having to manually refresh.
    Thank you!​

    ------------------------------
    SCS DEVELOPMENT
    ------------------------------



  • 14.  RE: Virtual Empower: App Library

    Posted yesterday
    To setup an automatic refresh, you would need to use something like Pipelines, Workato, or an externally hosted script that would update the app using stored credentials. I am assuming you could use the code pages that Ryan has setup in the app as a starting point, though.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------



  • 15.  RE: Virtual Empower: App Library

     
    Posted 21 hours ago
    Thank you @Blake Harrison!
    @Ryan Pflederer, wondering if you have any tips on this (updating schema automatically). Also wondering if there is an error log functionality to record "event" errors.
    Overall, this app is great! I'm excited to​​ maximize all its capabilities to help us better document and clean up our app.​​​

    ------------------------------
    E. P.
    ------------------------------



  • 16.  RE: Virtual Empower: App Library

    Posted 2 hours ago

    @E. P in order to be able to run this on a schedule you'd need to create a Pipeline (or other similar server side script) to do all of the processing. I've started working on a Pipeline for this a couple of times since it's been highly requested, however simply don't have the time to complete it. With that said, if someone does create a PL for it and is willingly to share the YAML I'd be happy to add it into the app.​​

    In terms of event errors, this app is populated with data extracted via APIs. Currently there aren't any APIs which expose these details, however I do try to keep the app up-to-date with any new APIs that are released.



    ------------------------------
    Ryan Pflederer
    Implementation Consultant
    Quick Base
    ------------------------------