JakeRattner1
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Code Page: Embedded Child Table Recieving Error
Hi QB Community, I'm looking to bring a table of child records into a form using a code page. I need to add arguements and options which don't seem possible going off the default report (ex. ~bids~ ) My Query looks something like this (I've replaced table ID): ~=qdb.GetURL("TABLE ID", "API_GenResultsTable^query={'70'.EX.'"+ field["Record ID#"]+"'}")~ Or this query ~=qdb.GetURL("TABLE ID", "API_GenResultsTable^query={'70'.EX.'"+ field["Record ID#"]+"'}^clist=1.2.3.4.^options=nvw.ned.phd.nfg.sortorder-A^slist=25");~ The result is this message: Invalid Table This operation is only supported on individual tables and not on the application itself. Please check the URL. The other merge fields in the form work correctly, so it seems to have to do with the Child table although it also sounds like the problem is the URL. Does anyone have an idea of what might be going on here? Thanks! ------------------------------ Jake Rattner ------------------------------24Views0likes2CommentsRe: Pipelines: selecting data from tables and export them as excel file using pipeline automation
Does anyone have a recommendation for the best way to export as an excel file so that it can export with formatting? ------------------------------ Jake Rattner ------------------------------164Views0likes0CommentsRe: Caching issues with new report style?
I'm having the same problem in all browser types (have tested chrome, brave, firefox, safari) and have submitted a care case a few weeks ago. It is a major issue because we can no longer be sure the report is showing the correct information. It appears that, in creating the report, something goes in the browser cache that messes up the report. You can clear your cache to fix the issue, I believe, but that's not an ideal solution (clearing the cache after every report you build). ------------------------------ Jake Rattner ------------------------------18Views0likes0CommentsUse Pipeline to Remove an attachment from a field
Does anyone know how to remove/delete an attachment from a field using a pipeline? I'm trying to use "update record" and am not seeing any option to remove an attachment. It looks like the attachment field isn't an update option in the "update record" UI. What I'm trying to do is have the user upload an attachment. The attachment gets added as a child record and then removed from the field where it was attached on the parent. Thanks, Jake ------------------------------ Jake Rattner ------------------------------28Views0likes2CommentsRe: Formula Queries - Finding Min/Max of Value Using Foreign Key in Other Table
Hi Mark, Thanks for replying so fast. Agreed. A ready-made function doesn't exist and hopfully it will be soon. I'm hoping there will be a ton of new functions once Quickbase is ready. In the meantime, I'm wondering if there is a creative solution for getting the min/max out of a text list. For example, I can use get the min/max from the text list by using the following formula: Max( ToNumber(Part([Text],1,";")), ToNumber(Part([Text],2,";")), ToNumber(Part([Text],3,";")), ToNumber(Part([Text],4,";")), ToNumber(Part([Text],5,";")), ToNumber(Part([Text],6,";")), ToNumber(Part([Text],7,";")) ) But the above seems like a poor approach because I may have to add "ToNumber(Part([Text],1000,";")" some day soon. Updating formulas like that is a nightmare. Thanks! Jake ------------------------------ Jake Rattner ------------------------------23Views1like4CommentsFormula Queries - Finding Min/Max of Value Using Foreign Key in Other Table
Hi QB Community, I'm excited about the new Formula Query and am trying to use it to find the minimum and max fields in a seperate table. I start with this: GetFieldValues(GetRecords("{249.EX.'"& [StateID] &"'}", "DBID"), 212) In the query, I'm returning a text list that shows all the 'prices' (fid212), where the 'stateID' (fid249) matches the 'StateID' on the record. This part works. Now I'm trying to figure out for to derive the min and/or max from the resulting text list. I've used SearchAndReplace to modify the text list in a few different ways to that I can pass it into the Max function, but no luck yet. Do you konw how to do this?? Thanks! ------------------------------ Jake ------------------------------327Views0likes11CommentsRe: Pipelines Advanced Query
Maybe try something like {'9'.EX.'Record Owner'} I have a pipeline using a query with similar syntax, but its looking at a different table. Hope this helps. I'm a little ignorant about queries so its a shot in te dark ------------------------------ Jake R ------------------------------191Views0likes5CommentsRe: Upcoming Changes to JavaScript in Quickbase
I would like to second Avinash Sikenpore's comment stating the role out is not properly incorporating user feedback or isn't customer centric. I get that quickbase thinks this is an overall improvement which must take place, but you have not properly rolled out alternatives yet. A customer centric approach would pause the cut off of JS until alternatives are properly documented and in place. Even if the number of developers using JS is seemingly small, the number of users impacted is vast. Thanks for reading.10Views0likes0CommentsRe: URL Button to change forms, check box and redirect back to original record.
Hi Mark, Thanks for the response. Apologies for the sloppy wording. It's actually neccessary that the box be checked prior to moving to the new form. Would that order of operations make this possible within QB? ------------------------------ Jake R ------------------------------120Views0likes0Comments