Jump to content


Caspio Ninja
  • Content count

  • Joined

  • Last visited

  1. Always appreciate your help! Getting closer but not quite. That formula is giving me a miscount for months and days still. It renders these dates this way: GetUTCdate date Expiration Date: 2/16/18 5/6/2020 2 years 27 months 24 days (Should be 2 yrs, 2 months, 20 days)
  2. Um, we have a winner! Caspio needs to update their documentation, sheesh.
  3. Hi Vitalik. Thanks for the reply! Unfortunately, that does not work either. https://www.ucemcme.com/faculty2/ Odd why all of a sudden it has stopped:
  4. You are amazing, thank you. I had it close. But it turns out this isnt quite what I intended after I saw it live. This does in fact give the Year, Months, Days date difference between today and the expiration date in the independent forms of: 1 year until expiration, OR 12 months until expiration, OR 342 days until expiration. After looking at it I realized what Im hoping is for is closer to the Excel version that refreshes and does a combined summary of years, months, days until expiration like examples: Item A expires in: 1 yr, 2 mos and 14 days Item B expires in: 0 yr, 8 mos, 6 days. Different animal I suspect.
  5. Was usuing the how to Hide Multiple logins method successfully for some time https://howto.caspio.com/tech-tips-and-articles/common-customizations/hiding-multiple-login-forms/ All of a sudden it doesnt work and I cant find the issue: https://www.ucemcme.com/faculty/ Authentication has i the header <div name="cb-auth-box"> and </div> in the footer as it always has. Each report embed on this page is embedded via CB on Squarespace page and under each of the embeded script code for the DP I have the correct hide script: <script> if(document.getElementsByName("cb-auth-box")) { var v_box = document.getElementsByName("cb-auth-box").length ; for (i=1; i < v_box; i++) { document.getElementsByName("cb-auth-box")[i].style.display = "none" ; } } </script> Obviously something has changed, but I cant find it. Reasonable fee for the answer ;^)
  6. Not working. Does this first part: <script> var v_dpTotalCount = 3; var v_dpCounter = 0; </script> ......Also get placed right after each piece of deployed CG datapge code? or just occur once somewhere else in document? Or does that first piece go in the Authentication HEader?
  7. In excel if I wanted to know the number of Year and months and days until something I would use: =DATEDIF(B2,TODAY(),"y") & " Years, " & DATEDIF(B2,TODAY(),"ym") & " Months, " & DATEDIF(B2,TODAY(),"md") & " Days" In CB calculated fields I can get one of the intervals - year OR month OR day but not all three using: Datediff(day,GetUTCDate(),[@field:ExpirationDate]) Can I convert that excel datediff to a CB friendly alrternative?
  8. Upcoming Update

    Never had a company not do it overnight. Odd.
  9. This has been asked before but the answer didnt work. I have a Lookup table being called in a Datapage. I want one of the table choices to be the default. It work fine using Custon Lookup table and not using the table. Previous posts said add this to footer: <script type="text/javascript"> function f_default(){ document.getElementById("FieldName").value = "TheDefualtVaule"; } window.onload = f_default; </script> I have done this, referencing the correct field name and value but it doesn't work. Thoughts? Thanks as always.
  10. Followed the instructions. https://howto.caspio.com/tech-tips-and-articles/common-customizations/hiding-multiple-login-forms/ It does work, but when the page first loads you see a brief flash of ALL the login screens then they disappear. Anything change with this code/suggestion for modern CSS or HTML to cause this behavior? See attached screenshot video. Watch bottom of screen - they flash by. 2018-01-24_15-43-48.mp4
  11. Thanks Franchiser. Good tips! Will try them out. A lot of people have pop up blockers on so that may be an issue. How to all the Caspio example videos get it to appear within the page location where logout was chosen?
  12. Tables seem to show in oldest to newest sort order. Can that be switched to newest first in the table? Could do a data report page for that but would be easier to just do so in table view.
  13. My password reset link works fine but it opens in its own page: https://XXXXXXXXXXXX.caspio.com/dp.asp?AppKey=3f2d4000cc693c7fe3d0473c836f&cbpr......... And this page is outside the site and all its design. Can I have the reset link open as an embedded code within a section on my site? The login and forgot password shows up nicely embeded on my site. But Forgot Password target goes to its own URL upper right. Would love password reset form to show up in same spot as login.
  14. Counting Number of Values in Datapage

    No luck. As usual, Caspio hates the syntax: count(case when [@field:CME_Category]<>0 then 1 else NULL end) and count(case when CME_Category <>0 then 1 else NULL end)