SimonH
Qrew Cadet
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: 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 ------------------------------74Views0likes1CommentRe: 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 ------------------------------13Views0likes2CommentsRe: 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 ------------------------------80Views0likes0CommentsRe: 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 ------------------------------67Views0likes7CommentsRe: 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 ------------------------------51Views0likes0CommentsRe: 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 ------------------------------222Views0likes0CommentsRe: 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 ------------------------------259Views0likes2CommentsRe: 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 ------------------------------8Views0likes0CommentsRe: CODE DUMP: Email Help Button for Top Right Corner (that grabs page url)
Amazing! thanks for sharing In addition to the update Tim mentioned, (changing from "&" to "?" before the subject) I also found that url encoding the the origin URL was helpful to make sure that the email gets generated with the full URL including the full query string which is helpful to landing you on the exact record a user was on New code page now looks like <html> <head> <script> let oldUrl = encodeURIComponent(document.referrer); var oldTable = oldUrl.substring(oldUrl.lastIndexOf('/') + 1); var newBody = oldTable + 'testin'; function handleonload() { window.open("mailto:[email protected]?subject=New%20Quick%20Base%20Ticket%20Request%3A%20App%20Name&body=---------------------------------------------------------------------------------------------%0D%0APlease describe your problem below %26 attach screenshots to this email.%0D%0A---------------------------------------------------------------------------------------------%0D%0ADESCRIPTION OF THE PROBLEM%3A%20%0D%0A%0D%0A%0D%0A%0D%0A%0D%0A%0D%0A%0D%0A%0D%0A---------------------------------------------------------------------------------------------%0D%0APlease make sure that the Ticket Fields below are filled out correctly%3A%0D%0A---------------------------------------------------------------------------------------------%0D%0AQUICK BASE APP%3A%20App%20Name%0D%0ALINK TO PROBLEM%3A%20" + oldUrl + "%0D%0A", "_blank"); } function ticket() { history.back(); handleonload(); } </script> </head> <body onload="ticket()"> </body> </html> ------------------------------ Simon H ------------------------------40Views0likes2Comments