Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. @abitaquest it is better to open a ticket to Caspio Support since this behavior looks very odd.
  2. Hi @abitaquest, I know that file size limit for scheduled task and manual export is different. The scheduled task export/import: file should be 50 Mb or less. Manual export: file should be 1Gb or less. Make sure that your table fits the size limit. Hope this helps. Regards, vitalikssssss
  3. Hi there, I would appreciate if someone could help me modifying styles of a dropdown on inline insert functionality of Tabular Report Datapage. I have a Cascading dropdown "EMAIL" where I would like to assign a special font and add a bottom border for each option. The challenge I am facing is that I have other dropdowns on this Datapage and I would like them to preserve default styling. Thanks, vitalikssssss
  4. Hi @heinepeople , You may try to add STUFF statement as described in this topic . STUFF( (SELECT ' | ' + CAST (CommonName AS nvarchar) FROM tblPlantCommonName WHERE CPCNum = target.[@field:CPCNumer] FOR XML PATH ('')) , 1, 2, '') Hope this helps. Regards, vitalikssssss
  5. Hi @ray, You cannot reference fields in HTML block in the submission form. You can, however, receive external parameter [@Task] in HTML block and apply to style in there e.g. : <span style="color:blue">[@Task]</span> Hope this helps. Regards, vitalikssssss
  6. Hi @vanderLeest, I do not think that you need to use a JS code to achieve the desired workflow. You can make fields "User ID" and field for a timestamp hidden and receive the desired parameter upon record submit. Hope this helps. regards, vitalikssssss
  7. 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
  8. 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
  9. 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
  10. Hi @Mike1633 , What type of Report page do you use? Tabular, Details, Gallery etc.
  11. 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
  12. 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 top
  13. Hi @dmyoungsal, Please make sure that you select a "Display Value" in the relationship settings. Hope this helps. Regards, vitalikssssss
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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,
  21. 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
  22. Hi @techguy , You should hide a default button with CSS and add custom one in HTML block. Place an HTML block at the bottom of a search fields list and insert following snippet of code there: <div id="target"></div> Finally, add the following snippet of code to search form Footer: <script type="text/javascript"> document.addEventListener('DataPageReady', moveBtn, false); function moveBtn() { var btn = document.getElementsByName('searchID')[0]; var target = document.getElementById('target') target.appendChild(btn); } </script>
  23. Hi @Colnocode , Thank you for the details you have sent. I am afraid the reason that you do not want to use actual field because you will spoil the original email message makes no sense to me. You can use a standard Text255 field instead of the Virtual field and assign Cascading Text field form element and Table(1) will be a lookup for this field. Please note that you will not be able to change the records from lookup table within the current design of Caspio. You can share with me the screenshots/links to your datapages in PM. I will be glad to help you. Re
  24. Hi @hayaa, Perhaps you can add a Virtual field to the submission form where a user can select if he has an account or no. You can create a dynamic re-direct after form submission as described in this article: https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/ Hope this helps. Regards, vitalikssssss
  25. Hi @Shuchi, I believe that this won`t be possible with the current feature set of Caspio. You may use Triggered Action and a separate table to store distinct values. I will be able to offer you a more precise suggestion if you provide me with more details about the place where you will use the View with distinct values. Regards, vitalikssssss
  • Create New...