ContributionsMost RecentMost LikesSolutionsRe: Formula redirect that passes a dynamic value to a report?Awesome, Mark. Adding this to my small library of tricks. Have a good holiday week next week. ------------------------------ Christopher Greene ------------------------------ Formula redirect that passes a dynamic value to a report?Is it possible to pass along a value in a redirect that can be used as a filter in the report I redirect to? For example, say I click a formula rich text button, and in it is a line like this: var text url = URLRoot() & "db/" & [_DBID_GROUP_IDS] & "?a=q&qid=7&_fid_7=" & $rid; Where _fid_7 is the [related parent id], and make that report filter on [related parent id] = _fid_7? ------------------------------ Christopher Greene ------------------------------ Re: Save and Keep Working behavior in a Custom buttonYes, and I do have that set in the table properties. In fact I think tables default to that. CGreene ------------------------------ Christopher Greene ------------------------------ Re: Save and Keep Working behavior in a Custom button.... But, if I click the table button or any other button, since those two helper fields are constantly changing, then I'll have to respond to the popup that warns of unsaved fields, specifically the two helper fields. The Save & Close button takes me out, but that is an option that I would hide from the end user with &ifv=1 in the query string. Anyway, I'm further along with the solution than I was yesterday. Thanks again, CGreene ------------------------------ Christopher Greene ------------------------------ Re: Save and Keep Working behavior in a Custom buttonMark, Your provided solution works great when only the embedded child records themselves are edited when the main parent record is not necessarily changed. Thank you for the helpful tip. Much appreciated. CGreene ------------------------------ Christopher Greene ------------------------------ Re: Save and Keep Working behavior in a Custom buttonNot the only change, but one of the changes - either, or. If I were to make an edit to the main parent record only, then the custom button works. If I make an edit to the embedded child records, regardless of whether I make an edit to the parent, then click my custom button, QB behaves as if I'm navigating away before the save with the message, "Leave site? changes you made may not be saved". ------------------------------ Christopher Greene ------------------------------ Save and Keep Working behavior in a Custom buttonThe native behavior of Save & Keep Working will save Both the edit made to embedded child records and whatever changes made in the form to the parent record. The code below Does Not do that. I found the below at: Alternatives to common JavaScript Insertion techniques var text rid = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%"); var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $rid; "<a class=\"Vibrant Primary SaveBeforeNavigating\"data-replaceRid=\"true\"href=\"" & $url & "\">Save & Keep Working - Rich Text</a>" My endeavor is to have a Custom Button behave the same way as the Native "Save & Keep Working" button. Save both parent and child record edits, redisplay in edit mode. Why a custom button? you may ask. Because the other options "Save & Close" and "Save & Next" I do not want to be available to the end user. Any assistance is appreciated. Thank you, CGreene ------------------------------ Christopher Greene ------------------------------ Re: Pipelines - Quick Base table content to SharePoint fileThere is an instructional video on YouTube's Quick Base channel named, "Export a CSV from Quick Base to Box- Nicholas Kynoch". Even though in this video the export goes to Box, the initial setup of the pipeline using the Bucket channel and QuickBase channel brings you to the point where you're set to export into 'some' platform. Recommended. ------------------------------ Christopher Greene ------------------------------ Pipelines - Quick Base table content to SharePoint fileI'm building a pipeline where I pull a csv file from AWS S3 ( got access to this channel ) and load into a Quick Base table as an intermediate step to pushing that table's content into a csv file in SharePoint. I begin by clearing the QB table, then query the AWS bucket for the object I want, then use import with CSV into Quick Base. The challenge is pushing that table's content into a csv or xlsx file to publish into SharePoint. Any guidance is appreciated. Chris ------------------------------ Chris ------------------------------ Pipelines and bulk upsert of OneDrive Resident .XLSX documentHi, Is it possible, like with .csv documents, to bulk upsert .xlsx documents from a OneDrive account into a QB table? the .csv bulk upsert is done with great ease, but how about with .xlsx ? Thanks, ------------------------------ CG ------------------------------