Jump to content

roattw

Caspio Guru
 View Profile  See their activity

  • Content count

    121

  • Joined

  • Last visited

  • Days Won

    1

roattw last won the day on April 6

roattw had the most liked content!

Community Reputation

1 Neutral

See reputation activity

About roattw

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. roattw started following Really odd form radio and checkbox behavior, Filter Results on a Single Web Page : Results page needs sort trule, FileStor only way to get uploaded file URLs exported to Excel? $100/month and and 4 others
  2. roattw
    I followed the instruction for Filter Results on a Single Web Page. It works but but I need the results page to only show results meeting one of the search form criteria. Search form has Name (drop down of names from table) and Type of Submission (drop down with two options - CME or Compliance) Search returns all the entries for chosen name, but I also need it to NOT show report fields that are empty that dont meet the Type of Submission Criteria, in this case Compliance. So below would like to see the 3 CME columns hidden. Alternately, if type was CME, to then hide the Compliance columns. Using the Filter Results on a Single Web Page instructions there is no option to apply a rule to the results page.
  3. roattw
    Thanks for the response. If I am reading that correctly it is a great tool but might not work for this task. We can get the files to download currently, just have to click each one one at a time. We are just looking for a checkbox option for each file that can be downloaded, preferrably with a a shift-select to select multiple or even a select all option.
  4. roattw
    Frustrating. Cant make it work ;^) Anyone need some freelance work?
  5. roattw
    Data not getting passed correctly. Following the instructions I have: New Text Field (64000) to receive the email body: Does the Script go in Header? In header I have your script ending in: document.getElementById("cbParamVirtual5").value = email; } </script> New virtual and email field, hidden, receiving the Virtual5 script parameter: Im getting blank notification emails.
  6. roattw

    Open tabular datapage 'as download file' directly

    roattw replied to DesiLogi's question in DataPages

    $100/month - FileStor add-on
  7. roattw
    Thanks IMDora. Will try that route!
  8. roattw
    Have reports with uploaded fiel hyperlinks. Is there anyway to get them to show full link in an exported Excel file? I only get a generic path (/Documents/fileneame). For $100/month they said I could get it thru FileStor. If the web hyperlink opens the file shouldnt it have a URL? Current web reports show a URL like this: https://xxxxxxxx.caspio.com/dp/3f2d4000070b68a1c9fe494a832b/files/2650879 which, when clicked, opens the file for download. But direct past in browser address bar gives a not found 404. Their work around was to create an HTMl page with link to each file
  9. roattw
    I have a report that returns matching search criteria including associated uploaded files. Is there a way bulk select or download those files? Imagine a select checkbox next to those we want to download.
  10. roattw
    This worked great until I switched to https://xxxxxx.caspio.com/folderlogout method. https://www.ucemcme.com/login?cbr=3f2d4000470970f687c94fd7a8b4
  11.    IMDora reacted to an answer to a question: Column/Cell align left: Another elusive css element
  12. roattw
    Thanks IMDora. Despite having cleared my Google cache I think it just wasnt caching properly. Later that night from home it appeared fine.
  13.    roattw reacted to an answer to a question: Really odd form radio and checkbox behavior
  14. roattw
    Have a datapage report field that is also included in an aggregation. Trying to left justify that column. Chrome Dev identifies two fields that affect this alignment as: .cbResultSetHeaderCellNumberDate and .cbResultSetTableCellNumberDate. If I change it in Chrome Dev Inspect it aligns column to left. .cbResultSetHeaderCellNumberDate { text-align: right; vertical-align: middle; white-space: nowrap; background-color: #dce6f1; padding: 5px; border-color: #eeeeee; border-width: 1px 1px 1px 1px; border-style: solid; } Also searched in Caspio that styles entire source code and sequentially changed all references to a text align=right to =left. Still no change to live page. Where is the PREVIEW of the page pulling that right setting from? Thanks for your patience.
  15. roattw
    You know, you are the best. I always make it more complicated than it needs to be! Thank you.
  16. roattw
    I have a Caspio form embedded on a Squarespace site. Trying to get it centered in the container it is in. And only this form element. Used Chrome dev inspector to identify the correct form element: cbTableDefaultCellspacing_2f084ae66f866d In Chrome dev when I set this to text-align: -webkit-center; the form centered within the container. How could I change this in the Caspio custom CSS area? Doesnt seem to recognize -webkit .... and center alone not working. Cant give you the URL because its a password protected site ;^/ But here is the source: <!doctype html> <html xmlns:og="http://opengraphprotocol.org/schema/" xmlns:fb="http://www.facebook.com/2008/fbml" xmlns:website="http://ogp.me/ns/website" lang="en-US" itemscope itemtype="http://schema.org/WebPage" > <head> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- This is Squarespace. --><!-- emcme --> <base href=""> <meta charset="utf-8" /> <title>FACULTY — UCEMCME</title> <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico"/> <link rel="canonical" href="https://www.ucemcme.com/faculty/"/> <meta property="og:site_name" content="UCEMCME"/> <meta property="og:title" content="FACULTY"/> <meta property="og:url" content="https://www.ucemcme.com/faculty/"/> <meta property="og:type" content="website"/> <meta itemprop="name" content="FACULTY"/> <meta itemprop="url" content="https://www.ucemcme.com/faculty/"/> <meta name="twitter:title" content="FACULTY"/> <meta name="twitter:url" content="https://www.ucemcme.com/faculty/"/> <meta name="twitter:card" content="summary"/> <meta name="description" content="" /> <script type="text/javascript" src="//use.typekit.net/ik/wRvJoiXy3f5iVxYPJtjejkFpBwd4a5nhPQwhKIQUJqbfe0CgfFHN4UJLFRbh52jhWDmyw2MtFDqoZewkjRsy5AmKZemqFc9o5sTlHKo8dAFlZPoDSWmyScmDSeBRZPoRdhXCZAuRdA90SaBujW48Sagyjh90jhNlOeUzjhBC-eNDifUujhmljhu8OcFzdPUaiaS0ZAuRdA90SaBujW48Sagyjh90jhNlOYiaikoujhmljhu8OcFzdPJwSY4zpe8ljPu0daZyH6qJn3IbMg6IJMJ7fbKlMsMMeMj6MKG4fJCgIMMjgkMfH6qJCMIbMg65JMJ7fbK0MsMMegM6MKG4fJ3gIMMjIPMfqMezET29gb.js"></script> <script type="text/javascript">try{Typekit.load();}catch(e){}</script> <script type="text/javascript">SQUARESPACE_ROLLUPS = {};</script> <script>(function(rollups, name) { if (!rollups[name]) { rollups[name] = {}; } rollups[name].js = ["//static.squarespace.com/universal/scripts-compressed/common-1373621dd1b2b6653f99-min.en-US.js"]; })(SQUARESPACE_ROLLUPS, 'squarespace-common');</script> <script crossorigin="anonymous" src="//static.squarespace.com/universal/scripts-compressed/common-1373621dd1b2b6653f99-min.en-US.js" ></script><script data-name="static-context">Static = window.Static || {}; Static.SQUARESPACE_CONTEXT = {"facebookAppId":"314192535267336","rollups":{"squarespace-announcement-bar":{"css":"//static.squarespace.com/universal/styles-compressed/announcement-bar-d41d8cd98f00b204e9800998ecf8427e-min.css","js":"//static.squarespace.com/universal/scripts-compressed/announcement-bar-916419e64d276e6525c0-min.en-US.js"},"squarespace-audio-player":{"css":"//static.squarespace.com/universal/styles-compressed/audio-player-6c42d60d26f4e09ab1ac335b4bc55b7e-min.css","js":"//static.squarespace.com/universal/scripts-compressed/audio-player-d644538e5a8e2e912023-min.en-US.js"},"squarespace-blog-collection-list":{"css":"//static.squarespace.com/universal/styles-compressed/blog-collection-list-d41d8cd98f00b204e9800998ecf8427e-min.css","js":"//static.squarespace.com/universal/scripts-compressed/blog-collection-list-623e704589688d0eec64-min.en-US.js"},"squarespace-calendar-block-renderer":{"css":"//static.squarespace.com/universal/styles-compressed/calendar-block-renderer-56713b1663346e1fe5b31a3adb8f31fc-min.css","js":"//static.squarespace.com/universal/scripts-compressed/calendar-block-renderer-5d77fd06ff0e64fb78d5-min.en-US.js"},"squarespace-chartjs-helpers":{"css":"//static.squarespace.com/universal/styles-compressed/chartjs-helpers-9935a41d63cf08ca108505d288c1712e-min.css","js":"//static.squarespace.com/universal/scripts-compressed/chartjs-helpers-37b477b5ca07d0c50553-min.en-US.js"},"squarespace-comments":{"css":"//static.squarespace.com/universal/styles-compressed/comments-c32adaffffa61675d5f238e2ea399b2b-min.css","js":"//static.squarespace.com/universal/scripts-compressed/comments-0a15781becc611d5a809-min.en-US.js"},"squarespace-commerce-cart":{"js":"//static.squarespace.com/universal/scripts-compressed/commerce-cart-2870139208d9ac5e8434-min.en-US.js"},"squarespace-dialog":{"css":"//static.squarespace.com/universal/styles-compressed/dialog-a5f874591a318ca818816c527ef525b3-min.css","js":"//static.squarespace.com/universal/scripts-compressed/dialog-acd7a7e31f0f5dcccaf3-min.en-US.js"},"squarespace-events-collection":{"css":"//static.squarespace.com/universal/styles-compressed/events-collection-56713b1663346e1fe5b31a3adb8f31fc-min.css","js":"//static.squarespace.com/universal/scripts-compressed/events-collection-f1c8b67551b883463072-min.en-US.js"},"squarespace-form-rendering-utils":{"js":"//static.squarespace.com/universal/scripts-compressed/form-rendering-utils-6d8034e032a2223aecb3-min.en-US.js"},"squarespace-forms":{"css":"//static.squarespace.com/universal/styles-compressed/forms-4af1b5b3c288ba939ea861fe2d37119a-min.css","js":"//static.squarespace.com/universal/scripts-compressed/forms-6532ae051da962e7a021-min.en-US.js"},"squarespace-gallery-collection-list":{"css":"//static.squarespace.com/universal/styles-compressed/gallery-collection-list-d41d8cd98f00b204e9800998ecf8427e-min.css","js":"//static.squarespace.com/universal/scripts-compressed/gallery-collection-list-f0c32f8dad553fd18889-min.en-US.js"},"squarespace-image-zoom":{"css":"//static.squarespace.com/universal/styles-compressed/image-zoom-ae974921915aeccaff8ad60c60e19c31-min.css","js":"//static.squarespace.com/universal/scripts-compressed/image-zoom-9d5d0792048b8f01d40b-min.en-US.js"},"squarespace-pinterest":{"css":"//static.squarespace.com/universal/styles-compressed/pinterest-d41d8cd98f00b204e9800998ecf8427e-min.css","js":"//static.squarespace.com/universal/scripts-compressed/pinterest-e19780a7eda176bdf3ca-min.en-US.js"},"squarespace-popup-overlay":{"css":"//static.squarespace.com/universal/styles-compressed/popup-overlay-6b891e5f689f032ce65af5855c067b4f-min.css","js":"//static.squarespace.com/universal/scripts-compressed/popup-overlay-f4d15bc31e9a8017a992-min.en-US.js"},"squarespace-product-quick-view":{"css":"//static.squarespace.com/universal/styles-compressed/product-quick-view-9abaaa4dfff182aa8d4ccf3b6ffdbe8d-min.css","js":"//static.squarespace.com/universal/scripts-compressed/product-quick-view-a86fcf38bc90f7f77e0f-min.en-US.js"},"squarespace-products-collection-item-v2":{"css":"//static.squarespace.com/universal/styles-compressed/products-collection-item-v2-ae974921915aeccaff8ad60c60e19c31-min.css","js":"//static.squarespace.com/universal/scripts-compressed/products-collection-item-v2-57cd4043c2e72d84d243-min.en-US.js"},"squarespace-products-collection-list-v2":{"css":"//static.squarespace.com/universal/styles-compressed/products-collection-list-v2-ae974921915aeccaff8ad60c60e19c31-min.css","js":"//static.squarespace.com/universal/scripts-compressed/products-collection-list-v2-f5c522ca69c981d726ce-min.en-US.js"},"squarespace-search-page":{"css":"//static.squarespace.com/universal/styles-compressed/search-page-9c747eeaabe96dacfea4932a63336f54-min.css","js":"//static.squarespace.com/universal/scripts-compressed/search-page-abb420b4effceb48aa15-min.en-US.js"},"squarespace-search-preview":{"js":"//static.squarespace.com/universal/scripts-compressed/search-preview-ba474737cbac82581def-min.en-US.js"},"squarespace-share-buttons":{"js":"//static.squarespace.com/universal/scripts-compressed/share-buttons-6d32f91d3d76b3be12c3-min.en-US.js"},"squarespace-simple-liking":{"css":"//static.squarespace.com/universal/styles-compressed/simple-liking-09fa291ec2800c97714f0d157fd0a6ca-min.css","js":"//static.squarespace.com/universal/scripts-compressed/simple-liking-4eeb7c106f5d51364d04-min.en-US.js"},"squarespace-social-buttons":{"css":"//static.squarespace.com/universal/styles-compressed/social-buttons-7a696232d1cd101fd62b5f174f9ae6ff-min.css","js":"//static.squarespace.com/universal/scripts-compressed/social-buttons-04d1522f7679f0db186b-min.en-US.js"},"squarespace-tourdates":{"css":"//static.squarespace.com/universal/styles-compressed/tourdates-d41d8cd98f00b204e9800998ecf8427e-min.css","js":"//static.squarespace.com/universal/scripts-compressed/tourdates-89389f002f2f64f56866-min.en-US.js"},"squarespace-website-overlays-manager":{"css":"//static.squarespace.com/universal/styles-compressed/website-overlays-manager-923311a5ffb05ecb734ddfc7d9be08bc-min.css","js":"//static.squarespace.com/universal/scripts-compressed/website-overlays-manager-23d2fee923cc5b76035b-min.en-US.js"}},"pageType":2,"website":{"id":"5a008799dc2b4a9ebded6e99","identifier":"emcme","websiteType":1,"contentModifiedOn":1522797029976,"cloneable":false,"siteStatus":{},"language":"en-US","timeZone":"America/New_York","machineTimeZoneOffset":-14400000,"timeZoneOffset":-14400000,"timeZoneAbbr":"EDT","siteTitle":"UCEMCME","siteDescription":"","logoImageId":"5a902a57c8302568a6b68bf3","shareButtonOptions":{"6":true,"3":true,"1":true,"4":true,"5":true,"7":true,"2":true,"8":true},"logoImageUrl":"//static1.squarespace.com/static/5a008799dc2b4a9ebded6e99/t/5a902a57c8302568a6b68bf3/1522797029976/","authenticUrl":"https://www.ucemcme.com","internalUrl":"https://emcme.squarespace.com","baseUrl":"https://www.ucemcme.com","primaryDomain":"www.ucemcme.com","sslSetting":3,"isHstsEnabled":false,"typekitId":"","statsMigrated":false,"imageMetadataProcessingEnabled":false},"websiteSettings":{"id":"5a008799dc2b4a9ebded6e9c","websiteId":"5a008799dc2b4a9ebded6e99","subjects":[],"country":"US","state":"OH","simpleLikingEnabled":true,"mobileInfoBarSettings":{"isContactEmailEnabled":false,"isContactPhoneNumberEnabled":false,"isLocationEnabled":false,"isBusinessHoursEnabled":false},"commentLikesAllowed":true,"commentAnonAllowed":true,"commentThreaded":true,"commentApprovalRequired":false,"commentAvatarsOn":true,"commentSortType":2,"commentFlagThreshold":0,"commentFlagsAllowed":true,"commentEnableByDefault":true,"commentDisableAfterDaysDefault":0,"disqusShortname":"","commentsEnabled":false,"storeSettings":{"returnPolicy":null,"termsOfService":null,"privacyPolicy":null,"paymentSettings":{},"expressCheckout":false,"continueShoppingLinkUrl":"/","useLightCart":false,"showNoteField":false,"shippingCountryDefaultValue":"US","billToShippingDefaultValue":false,"showShippingPhoneNumber":true,"isShippingPhoneRequired":false,"showBillingPhoneNumber":true,"isBillingPhoneRequired":false,"multipleQuantityAllowedForServices":true,"currenciesSupported":["CHF","HKD","MXN","EUR","DKK","USD","CAD","MYR","NOK","THB","AUD","SGD","ILS","PLN","GBP","CZK","SEK","NZD","PHP","RUB"],"defaultCurrency":"USD","selectedCurrency":"USD","measurementStandard":1,"orderConfirmationInjectCode":"","showCustomCheckoutForm":false,"enableMailingListOptInByDefault":false,"sameAsRetailLocation":false,"isLive":false},"useEscapeKeyToLogin":true,"ssBadgeType":1,"ssBadgePosition":4,"ssBadgeVisibility":1,"ssBadgeDevices":1,"pinterestOverlayOptions":{"mode":"disabled"},"ampEnabled":false},"cookieSettings":{"isRestrictiveCookiePolicyEnabled":false},"websiteCloneable":false,"collection":{"title":"FACULTY","id":"5a8333f4e4966b69c093e3c8","fullUrl":"/faculty/","type":10},"subscribed":false,"appDomain":"squarespace.com","templateTweakable":true,"tweakJSON":{"aspect-ratio":"Auto","gallery-arrow-style":"Circular","gallery-aspect-ratio":"3:2 Standard","gallery-auto-crop":"true","gallery-autoplay":"false","gallery-design":"Grid","gallery-info-overlay":"Show on Hover","gallery-loop":"true","gallery-navigation":"Circles","gallery-show-arrows":"true","gallery-transitions":"Fade","galleryArrowBackground":"rgba(34,34,34,1)","galleryArrowColor":"rgba(255,255,255,1)","galleryAutoplaySpeed":"3","galleryCircleColor":"rgba(255,255,255,1)","galleryInfoBackground":"rgba(0, 0, 0, .7)","galleryThumbnailSize":"100px","gridSize":"320px","gridSpacing":"20px","product-gallery-auto-crop":"true","product-image-auto-crop":"true"},"templateId":"4f6a1392e4b07090d46e7ec9","pageFeatures":[1,2,4],"impersonatedSession":false,"demoCollections":[{"collectionId":"527d3781e4b05acc5f1bb99c","deleted":true},{"collectionId":"527d37a8e4b080fe1829dc73","deleted":true},{"collectionId":"527d37a1e4b080fe1829dc66","deleted":true},{"collectionId":"58d93ec6579fb308147cbfef","deleted":false}],"isFacebookTab":false,"tzData":{"zones":[[-300,"US","E%sT",null]],"rules":{"US":[[1967,2006,null,"Oct","lastSun","2:00","0","S"],[1987,2006,null,"Apr","Sun>=1","2:00","1:00","D"],[2007,"max",null,"Mar","Sun>=8","2:00","1:00","D"],[2007,"max",null,"Nov","Sun>=1","2:00","0","S"]]}},"useNewImageLoader":true};</script><script type="text/javascript"> SquarespaceFonts.loadViaContext(); Squarespace.load(window);</script><script type="application/ld+json">{"url":"https://www.ucemcme.com","name":"UCEMCME","description":"","image":"//static1.squarespace.com/static/5a008799dc2b4a9ebded6e99/t/5a902a57c8302568a6b68bf3/1522797029976/","@context":"http://schema.org","@type":"WebSite"}</script><!--[if gte IE 9]> <link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&part=1"/><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&part=2"/><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&part=3"/><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&part=4"/><![endif]--> <!--[if lt IE 9]><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&noMedia=true&part=1"/><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&noMedia=true&part=2"/><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&noMedia=true&part=3"/><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false&noMedia=true&part=4"/><![endif]--> <!--[if !IE]> --><link rel="stylesheet" type="text/css" href="//static1.squarespace.com/static/sitecss/5a008799dc2b4a9ebded6e99/36/4f6a1392e4b07090d46e7ec9/5a83279741920261fa666c1e/1588-05142015/1522793484851/site.css?&filterFeatures=false"/><!-- <![endif]--> <!-- End of Squarespace Headers --> </head> <body class="underline-body-links blog-meta-data-split hide-author social-icon-style-round show-products-category-navigation event-show-past-events event-thumbnails event-thumbnail-size-32-standard event-date-label event-list-show-cats event-list-date event-list-time event-list-address event-icalgcal-links event-excerpts gallery-design-grid aspect-ratio-auto lightbox-style-light gallery-navigation-circles gallery-info-overlay-show-on-hover gallery-aspect-ratio-32-standard gallery-arrow-style-circular gallery-transitions-fade gallery-show-arrows gallery-auto-crop gallery-loop product-list-titles-under product-list-alignment-center product-item-size-11-square product-image-auto-crop product-gallery-size-11-square product-gallery-auto-crop show-product-price show-product-item-nav product-social-sharing newsletter-style-dark hide-opentable-icons opentable-style-dark small-button-style-solid small-button-shape-square medium-button-style-solid medium-button-shape-square large-button-style-solid large-button-shape-square image-block-poster-text-alignment-center image-block-card-dynamic-font-sizing image-block-card-content-position-center image-block-card-text-alignment-left image-block-overlap-dynamic-font-sizing image-block-overlap-content-position-center image-block-overlap-text-alignment-left image-block-collage-dynamic-font-sizing image-block-collage-content-position-top image-block-collage-text-alignment-left image-block-stack-dynamic-font-sizing image-block-stack-text-alignment-left button-style-outline button-corner-style-rounded tweak-product-quick-view-button-style-floating tweak-product-quick-view-button-position-bottom tweak-product-quick-view-lightbox-excerpt-display-truncate tweak-product-quick-view-lightbox-show-arrows tweak-product-quick-view-lightbox-show-close-button tweak-product-quick-view-lightbox-controls-weight-light native-currency-code-usd collection-type-page collection-layout-default collection-5a8333f4e4966b69c093e3c8 mobile-style-available" id="collection-5a8333f4e4966b69c093e3c8"> <div id="site"> <div id="canvas"> <div id="headerWrapper"> <header id="header"> <div id="headerInfo"> <h1 class="logo image"> <a href="/" title="UCEMCME" role="bookmark" data-content-field="site-title"> <span class="placed-logo-image"><img src="//static1.squarespace.com/static/5a008799dc2b4a9ebded6e99/t/5a902a57c8302568a6b68bf3/1522797029976/?format=1500w" alt="UCEMCME" /></span> </a> </h1> <script> Y.use('squarespace-ui-base', function(Y) { Y.one("h1.logo").plug(Y.Squarespace.TextShrink, { parentEl: Y.one('#header'), minFontSize: 16 }); if (Y.one('p.site-tagline')){ Y.one("p.site-tagline").plug(Y.Squarespace.TextShrink, { parentEl: Y.one('#header'), minFontSize: 12 }); } }); </script> <div id="navBlock" role="navigation"> <nav class="main-nav" data-content-field="navigation"> <ul> <li class="page-collection"> <a href="/">Home</a> </li> <li class="page-collection active-link"> <a href="/faculty/">FACULTY</a> </li> <li class="page-collection"> <a href="/cme-resources/">CME RESOURCES</a> </li> <li class="events-collection"> <a href="/calendar/">CALENDAR</a> </li> <li class="page-collection"> <a href="/registration/">REGISTRATION</a> </li> <li class="external-link"> <a href="https://c3ebv137.caspio.com/folderlogout">LOGOUT</a> </li> </ul> <select id="mobileSelect" name="mobileSelect"> <option class="mobile-select-label" value="">Navigation</option> <option class="page-collection" value="/">Home</option> <option class="page-collection" value="/faculty/" selected="selected">FACULTY</option> <option class="page-collection" value="/cme-resources/">CME RESOURCES</option> <option class="events-collection" value="/calendar/">CALENDAR</option> <option class="page-collection" value="/registration/">REGISTRATION</option> <option class="external-link" value="https://c3ebv137.caspio.com/folderlogout">LOGOUT</option> </select> </nav> </div> <!-- CATEGORY NAV --> </div> </header> </div><!-- / headerWrapper --> <div id="pageWrapper" class="hfeed" role="main"> <section id="page" data-content-field="main-content"> <div class="sqs-layout sqs-grid-12 columns-12" data-type="page" data-updated-on="1522797029975" id="page-5a8333f4e4966b69c093e3c8"><div class="row sqs-row"><div class="col sqs-col-12 span-12"><div class="row sqs-row"><div class="col sqs-col-6 span-6"><div class="sqs-block code-block sqs-block-code" data-block-type="23" id="block-yui_3_17_2_3_1518551392327_7619"><div class="sqs-block-content"><script type="text/javascript" src="https://c3ebv137.caspio.com/dp/3f2d400051709a557944480191d0/emb"></script> <div class="cxkg"><a href="https://c3ebv137.caspio.com/dp/3f2d400051709a557944480191d0">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> </div></div></div><div class="col sqs-col-6 span-6"><div class="sqs-block code-block sqs-block-code" data-block-type="23" id="block-yui_3_17_2_3_1518713752666_16252"><div class="sqs-block-content"><div align="right"><a class="caspio-button-link" href="https://c3ebv137.caspio.com/dp/3f2d400007660a186924499d9937"><button class="caspio-button-blue">Update Profile</button></a> </div></div></div></div></div><div class="row sqs-row"><div class="col sqs-col-2 span-2"><div class="sqs-block spacer-block sqs-block-spacer sized vsize-1" data-block-type="21" id="block-yui_3_17_2_1_1522796973491_5871"><div class="sqs-block-content">&nbsp;</div></div></div><div class="col sqs-col-8 span-8"><div class="sqs-block code-block sqs-block-code" data-block-type="23" id="block-yui_3_17_2_18_1518551392327_5352"><div class="sqs-block-content"><script type="text/javascript" src="https://c3ebv137.caspio.com/dp/3f2d4000080f679f1f3b4b5a9c59/emb"></script> <div class="cxkg"><a href="https://c3ebv137.caspio.com/dp/3f2d4000080f679f1f3b4b5a9c59">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <script> function hideAuth(){ 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> </div></div></div><div class="col sqs-col-2 span-2"><div class="sqs-block spacer-block sqs-block-spacer sized vsize-1" data-block-type="21" id="block-yui_3_17_2_1_1522796973491_6821"><div class="sqs-block-content">&nbsp;</div></div></div></div><div class="sqs-block spacer-block sqs-block-spacer sized vsize-1" data-block-type="21" id="block-3f421402271937d76dca"><div class="sqs-block-content">&nbsp;</div></div><div class="sqs-block code-block sqs-block-code" data-block-type="23" id="block-d70e090c3f907529257b"><div class="sqs-block-content"><script type="text/javascript" src="https://c3ebv137.caspio.com/dp/3f2d40006d249a715cef4f2daf5b/emb"></script> <div class="cxkg"><a href="https://c3ebv137.caspio.com/dp/3f2d40006d249a715cef4f2daf5b">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <script> function hideAuth(){ 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> </div></div><div class="sqs-block code-block sqs-block-code" data-block-type="23" id="block-f7cd2d913c1821fb4d7e"><div class="sqs-block-content"><script type="text/javascript" src="https://c3ebv137.caspio.com/dp/3f2d4000dbdff549707045d48fc7/emb"></script> <div class="cxkg"><a href="https://c3ebv137.caspio.com/dp/3f2d4000dbdff549707045d48fc7">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <script> function hideAuth(){ 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> </div></div></div></div></div> </section> </div><!-- / pageWrapper --> <div id="footerWrapper"> <footer id="footer"> <div class="sqs-layout sqs-grid-12 columns-12 empty" data-layout-label="Footer Content" data-type="block-field" data-updated-on="1518546968713" id="footerBlock"><div class="row sqs-row"><div class="col sqs-col-12 span-12"></div></div></div> </footer> </div><!-- / footerWrapper --> </div><!-- / canvas --> </div><!-- / site --> <script type="text/javascript" data-sqs-type="imageloader-bootstraper">(function() {if(window.ImageLoader) { window.ImageLoader.bootstrap({}, document); }})();</script><script>Squarespace.afterBodyLoad(Y);</script> <script type="text/javascript" src="https://static1.squarespace.com/static/ta/4f6798afe4b097349e410d49/1588/scripts/combo/?site.js"></script> </body> </html>
  17. roattw
    I admit to not being very good with calculated fields and SQL statements. But I have been trying to understand. Every example reference I get I double check and learn about at: https://www.w3schools.com/sql/ But nearly everytime I do a calculated field it hates the syntax that I got from W3Schools or a Caspio forum user. So for Caspio specifically, is there a finite and known list of SQL commands and syntax we have to follow - so we dont waste our time with fucntions that wont work in Caspio? And are these correct assumptions? for number functions the number gets no quotes (ie WHERE field_name = 1) for text string questions you do use quotes (ie WHERE field_name = "some text") concluding semicolon not needed? Get stuff to work sometimes with the ; sometimes or without it others Is table_name reference literally just the table name (ie contacts) with no formatting All references to a field must be in this format [@field:field_name] I have tried some very basic forum suggested code and they always fail to verify. For example: SELECT COUNT(ID) FROM table_name WHERE ID = target.[@field:incidentID] or select count(user_id) from table_name where CME_Category='Value' What am I missing (other than basic skills ;^)
  18. roattw
    At ucstroke.com on a mobile phone my checkboxes are behaving oddly. PC or laptop version fine. In phone responsive mode the checkbox selected shows 2 checkmark... And radio buttons show one button and one vertical line. The line is a button, select it and it becomes a button and the other one becomes just a line. Im baffled. :smileytongue:
×