Vitalikssssss

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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