Jump to content


Caspio Guru
  • Content count

  • Joined

  • Last visited

  • Days Won


Vitalikssssss last won the day on March 22

Vitalikssssss had the most liked content!


About Vitalikssssss

  • Rank
    Advanced Member

Recent Profile Visitors

1,034 profile views
  1. Vitalikssssss

    Chrome login loop

    Hi @gsgriffin, This behavior makes me think that some users disabled third-party cookies in their browser settings. Hope this helps. Regards, vitalikssssss
  2. Vitalikssssss

    SELECT COUNT() possible?

    Hi @AndrewCHughes, It is possible to specify COUNT function in REST API query which will return a count of matched records. Here is a simple example: Hope this helps. Regards, vitalikssssss
  3. Vitalikssssss

    Replace document.write with innerHTML

    Hi @Heineperson, You can try following code with inner HTML: <div id='record[@cbRecordIndex#]'></div> <script type="text/javascript"> debugger; document.addEventListener('DataPageReady', function (event) { if ("[@field:tblRareTaxonTable_ProfileStatus]" == "Active") { document.write("<div style='background:#A0CE4E;border:1px solid #000000;padding:5px 10px;'><span style='font-size:16px;'><strong><a href='https://saveplants.org/national-collection/plant-search/plant-profile/?CPCNum=[@field:tblRareTaxonTable_CPCNumber]' <span style='color:#482441;'>Go To Profile</span></a></strong></span></div>"); } else { document.write("<div style='background:#482441;border:1px solid #000000;padding:5px 10px;'><span style='font-size:16px;'><span style='color:#FFFFFF;'><strong>Profile In Progress</strong></span></span></div>"); } }); </script> Hope this helps. Regards, vitalikssssss
  4. Vitalikssssss

    Complex Search logic with Date/Time field

    Hi there, Could anyone help me to resolve the issue with the following search logic scenario: a user can search by Date field with "from&to" range with criteria, but if criteria are blank I would like to return records with blank Date field Field datetype: Date&Time Thanks, @Vitalikssssss
  5. Vitalikssssss

    Move Submit button

    Hi @Fibonacciphil, You can find the solution in this post . Regards, vitalikssssss
  6. Hi everyone, Does anyone know how to submit textarea field by pressing Enter button on the keypad?
  7. Vitalikssssss

    Login for REST API

    Hi @Medron, You can find a list of all available REST API methods in Swagger. More information available in this article: https://howto.caspio.com/web-services-api/rest-api/swagger-ui/ Regards, vitalikssssss
  8. Vitalikssssss

    Show distinct records

    Hi @cbaker10, You would need to use separate tables: Table 1 for courses with assigned teachers Table 2 for enrollments These tables should have a one-to-many relationship. For your report, you should use Table 1 and Calculated field with SQL expression if you would like to display a count of enrollments from Table 2. Alternatively, you can use your existing View and Collapsible Group of records by teacher name. Here is the link to an article about : https://howto.caspio.com/datapages/reports/advanced-reporting/data-grouping/ Hope this helps. Regards, vitalikssssss
  9. Hi @georgep, You can try using the following code: <div id="icon"></div> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if ('[@field:XXXX]' != '') { document.getElementById("icon").innerHTML='<a href="[@field:XXXX]" target="_blank"> <img src="../resources/File_icon_INS.png" alt="Files" height="40" width="40" /></a>'; } }); </script> Hope this helps.
  10. Vitalikssssss

    Specific details needed for failed records on import

    Hi @janetflorence, I have experienced the same issue too. I doubt that you could get a detailed description within current feature set of Caspio Bridge. We should bring this to the attention of Caspio Product Team. Please vote in Caspio Idea Box for the feature enhancement: http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/7688223-describe-upload-errors Thanks, @vitalikssssss
  11. Hello @roattw, You can place following CSS into Datapage Header in order to place the form in the center of a web-page. <style> table { margin: 0 auto ; } </style> Hope this helps. Regards, vitalikssssss
  12. Vitalikssssss

    Order Form - multiple entries

    Hi @jeffs88keys , I would suggest taking a look at Tabular Report Datapage with Inline insert option enabled if you would like to add multiple items by single Datapage. https://howto.caspio.com/datapages/reports/data-editing-options-in-reports/ Hope this helps. Regards, vitalikssssss
  13. Vitalikssssss

    Populate a DataPage Field Based on User Input

    Hi @faile486, You can use Cascading Dropdown form element in order to automatically populate dropdown options based on the previous selection of user. You may find more details in the following article: https://howto.caspio.com/datapages/datapage-components/cascading-elements/ Regards, vitalikssssss
  14. Vitalikssssss

    Limit calculated field decimal places in footer of datapage

    Hi @DesiLogi, You can define formatting settings for a particular field in order to over-write Datapage localization settings. Hope this screenshot helps: Regards, @Vitalikssssss
  15. Vitalikssssss

    Data Validation in In line Edit

    Hi @NeoInJS , I was able to create validation check for Inline edit with jquery. You should wrap your fields in div with ID. Also, you need to disable ajax on your report and paste the following script in the footer. You can use following code as an example. Header <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <div id="cbform-improvement"> Footer: </div> <script> $("#cbform-improvement #Mod0InlineEdit").click(function(e){ window.alert("check"); if(document.getElementsByName("InlineEditHours")[0].value > 100) { window.alert("save!"); } else if (document.getElementsByName("InlineEditHours")[0].value > 1000) { window.alert("do not save!"); return false; } else { window.alert("do not save!"); return false; } }); </script> Hope this helps. Regards, @Vitalikssssss