ifv and OpenAsPopup conflict
I have a rich text button for the user to click to make a quick edit, which opens a popup window that leverages a code page to close automatically when saved (following the "CloseWindow.html" pattern illustrated here). I am attempting to also hide the normal qb UI in the popup window utilizing an ifv parameter, but when I do this the window no longer closes automatically. My base url is in a field [Edit User Alert]: URLRoot() & "db/" & Dbid() & "?a=er&rid=" & URLEncode([Record ID#]) & "&dfid=11" & "&z=" & Rurl() My rich text button adds the ifv (currently commented out) and NextURL parameters to the url and sets the class: var text url = "'" & [Edit User Alert] & //"&ifv=10" & "&NextURL=" & URLEncode(URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=5") & "'" ; ... var text class = "'OpenAsPopup' data-height=600 data-width=850 data-refresh=true "; ... The window closes correctly without the ifv parameter but when it's added the window no longer closes. Where am I going wrong?Invoice Routing
Tried a few searches but not quite sure how to describe my desire in just a few words. What I'd like to find out if it is possible would be to build an application for the tracking and routing of invoices. I know I can build tables and pipelines to functionally achieve this but the part I'm not sure how to do is to design the app so that when a user receives an email, indicating they have an invoice to review, to build in the ability for them to indicate somehow in that email their response. We are currently using a SharePoint Power Automate workflow but it seems to run into issues and I am the only one that knows how to investigate and fix those flows. The email provides basic information in the body, includes the original invoice as an attachment and then gives them the option to Approve or Reject from right in the email. For the majority of our invoice approvers they never actually visit our SP site, their interactions are solely through the approval emails they receive. Once they've selected their response the flow continues on to create an "approval page" and then merges that page with the original invoice. Post merge it is forwarded to a specific accountant for payment. I've been trying to migrate our solutions to various QuickBase apps as it has proven easier for non-technical persons to use and manage. Just wondering if a similar set up could be built in QB so that users wouldn't have to log into QB to respond to invoice approval requests. Thanks ------------------------------ Ember ------------------------------
URL Formula to print report that shows related child records
Hello, I need a URL formula that creates a print button, where the related project field in the child table is the [RECORD ID] of the parent record. Currently I have this: URLRoot() & "db/" & Dbid() &"?a=printr&rid=" & [Record ID#] & "&dfid=14" This prints the child records report displayed on the parent form, however I need to print a different report from the child table, not the report I'm displaying on the parent record's form. Thank you in advance :) #urlformula #Print #Button ------------------------------ Mackenzie Phillips ------------------------------
