Custom Home Page Widgets

Question

Has anyone had success with creating their own custom widgets for the standard Quickbase Home Page?

I would like to add buttons on the home page that:

Serves as a link to a specific report
Shows the total number of records in said report

Thank you,

chuckgrigsby · Answer

In the settings of a homepage you can create a button bar. Those buttons can go to a link, report, or page. If you wanted to add a count or run any query on the home page and add that to the button you may need custom code.&nbsp;

williamselvage · Answer

Thank you Chuck,I think a custom code option is the way to go. I have successfully embedded an HTML page on the Quickbase home page that includes the buttons I want. Where I am having difficulties is with using the response from API_GetNumRecords.After that I then have to figure out how to apply a filter to the API call.Any experience?

chuckgrigsby · Answer

Ok I think you just want to use API_DoQuery instead of API_GetNumRecords. That will just return the total records of a table. An example is below though it's not tested. For Query or (q) in the code. You would place something like this given 25 is the field ID for a field called status and one of the values is Openvar q = "{25.EX.'Open'}"&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $.get(dbidTracts, {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; act: "API_DoQuery",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; query: q,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clist: clist&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }, function(xml) { $("#openBtn").html("Open Tickets (" +xml.length + ")");})You're welcome to reach out directly if you have any questions with custom coding issues. Chuck@Chuck.Support or if this solution resolves your issue and you're feeling gratuitous , chuck.support/donateTake care and good luck!&nbsp;_

williamselvage · Answer

Hello Chuck,I have tried experimenting with this but am not sure I know where to start. Were is the table referenced in this code?

chuckgrigsby · Answer

In this example its called dbidTracts which is just a variable so you can just go to your table, copy the ID from the URL and use that instead or store it in a variable like I did.I don't know your level of coding so I'm not sure what all you would need help with. For the query code you would also wrap that in &lt;script&gt;&lt;/script&gt; tags if you enter it in your HTML that's loading the buttons.

Forum Discussion

Custom Home Page Widgets

Related Content

Custom Record Titles

custom email

Formula Query with custom key

Home Page

Report widget not showing available reports