Caspio Guru
  • Content count

  • Joined

  • Last visited

  • Days Won


ezIQchad last won the day on February 2

ezIQchad had the most liked content!


About ezIQchad

  • Rank
    Advanced Member
  • Birthday

Profile Information

  • Gender
    Not Telling
  • Location
    USA - PNW

Recent Profile Visitors

878 profile views
  1. Thanks! Those are good options. I ended up using a workaround using ABSOLUTE. Substring([@field:ScratchPad], Charindex(': ',[@field:ScratchPad], Charindex('Passport Date of Issue: ',[@field:ScratchPad]) ) + 2, Abs( Charindex('===',[@field:ScratchPad], Charindex(': ',[@field:ScratchPad], Charindex('Passport Date of Issue: ',[@field:ScratchPad]) ) ) - Charindex(': ',[@field:ScratchPad], Charindex('Passport Date of Issue: ',[@field:ScratchPad]) ) - 2 ) )
  2. Hi, I'm stumped. This code works Substring([@field:ScratchPad],Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad])) + 2,Charindex(' ======',[@field:ScratchPad],Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad]))) - Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad])) + 2) This code breaks with only a minor adjustment: changing + to - at the very end Substring([@field:ScratchPad],Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad])) + 2,Charindex(' ======',[@field:ScratchPad],Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad]))) - Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad])) - 2) This code is a substring in example two that works until I add it to the code above Charindex(' ======',[@field:ScratchPad],Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad]))) - Charindex(': ',[@field:ScratchPad],Charindex('Departure Airport: ',[@field:ScratchPad])) - 2 Any help will be appreciated
  3. Hi,

    The purpose of a forum is to share the knowledge.

    If you have a question. Ask it on the forum. If you must, ask me to look at it and I will, but it must already be a question on the forum.

    Let's make sure we share the knowledge.


    1. TWIRED


      That makes sense. 


      This question was posted but didnt get a reply so kinda got impatient

      Will do.


  4. Hi @abelphathost, Thanks for the message, but let's not ask questions privately.... the point of a forum is for people to find that somebody else has already asked the same question. A couple things to note 1 - I've had trouble using JS and Caspio's checkboxes. Dropdowns are easier to work with. 2 - I never use 'onsubmit'. Rather i create a fake submit button that runs that code I need before the submit happens then wrap the function with: document.getElementById("Submit").click() ** If you must have something easier than a dropdown... This takes some work, but will allow you to do it. HTML block <style> #YOUR_FIELD_ID {display: none} .fake-radio { width: 120px; height: 50px; padding: 16px; margin: 16px 0 0 32px; font-size: 18px; float: left; } </style> <div class="fake-radio" onclick="document.getElementsByName('YOUR_FIELD_ID')[0].value = 'Yes';>Yes</div> <div class="fake-radio" onclick="document.getElementsByName('InsertRecordFieldName')[0].value = 'No';>No</div> YOUR_FIELD_ID 1. right click the field you want to populate > inspect 2. Look for <xx class="sample" id="XYZ_98sd7d" name="InsertRecordYOURFIELDNAME">Hi World</xx> 3. your answer is InsertRecordYOURFIELDNAME Try these suggestions and I'm sure you'll find your solution
  5. Hi @TWIRED, Thanks for your message. Let's do it out here so everybody can see the Q&A. Your path looks good. Two things to check. If it was working, then stopped... check to make sure the DataPage you're sharing these images from DOES NOT require authentication. (something it may not have required when it worked) I also notice your Account Subdomain [Caspio account settings > c2eku***.caspio.com] in use as the domain. I use my Caspio Site [Caspio account settings > b5.caspio.com] as the bdomain for this link. Hope this helps
  6. Email clients don't like style tags, so we must use inline styles. <span style="display: none[@param1]">[@param1]</span> If Param1 = null, then style="display: none" will render normally, thus hiding the span. If it's not null then it will be something that doesn't compute... like style="display: noneABCD", which won't hide the span
  7. This caused problems for me.... found a workaround #caspioform div[style="position: relative"] { height: 0px; }
  8. Try making the first page a user begins this process on a submission form that will alert the user when they're adding the duplicate record BEFORE any auto-submitting. I can't tell for sure, but it seems like you're passing params from one DP to the next in order to add multiple records. Then along the way, a non-unique error pops up and a loop ensues. Ensure this error prevents the user from proceeding by moving the unique record to the beginning. You can also add code to the Localization Error message.
  9. Cascading fields. They're easy to figure out, as long as you know that's what you need.
  10. HTML Block *You must use a div - not an a tag. Caspio's HTML editor doesn't allow you to have divs inside an a tag. <div onclick="location.assign('yourLink.html');"> <div class="field-1">[@field:DataSourceField1]</div> <div class="field-2">[@field:DataSourceField2]</div> <div class="field-3">[@field:DataSourceField3]</div> </div>
  11. Create HTML Blocks for each error message you'd like to display. Then use the "Rules" tab to show/hide these blocks.
  12. You're using the same identifier for different calcs. var convertField = document.getElementsByClassName('cbFormData')[0]; This is why the value from the second calc is showing up in the first element.... the first code runs perfectly, then before you can see the result the of that calc, the second code fills the data into the first element. Might be as simple as changing to var convertField = document.getElementsByClassName('cbFormData')[1]; Try to use ID rather than CLASS[*], you have much better control. If your Virtual Params are Cascading, that explains why you can't use ID.
  13. I can't tell when you want the data copied based on your question, so I'll try to help, assuming you want the description copied after the user types a description. <script> var caspioDescriptionElement = document.getElementById('EditRecordDescription'); var formDescriptionElement = document.getElementById("cbParamVirtual1"); formDescriptionElement.onchange = function() { caspioDescriptionElement.value = formDescriptionElement.value; } </script> While writing this, I noticed that you're missing a "document" before "getElementsByName("cbParamVirtual1")[0].value; ". That might fix your code.
  14. No code needed. Use "Rules" within the DataPage editor to show or hide specific elements based on values in your data. p.s. Java and JavaScript are not the same thing, and Java is not likely to help you much in Caspio.
  15. You're using a JS var outside of a JS function. - <a href=("dynLink").... Rather, you need assign the href from within the JS function. You can also simplify your code by removing the else and simply starting with the link that should be there when the "if" fails <script> window.onload = testFormRes; function testFormRes() { var dynLink; var linkEle = document.getElementById('dynLinkEle'); if ("[@authfield:Restricted^]"=="yes"){ dynLink="https://c0ect240.caspio.com/dp.asp?AppKey=eeda30004146e1be17fe4f64a319"; linkEle.href = dynLink; } } </script> <a id="dynLinkEle" href="https://c0ect240.caspio.com/dp.asp?AppKey=eeda3000a155f226d27146b0ae20" class="btnPatrolForm">ActivityForm</a>