Forum Discussion

LanePemberton's avatar
LanePemberton
Qrew Cadet
7 years ago

Count characters in a string, find string location in a string, etc?

Is there still no way to count occurrences of a string within a string? Or to find the index of the first occurrence of a string within a string? The reason I ask is because this seems like a simple o...
App builders
Forms
Formulas and functions
DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago
You can always pass the string via URL parameter to a custom code page and do the string coding there via JavaScript or whatever. You can then display the value on the code page if you are just needing to know the number. There are additional options for putting that value back into a record field but it is more lengthy. 
DavidBrogdon's avatar
DavidBrogdon
Qrew Assistant Captain
7 years ago
You don't need the IOL technique for this. Just create a custom URL button that points to your custom code page. Pass the string value to the code page through the URL. Create the code page as an html document with a script tag that pulls a parameter value from the address bar and puts it into a variable. 


URL Button Example: 
https://[domain].quickbase.com/db/?a=[code page id]&[parmater=value]
https://dummycompany.quickbase.com/db/xxxxx?a=showpage&pageid=1&mystring=thisstring

HTML Document Example: 
<script>
 function getUrlParameters() {
    var params = {};
    var parts = window.location.href.replace(/[?&]+([^=&]+)=([^&]*)/gi, 
function(m,key,value) {
        params[key] = value;
    });
    return params;   }


function doSomeCode(){
var string=getUrlParameters() ["mystring"];  //do some code
} 
</script>

This may take some tinkering but it works good for me so far.