Jump to content


Caspio Evangelist
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi @ShadowSovereign, I heard that Integromat platform also has a Caspio app available for integration with 3rd party tools. Regards, Vitalikssssss
  2. Hi @jimarch, You can utilize Cascading radio buttons and lookup table which would output all possible combination of ranks. Users will be forced to submit their "rank" choices for each location in sequential order. Your first location will have radio-buttons "1-4 " and each next location will have a set of radio - buttons without the one selected on the previous step. You may upload the following app sample and test above - mentioned workflow in the Data page I have created: App Regards, vitalikssssss
  3. Hi @PlaceWorks, It would help a lot if could share a screenshot of a table relationship between tables. Also, please let me know if you have cascade update and/or delete enabled in relationship settings. Regards, vitalikssssss
  4. Hi @kpcollier, You can check the status before the update to make sure it is not equal to the list of previous statuses. Here is an example for one of the Trigger blocks: Hope this helps. Regards, vitalikssssss
  5. Hi @DaveC2019, I think the calculated value form element might be the right feature to implement the described workflow. You can find more about this element in the following article: https://howto.caspio.com/datapages/datapage-components/calculated-values/ Hope this helps. Regards, vitalikssssss
  6. Hello @valentid, I have an application in which I have solved a similar case. The purpose of this app is to track booking request. I have deployed a simplified version of this app at the following site: https://sites.google.com/view/caspio-booking-app/home This app requires 2 Datapages, 4 Tables, 1 Triggered action. Datapage: Submission Form - to insert booking request. Calendar Datapage - to show all request made for different users. Tables: Users_tbl - holds information about users; Booking_request_tbl - holds information about booking requests; Booking_days_tbl - holds information about each day booking was made. Booking_Period_Lu - lookup table used in Triggered action. Triggered action - used to insert booking period data to Booking_days_tbl as a separate date. Hope this helps. Regards, vitalikssssss
  7. Hi @LynnR , Your query from the first post looks correct. Try to play around with Localization settings on the field level. Regards, vitalikssssss
  8. Hi @LynnR, I would assume that your calculated field has currency formatting applied. Make sure that your calculated field formatting set to "None" in order to remove currency sign. Hope this helps. Regards, vitalikssssss
  9. @abitaquest it is better to open a ticket to Caspio Support since this behavior looks very odd.
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. Hi @Mike1633 , What type of Report page do you use? Tabular, Details, Gallery etc.
  19. 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
  20. 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
  21. Hi @dmyoungsal, Please make sure that you select a "Display Value" in the relationship settings. Hope this helps. Regards, vitalikssssss
  22. 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
  23. 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
  24. 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
  25. 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
  • Create New...