Way to launch to specific record from Home Page?

Question

I have an employees table. Each employee is designated their QB username, as well as a myriad of other info. I want people to be able to click a home page button that takes them to their record.

I can make a report that filters 'current user equals QB Username field', but that only takes them to a report with a single entry (theirs). This is good, but I would rather get them right to their record. I've thought of one way where I just embed the report itself on the homepage, which works but I am trying to figure out if there is a creative/sneaky way to do it and utilize the native buttons available on home pages.

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

np, just make a skinny report with just a button to [View Record] and put the report itself on the dashboard. Make sure that it's jammed up against other Home Page elements to keep the report skinny.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

michaeltamoush · Answer

Thanks Mark. That was the only way I could think of, but I was hoping to be able to add a button to an existing column of buttons.

I know that when you drilldown, it takes you to the drill down report *but* if you only have one record, it takes you to that record. I'm wondering if that if I can replicate that in a report URL formula some how?

------------------------------
Mike Tamoush
------------------------------

markshnier__you · Answer

I don't understand the question.&nbsp; Just make a URL formula button to display the record and that should be the only thing on the report.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

blakeharrison · Answer

Essentially, no. Here's how I've set it up:This particular use case required the PTO access, but you could just as easily set the button to open their Employee record.------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

michaeltamoush · Answer

Thanks Blake. This is what I did (and Mark suggested) and should suffice. In fact, your 'Request Time Off' reminds me that I intend to do that, so I can expand what I currently have to include that.Mark - what I was getting at was hoping I could utilize the button bar, so I could add 'My Employee Record' to an existing button bar, rather than using a new home page element. The only way I could see utilizing the button bar is if there was a way to set a custom url to the report, and somehow mimic the behavior of drilldown reports (drilldown reports link to a report if there are multiple records, but go directly to the record if there is only a single option).------------------------------Mike Tamoush------------------------------

Forum Discussion

Way to launch to specific record from Home Page?

Related Content

Custom Record Titles

Record Details

Using Grid Edit to Edit Multiple Records at Once

Many parent records on a single child record

Copy Records Step - Skipping All Records