SimonH
Qrew Cadet
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Creation of new QB Actions and Webhooks will be locked as of June 30, 2024
In addition to all the points being made about how Pipelines are not yet stable enough to be relied on, even if they were, i do not think they can replace webhooks. They are two separate tools. Webhooks are like database triggers, living at the data layer, watching for changes and immediately firing and making related data updates. Very useful for things like logging changes to certain fields, or triggering a change on a parent record when a child is updated. Pipelines are an external layer of application logic, more powerful but more complicated great for when you need multi-step actions or integrations with external apps. Certain things belong at the database layer and certain things belong in the application layer, removing access to one just because the other can technically do it is still a step backwards.82Views3likes0CommentsRe: Create Record, pause, then display record
Sounds like a good use of the this magic button https://www.youtube.com/watch?v=GCpXhYQM-w8 You would just need to make a slight modification to the code page to insert a pause ------------------------------ Simon H ------------------------------48Views0likes1CommentRe: Looking to hire someone good with code pages for very small, quick project
I would assume it is related to how the code page retrieves the lat and long. It is probably a browser API function not available in the mobile app. Here's a a simple code page you can create to test just the geolocation API Copied from here <!DOCTYPE html> <html> <body> <p>Click the button to get your coordinates.</p> <button onclick="getLocation()">Try It</button> <p id="demo"></p> <script> var x = document.getElementById("demo"); function getLocation() { if (navigator.geolocation) { navigator.geolocation.getCurrentPosition(showPosition, showError); } else { x.innerHTML = "Geolocation is not supported by this browser."; } } function showPosition(position) { x.innerHTML = "Latitude: " + position.coords.latitude + "<br>Longitude: " + position.coords.longitude; } function showError(error) { switch(error.code) { case error.PERMISSION_DENIED: x.innerHTML = "User denied the request for Geolocation." break; case error.POSITION_UNAVAILABLE: x.innerHTML = "Location information is unavailable." break; case error.TIMEOUT: x.innerHTML = "The request to get user location timed out." break; case error.UNKNOWN_ERROR: x.innerHTML = "An unknown error occurred." break; } } </script> </body> </html> ------------------------------ Simon H ------------------------------4Views0likes2CommentsRe: Code Page with User Input to Upload Multiple File Attachments to Quickbase
So instead of passing the Parent Record ID via URL parameter you want it set on the form itself? Try modifying the line of code in the code page as follows //change this line const parentRid = urlParams.get('rid'); //to this const parentRid = document.getElementById("recordid").value You can get a bit more creative if you want to page to work either with url param or manually ------------------------------ Simon H ------------------------------64Views0likes0CommentsRe: Counting records with the same Concatenated Values
When a payment is split in 2 do they each have some sort of ID number that is the same? If so you can use the summary type "Distinct Count" on that field to get your number of transactions. ------------------------------ Simon H ------------------------------56Views0likes7CommentsRe: Notification Limitation?
As Mark explained,notifications are triggered when records changed, and the parent table doesn't actually experience a change when child data being aggregated to it is changed. It is a common requirement in many apps and some workarounds are discussed here ------------------------------ Simon H ------------------------------29Views0likes0CommentsRe: Matching text and text list
I just went back and tested again and you are correct. When using "HAS" with only a single element it does more of a "contains" type of match, i had used it with multiple elements where that wasn't the case. This would seem like incorrect behavior and doesn't quite match what the documentation states for the use of HAS so i would suggest opening a support ticket. ------------------------------ Simon H ------------------------------147Views0likes0CommentsRe: Matching text and text list
Use a query formula with "has" // the first half of the query {3.EX." & [Record ID#] is there to limit the search to this record only //replace _fid with the field ID of the multi-select field and [Text Field] with the name of the text field var text qry = "{3.EX." & [Record ID#] &"} AND {_fid.has." & [Text Field] &"}"; //size should only be able to return 0 or 1, so if it is 1 return true and check the checkbox Size(GetRecords($qry)) = 1 ------------------------------ Simon H ------------------------------180Views0likes2CommentsRe: Condition Based on Embedded Report
You can create a summary field (numeric) on the parent record to total the value of the Embedded Request Flags or a summary checkbox to indicate if the embedded report contains a record with a flag that is not 0. Then you can use that summary field in any other formula fields to format accordingly ------------------------------ Simon H ------------------------------4Views0likes0Comments