BradLemke
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Dashboard Maps are actually awesome
That's exactly what I did. I took an old map report that I made years ago and just slapped it up on a dashboard and it displayed what you see in the screenshot. Pretty darn seamless. Only downside for me specifically is when multiple records are bunched together in a spot and you have to go to a drilldown report: Currently can't specify a particular report to drill-down to, and it also kinda kills the ability to use rich-text buttons to rapid-fire some actions off. ------------------------------ Brad Lemke ------------------------------Re: Pipeline to create a new Project in Quickbooks
In Pipelines, the JSON Handler channel is your key to leveraging any other parties' API that isn't part of a channels' standard workflows. It looks like the project/job creation isn't a standard workflow in the Quickbooks Online pipelines channel, but their QB API Guide does show that it's possible to create one via an API. Admittedly, I haven't worked with Quickbooks Online (only enterprise desktop on our servers) so my advice on exact actions/code is pretty limited, but I have leveraged the JSON Handler to do some non-standard actions thru Dropbox and it produced pretty darn awesome results. ------------------------------ Brad Lemke ------------------------------Re: Show a form in a form
I tested it out as well and it functions incredibly well as a direct replacement to my workaround solution that I built a while back. The only issue I run into is if I navigate in any way (such as using a save button), I get that infamous error code: Sorry, you can't use redirects to Quickbase URLs I wonder if that's a bug? ------------------------------ Brad Lemke ------------------------------Re: Show a form in a form
I did manage to get a 'child record form embedded into parent form' solution working a few years ago for my apps, though nearly every aspect of that solution has been deprecated. This solution involved using the Iframe html tag in a formula rich-text field, which is unfortunately no longer allowed to be used. ------------------------------ Brad Lemke ------------------------------Re: A Pop-up message appears when clicking the formula-URL button in Edit mode
I'm betting the extra ampersand just before the href is breaking the functionality of your button: If( (not IsNull([Project record ID#])and [Sign Off Status]="1. Draft"), "<a class='Vibrant Success SaveBeforeNavigating' & href='" & [Endorsement Bypass] & "' target='_blank'>Endorsement Bypass</a>") ------------------------------ Brad Lemke ------------------------------Re: New functionaility %%rid%%
Let's see if this works instead (cutting out the genaddrecordform in favor of a=nwr): var text RID = "%%rid%%"; var text AddContract = URLRoot() & "db/" & "brgdpr9fn?a=nwr" & "&_fid_12=" & URLEncode ([Related Vendor]) & "&_fid_57="; var text EditUserFocus = URLRoot() & "db/" & "bp8yr9i5s?a=API_EditRecord" & "&key=" & UserToEmail(User()) & "&apptoken=xxxxxxxxxxxxxxxxxxxxxxxxx" & "&_fid_220=" & [Service Order - SO #] & "&_fid_224=" & [Related Service Order]; "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #4b7097; border-radius: 5px; color: #ffffff; display: inline-block; padding: 0px 0px 0px 0px; width:100px; text-align: center; text-shadow: none; border: 2px solid #030404; font-size: 12px \"href='" & $EditUserFocus & "&rdr=" & URLEncode($AddContract) & $RID & "'>Add Subcontract</a>" ------------------------------ Brad Lemke ------------------------------
