Jump to content

roattw

Caspio Guru
  • Posts

    204
  • Joined

  • Last visited

  • Days Won

    3

Posts posted by roattw

  1. I know this has been done in several variations with list boxes and autocomplete. But I cant get it to fire in my scenario.  Possibly because Im trying to accomplish this with same table/DP?

    Two fields A and B. 

    Field A is Yes/No.  B is hidden waiting to receive a value.

    If A=Yes, hidden field B should be completed with value "candidate".

    Simple, but alluding me.

    Triggered action, calculated field or passed parameter?

    Hoping not to have a separate table just for this option, only to put it back in there with a view.

     

     

  2. I have a site I need to increase space between listbox items, increase space between checkbox and label, and show full list box item width, and maybe loose scroll (show all).

    1.jpg.e732165ecf71b7f00963bfb21ce290c9.jpg

    Chrome Dev clearly shows the the code, .ListData .Item and when I increase line-height: it increases space between listbox line choices.  Some of the code comes from Weebly were hosted, and some from Caspio.  But I cant find this resultant CSS in the Weebly style editor or the Caspio style editor.  Chrome Dev seems to point it to code originating from Caspio though: https://c3ebv137.caspio.com/scripts/Core/Dialog.css and I dont know how to access that area.  Thoughts?

    Need to
    1.  which margin or padding woud increase space btwn check box and label entry.

    2.  Expand  box area to show full entries veritcally and horizontally, no scroll?

    2.jpg.7cb82ac083de655598a173bceefe8d24.jpg

  3. All of a sudden people are reporting an increase in those Firefox and Chrome warnings for our sites like invalid certificate, Connection not secure,  Connection not private messages. 

    Firefox reports the certificate/connection not secure:

    2018-11-20_7-52-58.png.d4d56c87225ec6c2e835679fdbeadc66.png

     

    Chromes seems to give the Connection not private:

    2018-11-20_8-06-28.png.10d48b9daccd426916b8d55f3b33985b.png

     

    All embeded code and URLs reference https:   Not sure how to avoid this, or why all of a sudden its started.

    Thoughts?  Many thanks!

  4. 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.

     

    2018-08-16_12-23-40.thumb.png.52f973a6586bd30c819b86b5a96637e6.png

     

     

  5. Data not getting passed correctly.  Following the instructions I have:

    New Text Field (64000) to receive the email body:

    1.jpg.333cb2b6dc67ef27218822a2752f3954.jpg

    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: 

    2.jpg.e3eb870e5e47d027fc89ec8f00edae3f.jpg

    3.jpg.b85fad9fe3a1b1b9b5e255f81cc2e5fa.jpg

    Im getting blank notification emails.

     

  6. 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

  7. 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.

    css1.png.15defe8178e87a0e34108851ea7bb8c4.png


    css2.png.9469e74c7f0814967a6a467b808609d0.png

  8. 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. 

    css.thumb.png.1d0ede542d2bc5fcb3dbf8a08517ac9b.png

    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>

     

  9. 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?

    1. for number functions the number gets no quotes (ie WHERE field_name = 1) 
    2. for text string questions you do use quotes (ie WHERE field_name = "some text") 
    3. concluding semicolon not needed?  Get stuff to work sometimes with the ; sometimes or without it others
    4. Is table_name reference literally just the table name (ie contacts) with no formatting
    5. 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 ;^)

  10. Id like to get a Time Picker (like the calendar date field picker but with just time).  Caspio refers me to: Separate-input-fields-for-datetime-parts

    Possible solution but kind of honorous. 

    I stumbled upon the newer HTML5 option:  <input id="time" type="time">.  Placed in an HTML box this provides exactly what I/we need - 

    <input id="time" type="time">

    2018-03-16_14-20-28.jpg.b2842bcc19c0d8a161f1873769d23567.jpg

    How can I pass whatever is in this input field to a field in my datapage and/or database?  Seems way easier than the proposed caspio method.

×
×
  • Create New...