Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Vitalikssssss last won the day on December 20 2018

Vitalikssssss had the most liked content!


About Vitalikssssss

  • Rank
    Advanced Member

Recent Profile Visitors

1,334 profile views
  1. Hi @geoffdude , You can use "Update" action which will update the data of an existing table with the imported data and add new records which do not exist in your Caspio Table. The import will add to your Caspio table only 15 records and update 100 of existing records if you made any changes in them. You should have a correspondent unique field in Caspio Table and Excel spreadsheet in order to perform this type of import "Action". Also, currently Caspio Datahub cannot import data from google spreadsheet and you need to have an Excel copy of your spreadsheet in Google drive account to perform the Datahub import as far as I know. Hope this helps. Regards, vitalikssssss
  2. Hi @ChristofK, Did you consider creating a validation with a Triggered Action feature? https://howto.caspio.com/tables-and-views/triggered-actions/ This type of validation will require relatively simple Trigger on record update. Here is an example: Hope this helps. regards, vitalikssssss
  3. Vitalikssssss

    Checkbox/Radio Buttons for Search Field Blank/Not Blank

    Hi @kpcollier, I think you can create a Formula field in your table with a case expression to check if the field "Shipping Confirmation" is empty or not. Here is an example of Formula expression: CASE WHEN Len([@field:Shipping_Date])>0 THEN 'YES' ELSE 'NO' END Next, you should use this field in your search criteria and assign "Checkbox" form element. You should use the following settings: Hope this helps. Regards, vitalikssssss
  4. Vitalikssssss

    dynamic field code data

    Hi @Mike1633 , What type of Report page do you use? Tabular, Details, Gallery etc.
  5. Vitalikssssss

    How to access/set up for Scheduled Task to google drive?

    Hi @geoffdude, The desired type of repositories might be unavailable if your account has a legacy plan. You should switch to the latest Caspio plan in order to have the desired options. Hope this helps. Regards, vitalikssssss
  6. Vitalikssssss

    Hyperlink to set a Yes/No field

    Hi @CornCasper , You can change a value in one field with a single click if you use the following concept: 1. Create a single record update form; 2. Set the default value as "Yes" to the field in question; 3. Copy the deploy URL of above datapage; 4. Generate a code for a pop-up window with links/menu generator. 4. Add an HTML block in your report datapage and insert the code for a pop-up window; 6. Specify the string parameter of the unique identifier of a record; 7. Add auto-submit javascript to the single record update form as explained in this topic. Hope this helps. Regards, vitalikssssss
  7. Vitalikssssss

    Relationship not working (2)

    Hi @dmyoungsal, Please make sure that you select a "Display Value" in the relationship settings. Hope this helps. Regards, vitalikssssss
  8. Vitalikssssss

    Formula field in another formula field.

    Hi @AnchovyXL , You may consider using Triggered Action if you need cross-table calculation. https://howto.caspio.com/tables-and-views/triggered-actions/ Hope this helps. Regards, vitalikssssss
  9. Vitalikssssss

    Embed Deployment Code Not Working In Weebly

    Hi @kpcollier, Can you share with us a code which you used for the tabbed interface? Do you have any custom JS in your Datapages? Regards, vitalikssssss
  10. Vitalikssssss

    Hide results

    You can play around with CSS in Caspio Styles in order to hide this messages. Style -> Source -> All You need to add/modify the following line of code in the following classes: display:none; CSS classes: .cbResultSetRecordMessage .cbFormError .cbFormRequiredMarker I would recommend to duplicate your existing Style and apply the above-mentioned changes in the duplicate copy. Regards, vitalikssssss
  11. Vitalikssssss

    Hide results

    Hi @Heather, Perhaps you can use a method described in the following HowTo article: https://howto.caspio.com/getting-started/display-results-on-a-separate-web-page/ Hope this helps. Regards, Vitalikssssss
  12. Vitalikssssss

    Want to Search by Text String, not Autonumber

    Hi @simishu, I can suggest creating a View which would join your Tables Developer and Details in order to have the ability to search by the name of the developer (Developer_Name field from Developer table) with Autocomplete form element. You can use a View as a data source for your report Datapage. Please check this article for more insights: https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/ Regards, vitalikssssss
  13. Vitalikssssss

    How do I Count Data in Fields?

    You can use SQL statements in Calculated, Total&Aggregation fields and also if you assign Calculated value form element to a field from submission form. Regards, vitalikssssss
  14. Hi @techguy , The easiest way I see is to use a standalone Details page with a Calculated field in which you can write SQL statement. https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ You can insert a value from the Calculated field into HTML block with a parameter picker. You may use technic with HTML block described in the following article to hide the Calculated field from a user: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ Hope this helps. Regards, vitalikssssss
  15. Here is a slightly updated code: <button onclick="resetForm()" type="button" class="cbSearchButton">Clear Form</button><script> function resetForm() { var myForm = document.querySelectorAll('form[action*="[@cbAppKey]"] input[type=text]'); myForm.forEach(function(elem) { elem.value=""; }); } </script> Regards, vitalikssssss