Create Child Record, Save and then Edit button
When I press this URL button it just hangs. Any ideas? I am getting this code from Magic Buttons The button: URLRoot()&"db/"&AppID()&"?a=dbpage&pagename=createchildsaveandedit.html&targetdbid="&[_DBID_Estimator]& "&referencefield=11"& "&rid="&[Record ID#]& "&apptoken=xxx" The code page: <!DOCTYPE HTML> <html> <body> <script> const urlParams = new URLSearchParams(window.location.search); const rid = urlParams.get('rid'); const apptoken = urlParams.get('apptoken'); const targetdbid = urlParams.get('targetdbid'); const referencefield = urlParams.get('referencefield'); const xhttp = new XMLHttpRequest(); xhttp.onreadystatechange = function() { if(this.readyState == 4 && this.status == 200) { const response = this.responseXML; const redirectUrl = "https://" + window.location.hostname + "/db/" + targetdbid + "?a=er&rid=" + response.getElementsByTagName("rid")[0].textContent + "&rl=bbv"; location.href = redirectUrl; } }; xhttp.open("GET", "https://" + window.location.hostname + "/db/" + targetdbid + "?a=API_AddRecord&_fid_" + referencefield + "=" + rid + "&apptoken=" + apptoken, true); xhttp.send(); </script> </body> </html>
Working with %%rid%% and checking a box
I know this has been probably answered before, but I just can't get this formula to work. I want it to save a record (even a new record or already created one) and check a box. I am going to use that box in a pipeline. Here is my formula. Can anyone see what I am doing wrong? It does not check the box (fid is 599). var text RID =If(IsNull([P-Referral Record ID#]),"%%rid%%", ToText([P-Referral Record ID#])); var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $RID & "&_fid_599=1"; var text LABEL = "Send Consent to JotForm"; "<a class='Vibrant Success SaveBeforeNavigating' data-replaceRid=true href='" & $URL &"'>" & $LABEL & "</a>"
Formula to populate a field based on another field that contains a specific text string?
I'd like to have a field on a form automatically populate based on if a specific text string exists inside of another field. Let say field 2 will be populate with the text "red squadron" if field 1 contains the text "red". Can I do this with a formula using contains or would I need to create a table where all possible combinations that contain the text "red" would align to being in red squadron?
Formula using Contain
Hello, I'm trying to count how many records I have that have for Field "Account Name" that contains the work "Wire" and the Field Name "Funding Indicator Name" that contains ASC. I'm not getting an error for the way I did the formula but its not counting when the two fields on a record have the "contains" word. If((Contains([Account Name],"Wire" & Contains([Funding Indicator Name],"ASC"))),1,0) Appreciate any suggestions. Thank you
