Conversion from textlist to text?
I'm trying to write a formula for two fields-- Field 1 has Option 1 and Option 2. I'm trying to configure it so that if the user selects Option 2, then another field will pop up for them to answer. Right now, my formula works because I have Field 1 set as a Multiple Choice field type. However, I need Field 1 to be a Multi-Select field type, and when I try to change it to a Multi-Select, then my formula does not work. I get this error: Invalid formula provided in form rules: [{"errorMessage":"Formula Error -- Type MismatchThe expression [_fid_18] on the left hand side of the operator \"=\" is of type textlist while the expression \"Vendor\" on the right hand side is of type text.","ruleIndex":11}] What's the best way to implement this?
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?
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>"Button that adds record #2 from record #1 in same table ... but returning to record #1 after save.
After save, I want to stay on Record # 2 , not return to Record #1 which is what's happening now with code below. Here is my code (I am pre-populating some values in Record #2 from Record #1). The button resides and is clicked in Record # 1. URLRoot() & "db/" & [_Table Name] & "?a=API_GenAddRecordForm&_fid_265=" & URLEncode ([Costing Assigned To]) & "&_fid_268="&URLEncode([Pricing Assigned To]) Note: there is no redirect in my code.
Trying to format with 2 decimal places
I have a Formula Rich Text field to display a grand total. If the cents end in 0 like .10 it drops the final 0. Here is my formula "<p style=font-size:14pt;color:red;><b>"& "$" & ToFormattedText(Round([Total with Tax & Fee],0.01),"comma_dot",3)& "</b></p>" What do I need to add to show that final 0?
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>
